Daniel Adeniji

My feedback

  1. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji shared this idea  · 
  2. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji shared this idea  · 
  3. 4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 5

    <=-=May 31 2016 2:02AM=-=>

    What a ridiculous limit! sqlcmd only reads the input text file. Why is there a 2GB-limit?

    Even worse the error messages indicates something wrong with my SQL statements, just because text is truncated. Maybe you could give a hint about the file size limit instead of letting me search for errors in my file

    Have you ever migrated a database from another db vendor to SQLServer via dump?

    Please excuse me, I just lost three hours on that 32bit bug. I’m a little bit angry now.

    <=-=Aug 21 2016 3:08AM=-=>

    I have the same problem, but my input file is about 50GB of size. It was a long way to find this limitation, so I recommend that you will add this limitation in msdn documentation of sqlcmd.

    <=-=Jan 31 2017 3:03AM=-=>

    Totally agree.
    There are a wealth of reasons why people sometimes need to…

    Daniel Adeniji supported this idea  · 
  4. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji supported this idea  · 
  5. 136 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    18 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 3

    <=-=Jan 8 2018 12:16PM=-=>

    Thanks for the suggestion.
    We’ll consider it for a future release.

    Are there specific limitations imposed when you have the filegroup, e.g., no database snapshot, that hold you back from creating the filegroup?
    Or is it only the feeling of not being able to turn back?


    Jos de Bruijn – Database Systems PM

    An error occurred while saving the comment
    Daniel Adeniji commented  · 

    Family :-

    I spoke way too early.

    What triggers the no go back is actually creating memory optimized objects inside the database.

    An error occurred while saving the comment
    Daniel Adeniji commented  · 

    Family :-

    It appears that the issue of not been able to remove empty MEMORY_OPTIMIZED_DATA filegroups has been addressed.

    I tested against :-

    Version :- Microsoft SQL Server 2019 (CTP3.2) - 15.0.1800.32 (X64)

    Release Date :- 2019-July-17

    Documented here :-
    https://learningintheopen.org/2019/09/29/sql-server-database-management-v2019-ctp/

    Daniel Adeniji supported this idea  · 
  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji shared this idea  · 
  7. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji shared this idea  · 
  8. 201 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  20 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji supported this idea  · 
  9. 285 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji supported this idea  · 
  10. 330 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 249

    <=-=Oct 4 2016 2:15PM=-=>

    This is similar to my feedback located here: https://connect.microsoft.com/SQLServer/feedback/details/2769130/sql-2016-temporal-tables-with-triggers. The solution I suggest is similar to this, and could be used in many different cases developing using SQL server.

    <=-=Jan 10 2017 9:43AM=-=>

    I would love this too. The issue is that many/most applications don’t use Windows Auth in the connection to SQL Server (connection pooling issues, etc), so SQL can’t get the User information

    <=-=Jan 10 2017 9:51AM=-=>

    @Sanford

    Just to clarify, I am not asking for an “automatically store user name” feature. I’m asking for “automatically store whatever I want, based on whatever expression I provide.” So the fact that the user name may or may not be available is not really relevant.

    That said, there are plenty of workarounds for various situations. I imagine that if you’re using a shared connection, you can get some notion of “user” some other…

    Daniel Adeniji supported this idea  · 
  11. 389 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  15 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji supported this idea  · 
  12. 11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Daniel Adeniji commented  · 

    Danni Juhl :-

    Thanks for posting the exception.

    That likely facilitated Google's ability to match my problem with your solution.

    For me, I simply used the matching SSMS Client version to re-import the package.

    Steps :-

    1) Existed SSMS 2014
    2) Launched SSMS v2014
    3) Connected to Integration Services Catalog
    4) Imported re-imported *.ISPAC file

    Documented here :-

    SSIS :- Exception – Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException

    https://learningintheopen.org/2019/08/23/ssis-exception-microsoft-sqlserver-dts-pipeline-componentversionmismatchexception/

    Daniel Adeniji supported this idea  · 
  13. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji shared this idea  · 
  14. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji supported this idea  · 
  15. 13 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji supported this idea  · 
  16. 11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji supported this idea  · 
  17. 46 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji supported this idea  · 
  18. 170 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji supported this idea  · 
  19. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji supported this idea  · 
  20. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Adeniji supported this idea  · 
← Previous 1 3 4

Feedback and Knowledge Base