Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

SQL Database

  1. Elastic database client library

    Hi, is there documentation about how use elastic database client library with azure devops?

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Login Fails For AAD Admin when using Group

    When configuring the AAD Admin to be an AAD group login fails with Login failed for user '<token-identified principal>'. (.Net SqlClient Data Provider) whether using SSMS (MFA Sing-in option) or the Azure Portal based query tool.

    Taking the account which is a member of the group and making it the named admin on the server for AAD and it works fine.

    The documentation https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview under the Additional considerations indicates that this configuration should work.

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. Hyperscale - (re)build index from secondary replica

    Given that Hyperscale replicas share storage, it would be great if we could utilize the secondary computes to (re)build indexes.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Save the profiler Data into file using SQL Sever Profiler Extension

    Please add a option to export the profiler data into a file

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. Check ShardMap mapping status in Elastic Query

    Currently the elastic query feature does no filtering on the shards (invoked with the sp_execute_remote). However, the ShardMap management library allows creating a shard in an Offline mode, which means that the shards database may be in an invalid state. After fully configuring/migrating the shards db the mapping can be set back to Online.
    The elastic query should not be invoked on offline shards.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Allow AAD Users and Group permissions on the Server Level, not database level

    With 1000s of databases to manage and more been added everyday, it would be a great feature to be able to apply AAD user and group permissions across the entire server and have those permissions be applied to the database automatically whenever a new database is created. Currently the only option we have is to run this on every database

    CREATE USER [user/group] FROM EXTERNAL PROVIDER
    EXEC spaddrolemember 'dbdatareader', 'user/group'

    We can apply an active directory admin on the server level and use that user/group permission to every database. It would be great if we could do the…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Support CURSOR_DEFAULT in Azure SQL Database

    I have some legacy stored procedures that I'd like to port from SQL Server to Azure SQL Database. These procedures rely on cursors being LOCAL by default. However, trying to execute...

    ALTER DATABASE CURRENT SET CURSOR_DEFAULT LOCAL;

    ...produces the following error under under Azure SQL Database (but not under SQL Server):

    Msg 40517, Level 16, State 1, Line 1
    Keyword or statement option 'LOCAL' is not supported in this version of SQL Server.

    Being able to set CURSOR_DEFAULT would make it possible to port the procedures without having to alter their source code to explicitly declare each and every cursor…

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add a “Memory Limit Based Cleanup” process to Query Store

    There is no “Memory Limit Based Cleanup” process or any ability to see what the memory limit is, or what percentage of it you are using.

    You can cause problems by either having a large non-parameterized workload or by giving Query Store too much space, at least in Azure SQL Database.

    By doing that (“Hey, let’s give it the maximum of 10 GB so we won’t run out of space until long past stalequerythresholddays!”), we effectively prevent the Size Based Cleanup from running until there is so much in the QS that we get the 131072 readonly

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Improve DISTINCT performance

    There are millions of databases running on SQL Server with unimaginably high number of queries running on them. Large portion of these queries are dynamically put together, so it is NOT always possible to “change the query” if the performance is slow. Same goes for legacy software where there might not be source code available to “fix it”.
    One thing is consistently wrong with SQL server: when using the DISTINCT keyword, the performance can go from giving results in less than 20ms to over 30 seconds or even minutes. And in many cases the number of records returned is 0.…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Support proximity placement groups

    We are managing a server/database application for which we want to increase performance by reducing network latency. It's a very chatty app, so network latency is a big concern for us.

    Our server is an Azure VM, the database is Azure SQL (with elastic pools).

    We'd love to be able to put these resources in 1 proximity placement group, so network is as fast as possible. Can this be realized for the Azure SQL services?

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Provide soft-delete option on SQL Azure LTR to protect against malicious deletion

    Azure Backup has soft-delete enabled by default, but the Azure Backup service itself does not interoperate with SQL Azure backup or Long Term Retention.

    The soft-delete feature retains an undeletable backup of VMs (including SQL VMs) for 14 days.

    I propose that either LTR get a soft-delete-by-default feature because currently you can permanently delete LTR backups with sufficient privileges. Another alternative would be to allow SQL Azure backup and LTR to utilize Azure Backup and therefore inherit the soft-delete features.

    This request is to facilitate both accidental deletion and malicious attacks (e.g. ransomware) by allowing an immutable backup of the…

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. when import bacpac file, ignore existing user in target database and let import continue instead of error out

    Very often, the db user might already exist in target database when doing import especially if source DB admin user is the same as target admin user. In such case, current import bacpac process failed at creating user and Errored out. Currently, the work around is that we must delete the same user from source database before export bacpac so that there is no conflict. The idea is that this should be treated as warning instead of error and let the import process continue , same as how Migration Assistant Tool works.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. SQL Management Api support for bacpac for azure hyperscale databases

    Please add in the ability for SQL Management Api support for bacpac for azure hyperscale databases.

    We were able to export a bacpac file of an azure hyperscale databases using the old Azure SDK which was recently deprecated. We are now stuck with no pathway to automate the creation of a new database based on an existing Azure hyperscale database. It is challenging when features are removed due to an upgrade.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Default tier should be Basic DTU

    When a tier is not selected during DB creation, the default tier should be Basic DTU, in order to protect customers from high costs.

    Currently, the default Tier is General Purpose Gen5 with 2 vCore which is much more costly than Basic DTU.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Keep record of updates to Azure databases for longer than 7 days

    When an update is made in Azure to a SQL Database keep the details available to aid troubleshooting

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Internal error when importing .bacpac

    Importing a pacpac, the import fails with an 'internal error' after several hours. Turned out the import was larger than the max database size.

    That would be a useful error message to surface to the user.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  19. I am seeing 100% CPU use in a geo-replicated secondary server

    Currently I am routing all my queries to the secondary server, and I am seeing the server cpu hit 100%.

    Would like the option to turn on Performance tuning on the Geo-
    replicated secondary server.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. We would like to know the total price of each pricing tiers.

    Due to the "Azure SQL Database Standard S4: 200 DTU ~ Standard S12: 3000 DTU" is used by same Meter ID (Resource Meter), it is hard to calculate the price per pricing tiers.
    We would like to know the total price of each pricing tiers.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Database

Categories

Feedback and Knowledge Base