AdminSQL Database feature voting forum admins (Product Owner, Microsoft Azure)

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

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

    Hi Martin,

    Note that in general, Halloween protection for STRING_SPLIT() is required because the input of the function can reference the same table being modified. For example, consider this query:

    INSERT INTO @T
    SELECT value
    FROM @T CROSS APPLY STRING_SPLIT(c, ';')

    However, under compatibility level 140 with query optimizer hotfixes enabled, and under compatibility level 150 with or without query optimizer hotfixes enabled, the optimizer does not add a spool if the input of STRING_SPLIT() is a string literal.

    Hope this helps,
    Dimitri

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

    Hello,

    Azure SQL Database serverless is now in preview:

    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-serverless

    Feedback welcome. Thanks

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

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Hello,

    Could you please let me know what version you were running when you saw the truncation error?

    The SPACE function will not exceed 8,000: https://docs.microsoft.com/en-us/sql/t-sql/functions/space-transact-sql?view=sql-server-2017. So SPACE(8000) = SPACE(8001) given 8001 is cut off at 8000. The hashes are the same because the output of the function is the same.

  4. 19 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 →

    Thank you for taking the time to provide feedback on your Azure SQL DB experience. Are you looking to track login failures exclusively for security purposes or are you also interested in receiving alerts for login failures tied to unavailability?

  5. 295 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    44 comments  ·  Virtual Machines  ·  Flag idea as inappropriate…  ·  Admin →
  6. 164 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  6 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →

    Vince,

    Thank you for taking the time to post this suggestion. This suggestion will be reviewed and discussed for a future planning cycle. If the proposed change meets the bar for approval, I'll provide an update on the status in this User Voice item.

    Best Regards,
    Joe Sack, Principal Program Manager, Microsoft

  7. 20 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  5 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →

    Sher,

    Thank you for taking the time to post this suggestion! This suggestion will be reviewed and discussed for a future planning cycle. If the proposed change meets the bar for approval, I'll provide an update on the status in this User Voice item.

    Best Regards,
    Joe Sack, Principal Program Manager, Microsoft

  8. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  SQL Database » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Mike,

    Thanks for the additional details, I will take this feedback to the engineering team.

    Best Regards,

    Joe Sack, Principal PM, Microsoft

Feedback and Knowledge Base