Mark Freeman

My feedback

  1. 537 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    29 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →

    This is not currently planned for the normal SQL DB since the databases within a logical server are not hosted within a single server like in SQL Server – they have multiple replicas that are independently placed on different servers due to the high availability architecture in SQL Azure. However, SQL Azure Managed Instance supports use database as a command because all of the databases in that model are on the same SQL instance – just like SQL Server. It is therefore recommended that you consider Managed Instance for migrations from on-premises SQL Server where you can not/do not wish to modify behavior to fit within a single SQL Azure DB.

    Topic left open for comments and voting, but please note that some of the comments left do not seem to recognize that SQL Managed Instance is available and recommended by Microsoft for many of the use cases listed. We…

    An error occurred while saving the comment
    Mark Freeman commented  · 

    I see no reason why Microsoft could not abstract this such that the USE command would work in Azure SQL Database as it does in SQL Server. It should work within a "server". The fact that the databases are in different servers "behind the scenes" should be irrelevant to the user.

    I understand this limitation is well documented. That doesn't make it acceptable. We could migrate to Managed Instances, but Azure SQL Database is working for us in all other respects. This is mainly an issue for Infrastructure and DBA teams, not for end users or applications. It makes scripting various administrative functions impossible, because some metadata is only available at the database level, not the server level.

    Mark Freeman supported this idea  · 
  2. 79 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 38

    <=-=Mar 16 2017 11:48AM=-=>

    Or better yet, include an option to automatically adjust it based on wait stats.

    <=-=Mar 17 2017 12:34AM=-=>

    Or implement adaptive query plans that will adjust the parallelism dynamically based �n query execution stats

    <=-=Mar 17 2017 10:56AM=-=>

    Thanks for the feedback. We�ll be keeping this item open for future consideration.

    Thanks,
    shreya

    Mark Freeman supported this idea  · 
  3. 174 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 →
    Mark Freeman supported this idea  · 
  4. 598 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Upvotes: 72

    <=-=Mar 10 2016 11:26AM=-=>

    It’s a shame that this was submitted as just a “suggestion”. It should actually be listed as a “bug” because there’s only a comparatively small set of use cases where enumeration of the result set of elements is not important.

    <=-=Mar 11 2016 12:47PM=-=>

    I agree that an order column is required; one example use case is where two lists are passed in, and ordinal positions in one list correspond to positions in the other.

    <=-=Mar 11 2016 3:12PM=-=>

    Please see the related suggestion: STRING_SPLIT needs “RemoveEmptyEntries” option, like String.Split in .NET ( https://connect.microsoft.com/SQLServer/feedback/details/2462002/ ).

    <=-=Mar 12 2016 12:02PM=-=>

    This kind of function is primarily needed for de-serializing previously serialized arrays of values of any type format-able as text.
    I therefore recommend to have the result set of this function work excellent with this use-case.

    With de-serialized arrays there is a need to…

    Mark Freeman supported this idea  · 
  5. 23 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 →
    Mark Freeman 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  ·  Azure Service Health » Service Health Alerts  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freeman shared this idea  · 
  7. 17 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Azure Service Health » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freeman supported this idea  · 
  8. 5 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Azure Service Health » Service Health Alerts  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freeman supported this idea  · 
  9. 4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Azure Service Health » Service Health Alerts  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freeman supported this idea  · 
  10. 1,100 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    101 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freeman supported this idea  · 
  11. 59 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 →
    Mark Freeman supported this idea  · 
  12. 23 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  5 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freeman supported this idea  · 
  13. 71 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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 » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freeman supported this idea  · 
  15. 569 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    27 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freeman supported this idea  · 
  16. 622 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    31 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Mark Freeman commented  · 

    Implementing this in SQL MI would be helpful. However, we need it in Azure SQL Database as well.

    Mark Freeman supported this idea  · 
  17. 3 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 →
    Mark Freeman supported this idea  · 
  18. 16 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 » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freeman supported this idea  · 
  19. 4 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 →
    Mark Freeman supported this idea  · 
  20. 5 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Mark Freeman supported this idea  · 
← Previous 1 3 4 5

Feedback and Knowledge Base