SQL Database

How can we improve Azure SQL Database?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Multiple readable secondaries with Failover Group

    We are currently using Auto-Failover Group feature. We have primary in US west coast and single read-only secondary in east coast. We would like to have additional read capable secondaries in Europe and Asia to improve read performance on our geo-distributed application.

    It will be good if multiple secondaries from different regions are allowed to be added to a failover group. In general, just Geo-replication doesn’t serve our purpose because of all the reasons for why someone would need a failover group:
    - Mission critical data so we want better availability and reliability for writers
    - We don’t want to…

    73 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      2 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Fix quality of daily cost data visibility

      On various days / weeks there are gaps in cost data for various resources. This tends to self-heal after up to 1 week (incl. history correction). All custom control / alerting which looks on anomalies in cost trends fail due to this; we also loose opportunity to act quickly on unexpected cost raises due to changes, testing activity or unplanned activity on prod - it's critical to see this data at least with daily delay, ideally near real-time.

      Examples of incidents: on Dec 8-9 we stopped getting cost data for any of our SQL DWs, SQL DBs or PostgreSQL DBs…

      16 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
      • Include improved & regressed query plan links in sys.dm_db_tuning_recommendations

        When you enable Automatic Index Tuning, and Azure adds indexes, the portal's validation screen shows a count of the number of improved and regressed queries. However, there's no easy way to tell which queries they were.

        To facilitate that, how about in the "details" JSON column of sys.dm_db_tuning_recommendations, you add something to help us join to Query Store or the plan cache to see which queries they were?

        18 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Provide SQL Server Connector functionality for Azure SQL PaaS

          In order for an EKM provider to communicate with an Azure Key Vault the database must be either Azure SQL IaaS or an on-prem instance of SQL Server. When using Azure SQL Paas, however, it would be great to have this level of security available as well as the ability to manage credentials in one area and within a Key Vault.

          21 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Enable SQL Profiler for SQL Azure

            While the query performance analyzer in the Azure portal is great, it does not allow for the real-time capturing of queries. Instead, it takes a sample and only shows the most "expensive" queries.

            It can be very difficult to figure out problem queries without SQL Profiler working in SQL Azure. Adding support for this would be a huge win.

            86 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              3 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Allow subscription Reader or Security Readers to view VA scan results

              Users with Reader and/or Security Reader roles at subscription level are not able to view details of SQL DB VA scan as confirmed by MS support case where engineer replied "You need to grant 'Storage Account Contributor' on a storage account associated with 'Advanced Data Security' you have configured."

              However, 'Storage Account Contributor' role has considerable power, including operation Microsoft.Storage/storageAccounts/* "Create and manage storage accounts".

              It should be possible to grant subscription Readers or Security Readers less permissions so they can view SQL DB VA scan results, or have the necessary permissions included in the Security Reader role.

              10 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • each sync group should be able to defined a dedicated metadata database

                Currently it only allows 1 metadata database for within 1 subscription, which forces biz to mix up data for all dev & production environments.

                It should allow customer to choose a metadata database per sync group for flexibility, security and DevOps etc.

                10 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • ServiceEndpoint and DB Firewall apply to Portal UI SQL Query Editor

                  When applying a Network Service Endpoint or through SQL Server FW on Azure SQL it would be good for the Portal UI SQL Query Editor to honor those settings and prevent login unless whitelisted through Service Endpoint or SQL Server FW rules. This behavior can be found today to Azure Storage Account and the Storage Explorer UI.

                  Today the Portal UI SQL Query Editor seems to be based on a Azure Service IP 40.76.27.62 and not the client browser's public ip or Azure VM VNET ip that Service Endpoint could honor.

                  9 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                  • Allow ElasticPool SQL Database to join P2S Virtual Network (VPN) - Round 2

                    This is round 2 of the idea posted here:

                    https://feedback.azure.com/forums/217321-sql-database/suggestions/5537689-allow-sql-database-to-join-virtual-network-vpn?tracking_code=704e9fed32d702f27033e3c1be63d789

                    which was closed since SQL databases now have "virtual network" endpoints. However, these endpoints still do not work with P2S VPN connections using Azure VPN Gateway, so I don't know why this idea was closed as completed.

                    This means that we either need to create our own workarounds, such as SSH tunnels via VMs inside Azure, or we need to keep using the IP whitelisting method (the latter of which defeats the whole purpose of using a VNET-based access control). In addition, security auditors don't look kindly on databases with…

                    64 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      3 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Allow enabling auditing on SQL Server and send data to OMS workspace using ARM template

                      Using Azure portal sending auditing data to OMS work space is available.. But we couldn’t find an option using ARM template to send SQL auditing data to OMS workspace.. only allows sending data to storage account..

                      15 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Monitor queries on secondary database when read scale out is enabled in Premium tier

                        Monitor queries on secondary database when read scale out is enabled in Premium tier. Currently we can only find out if query is getting executed on secondary database by using SELECT DATABASEPROPERTYEX(DB_NAME(), 'Updateability') but there is no way to identify in Query Performance Insights.

                        72 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Run Microsoft Flow when alert

                          I want to run automation by Microsoft Flow when Azure SQL Database alert.
                          for do business workflow with no-code by everyone.

                          My scenario:
                          1. When Azure SQL Database alert, notify DBA, and add it to the support system

                          1 vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Expose Resource Governor for SQL Azure

                            If we had the ability to define certain connection DTU limits in SQL Azure it would facilitate common scenarios like using the OLTP database for other, less important requests like reporting without fearing a long running report will cause the application using the OLTP side of things getting slow or unresponsive.

                            Basically, just give us access to Resource Governor from on-prem SQL Server.

                            45 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                            • Allow Recovery Model to be changed to SIMPLE in Azure SQL Database

                              According to this article (https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/12/28/lesson-learned-50-adding-pk-led-to-transaction-log-full-error/) the recovery model of a Azure SQL Database cannot be altered from the default option FULL. In a very data intensive setup, this blows up the transaction log -> the LOG IO percentage in portal is at 100% all the time. Allowing the SIMPLE recovery model should improved the performance significantly.

                              8 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • No DTU metrics can choose in Azure Monitor Alert

                                One of our customer is concerned about the retirement of Classic Alert next year.
                                They want to use DTU metircs as criteria but there's no DTU related metircs in Azure Monitor Alert.

                                15 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • 'CREATE SEARCH PROPERTY LIST' is not supported for targeted platform

                                  Currently I have version of Visual Studio Professional 15.9.4 installed with the latest version of SSDT but as per my stack overflow question can't get my project to build with Target Profile as Azure v12 despite the documentation saying this is supported

                                  1 vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                  • 1 vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Enable streaming API for Extended Events

                                      Supporting the streaming API for consumption of XE for Azure SQL Database will make this feature a lot more usable for third party monitoring solutions. Additionally open source tools such as XESmartTarget (https://github.com/spaghettidba/XESmartTarget/) can then be used in the same way as with Managed Instance or retail SQL Server.

                                      9 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Implement password expiry & password history & certain number of account lockout for Azure SQL databases

                                        We could see below gaps for Azure SQL Database (for PAAS scenario)

                                        1) There is no Password History
                                        2) There is no Password Expiry
                                        3) There is no Account Lockout set (wherein account will be locked out after certain number of failed attempts) which could lead to bruteforce attacks.

                                        All these above parameters must be addressed and aligned in accordance with Industry Standard.

                                        As discussed with Omeswar Reddy Danwada uploading this idea

                                        18 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Enable viewing & exporting of VA Scan results for All SQL Databases at once

                                          VA scan results cannot be viewed/exported at once for all SQL databases under the Server or RG. These results have to be viewed individually for each database and exported (if needed) which is a very time-consuming process especially if you have quite a number of databases. It this feature can be provided at the RG Level, Server Level and/or based on a selection of DBs, it will save a lot of time and effort.

                                          4 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 25 26
                                          • Don't see your idea?

                                          SQL Database

                                          Feedback and Knowledge Base