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. Azure SQL Serverless support for LTR with pausing

    The fact pausing & long term retention (LTR) are incompatible in Azure SQL Serverless is pretty much a deal breaker for us. Adding this capability would be a huge benefit for us and I'm assuming others that have the same data retention policies we do.

    17 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 →
  2. balance pages on extent spilt to avoid further extent allocation

    Problem:
    if you have a recently rebuilt or reorganised index (as per best practice), and you have a random insert which causes a page split then a new extent needs to be allocated.
    (this is expected and understood behavior)
    The problem is that these extents are not balanced.
    before:
    extent 1: 8 full pages.
    after:
    extent 1: 7 full pages, 1 half-page (from split)
    extent 2: 1 half-page (from split)

    Consequence of problem:
    If this table receives further inserts with high probability extent 1 is split in an unbalanced manner again.

    This has several major consequences:
    1) if you have…

    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 →
  3. Improve side-effect detection in scalar/table valued function

    The following few lines work in a normal batch but not in a table valued function where the function cannot be created because of alleged side-effects in the DELETE statement although there are none.

    DECLARE @recipeList TABLE (row_id [int] IDENTITY(1,1) NOT NULL, recipe_id INT);
    
    INSERT INTO @recipeList (recipe_id) VALUES (1),(2),(2),(3)
    DELETE b FROM @recipeList a CROSS JOIN @recipeList b WHERE a.recipe_id = b.recipe_id AND a.row_id < b.row_id;

    on the other hand a simple

    DELETE FROM @recipeList
    

    works also within a table valued function as expected.

    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 →
  4. Remember ALLOW_SNAPSHOT_ISOLATION setting for Azure tempdb

    We have stored procedures that use snapshot isolation, and also create temp tables. This requires ALLOWSNAPSHOTISOLATION to be ON in tempdb. On an Azure Managed Instance, this setting is reset anytime the server restarts, or anytime TEMPDB is re-created (https://docs.microsoft.com/en-us/azure/azure-sql/database/doc-changes-updates-release-notes?tabs=single-database#tempdb-structure-and-content-is-re-created).

    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 →
  5. Managed identity ActiveDirectoryMSI on Azure Portal

    Hi team

    Please can you enable ActiveDirectoryMSI based connection string as well for JDBC Connection Strings in the azure Portal when SQL Database is being seen by the user.

    Currently the ConnectionString panel for SQL Database lists out only Sql Auth, AD password based, AD Integrated examples. It would really help someone in future if an example is provided for ActiveDirectoryMSI as well as shown in Article https://docs.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-ver15 for Managed Identity based Connections

    The lack of correct Connection Strings on the SQL Database Blade actually wasted my team's 8 hours of productivity.

    thank you

    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 →
  6. Azure SQL Database cannot use External tables and PEP at the same time.

    As per Microsoft Ticket: 121012125003847

    I can either use a Private End-Point (PEP) with Deny Public Access or External Tables; but not both at the same time. This is completely unacceptable. This means that I can either have access to my data, OR have my data secured - but not both...

    Please resolve this SOONEST possible.

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  7. Increase the default 4 TB storage limit of Elastic pool

    Increase the default 4 TB storage limit of Elastic pool

    15 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 →
  8. Incremental long term backups taken per hour

    Can you please support the incremental long term backups taken per hour/day of azure sql databases and managed instance databases?

    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 →
  9. API to copy the automated backups of azure sql databases and managed instances

    We want to keep the transactionally consistent incremental backups for more than 35 days. The automated backups doesn't allow that. Long term backups are taken at weekly (monthly/yearly) frequency and we want backups taken hourly/daily. The export of database via sqlpackage is not transactionally consistent. Hence, an API to copy the automated backups of azure sql databases and managed instances would help us. The similar API is supported by the amazon RDS.

    1 vote
    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 →
  10. Be able to Remove firewall rule while enable locking via CLI Command

    Remove firewall rule while enable locking via Azure CLI Command as Azure Portal

    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 →
  11. Make the DTU selection more easily visible.

    This is just a UI design fix. Right now the DTU model option print is much smaller than the vCore option and appears concealed. Once you click on the DTU model, the vCore link becomes much smaller, but it is easy to miss, putting the Azure SQL db way out of the price range of many small developers.

    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 →
  12. Apache Spark Connector for SQL Server and Azure SQL - Support Spark 3.0

    The new Microsoft Apache Spark Connector for SQL Server and Azure SQL must support Spark 3.0.

    Without this we can't use Azure Databricks 7.x Clusters and have to stick to Databricks 6.4.

    This is highly nedded.

    This connector should also work with Synapse SQL Pool.

    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 →
  13. External Table with private endpoints

    Currently the external table query only works with deny public network access set to NO and allowing all azure services to access the database, there should be a way to get the external table query working with private endpoint.

    16 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 →
  14. Dashboard or single location to view replication status of SQL DBs

    As IT personnel we require to keep track of replication status of all SQL DBs across our subscription. It is not possible to go to each and every DB and check the replication status manually. It will a great convenience for IT staff to find this information from a single dashboard or location is azure.

    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 →
  15. Azure SQL Managed Instance: relative storage metric

    Hello,

    currently there are two absolute storage related metrics:

    I am wondering why there is no relative storage metric (the ratio of storage space used and storage space reserved as percentag value). This would it make it much easier to create and maintain alerts.
    Right now, a threshold for an alert has to be "hardcoded" as an absolute value. If the storage is then increased, also the alert threshold has to be readjusted. With a relative metric, this would not be necessary.

    Thanks and regards,

    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 →
  16. Increase the Log IO on Azure SQL Serverless

    Please increase the Log IO limits for Azure SQL Serverless. We currently get to about 15/20% of CPU usage and 100% log on a simple insert into.

    A good article describes the issue at https://www.brentozar.com/archive/2019/02/theres-a-bottleneck-in-azure-sql-db-storage-throughput

    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 →
  17. 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 →
  18. please fix the performance issue that happen for empty table

    i have a daily table that its rows are moved to another larger table.
    I noticed that from time to time, when the daily table is empty (no rows) a simple query of
    select top(1) * from dailyTable
    takes few MINUTES!! to return nothing.

    That is on azure SQL, Hyperscale tier (no replicas).
    This issue went away after deleting the table (drop) and re-creating it.
    Support (SR 120122725000329) said that truncate table should also do the trick. but that is weird!

    Please fix this bug ASAP

    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 →
  19. please fix the performance issue that happen for empty table

    i have a daily table that its rows are moved to another larger table.
    I noticed that from time to time, when the daily table is empty (no rows) a simple query of
    select top(1) * from dailyTable
    takes few MINUTES!! to return nothing.

    That is on azure SQL, Hyperscale tier (no replicas).
    This issue went away after deleting the table (drop) and re-creating it.
    Support (SR 120122725000329) said that truncate table should also do the trick. but that is weird!

    Please fix this bug ASAP

    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. size limit

    Please increase the limit on database size in Business Critical tier, currently it is capped at 4TBs even for the most expensive option with M-series under the hood. We currently have a database of around 3.2 TBs and we would love to stay on Azure SQL, but see no option at this moment.
    Hyperscale does not provide comparable IO performance and no InMemory support.
    Our company can consider a different RTO/RPO for a tier that allows bigger database, we accept that bigger files require more time to work with.

    19 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