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

    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 →
    • Support “Auto grow” for single database

      The documentation https://docs.microsoft.com/en-au/azure/sql-database/sql-database-single-database-scale#vcore-based-purchasing-model-change-storage-size describes different ways how manually change storage size: “Storage for a single database can be provisioned by increasing or decreasing its max size using the Azure portal, Transact-SQL, PowerShell, the Azure CLI, or the REST API.” However it will be good to support auto-grow option with additional ability to send alert about the change.

      Another measure to reduce risk of running out of space will be make it easier to create alerts when storage is close to the limit (e.g 80% or 90%). E.g add link to create alerts to storage chart section on the overview of…

      3 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 →
      • Get this overengineered **** to work.

        This **** just doesn't work. I've been trying to publish my SQL Server database to Azure for two days.

        Now I'll have to spend 30 bucks a month on Indians who hopefully know the right sequence of dials to turn and buttons to press.

        Maybe that's what Microsoft wants to begin with.

        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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
        • Python Machine Learning Services in database

          I see that R Machine Learning Services in Azure SQL Database is in preview. That's awesome, but what about Python?

          3 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 →
          • Disable Server Admin (after creation)

            Server Admin Login and Password is mandatory during the creation of Azure SQL. Would like it to be possible to delete after creation of server and AAD SQL Admin.

            •There are enough companies who have to rule (inherited from the on-prem) that accounts must be controlled by a centralized Identity Store, such as AAD.
            •Password rotation must be done, it is a lot easier when you have a centralized identity Store instead that you have to do it for a lot of Azure SQL Servers.

            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 →
            • No example of how to automate bulk database migration

              I have gone through the below document https://blogs.msdn.microsoft.com/datamigration/2018/02/08/automating-the-end-to-end-migration-of-sql-server-to-azure-sql-database-using-the-azure-database-migration-powershell-module/

              That stats about automating the bulk database migration, but it seems like the DMS scripts that the guy is wirtten has errors in itself, I was not able to perform 2-3 database migration using the powershell tasks, can the document be updated with some examples?

              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 →
              • Make ARM Template Replica Creation Idempotent in all Cases

                When creating a replica instance through ARM template, the correct configuration is to use a "createMode" of "OnlineSecondary" and then provide the source (primary) database instance.

                In line with the "desired state" intent of ARM templates, it is possible to re-deploy the same template without error.

                However, under certain conditions, changes to the ARM template will cause the deploy operation to fail with the error "database with that name already exists".

                For example, provisioning a replica database with firewall rule, then re-deploying without those rules causes this to manifest - see attached templates (deploy A, redeploy A, deploy B).

                Please…

                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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                • Increase max number of Db per pool for vCore for Gen5

                  Currently under the vCore model, on a Gen4 platform you are limited to 200 databases for a 2 core pricing.

                  On a Gen5 platform you are limited to 100 databases for the same number of cores (2) and the same pricing.

                  Because on some region only the Gen5 platform is available, it reduce greatly our choices.

                  We are currently using pools with 200 DTU. With current limitations, we are moving from a 500 max db limitation to a 100 max db limitation.

                  Totally unfeasible for us.

                  3 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 →
                  • increase the retention period of historic tempdb usage metrics

                    it would be great if Azure can retain and expose as many metrics possible pertaining to tempdb

                    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…)
                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Bring back T-SQL debugger (and make it work with MI)

                      The T-SQL debugger, while not perfect, was a very useful tool for me. We've recently migrated a large database with some complex SPs from MySQL to an Azure Managed Instance, and while the debugger did not work with the MI, it did work with our on-prem dev server. Using the debugger has made it so much easier to track down where something has gone awry. I was very disappointed to learn that it's being removed completely in SSMS 18.

                      3 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 →
                      • Elastic Jobs: Ability to prevent concurrent jobs runs

                        Please provide ability to prevent concurrent jobs runs. For example, same job cannot be started twice. If job already runs, the other one needs to wait or not start at all.

                        https://docs.microsoft.com/en-us/azure/sql-database/elastic-jobs-overview

                        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 →
                        • elastic jobs shardmap

                          Running an Elastic Job against a ShardMap results in errors on the server name
                          Every child jobs keeps reporting the following error: "The server 'tcp:myserver.database.windows.net,1433' cannot be used as a job target because it is not an Azure SQL Database server in the same Azure cloud as this job agent. The server's fully qualified host name must end with '.database.windows.net'."
                          It seems that the stored Elastic Job Agent is unable to handle the servername when it includes the protocol and port. I am using the v2.0.0-preview2 version of Microsoft.Azure.SqlDatabase.ElasticScale.Client, which indicates schema version 1.2 in [__ShardManagement].[ShardMapManagerGlobal] on the catalog database.

                          3 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 →
                          • Provide ability to disable TLS 1.0, 1.1

                            While it is possible to disable TLS 1.0 and 1.1 on Windows server, it does not appear that this option is exposed to users of the SQL Database as a service.

                            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 →
                            • Misleading GUI moves servers between subscriptions instead of just a database

                              The Azure Portal SQL database page has an active link to change subscription, but it's actually going to change subscription for the entire server.

                              I suggest the change link is removed or a warning is issued before execution

                              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 →
                              • Report database integrity error

                                Currently a DB integrity check failure is detected only by MSFT and reported to the owner of the DB.
                                Suggestions:
                                1. Report immediately the error on the Azure portal.
                                2. Allow other Accounts beside the "serveradmin" to execute DBCC CHECKDB thru Elastic jobs/Automation/remote execution
                                3. Have SCOM integrated in order to raise an alert when such even occur so owner support team is alerted without delays.

                                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 →
                                • Make Vulnerability Assessment a trusted service

                                  Please make Vulnerability Assessment a trusted service so I can use a storage account that has firewall settings.

                                  6 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 →
                                  • SQL Data Sync Agent prerequisites

                                    The SQL Data Sync Agent needs to NOT use SQL2012 components! Installing the agent into a SQL 2017 environment and find I have to install components from FOUR major releases ago doesn't fill me with confidence - as well as introducing potential incompatibilities in code

                                    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Provide method for accurately determining log free space

                                      Currently none of the existing methods for determining log space free give a true value when using vCore. With vCore you are allotted a fix amount of space for your logs when you set the storage size. For example, if you specify 1TB of storage, you get 300GB allocated for log. However, if you run something like DBCC SQLPERF(LOGSPACE) you will see the Log Size (MB) and Log Space Used (%) values fluctuate wildly. The Log Size value may say 4947 (4MB) but the Log Space Used shows 99.92%. This leads you to believe that your 300GB of log space…

                                      31 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 →
                                      • 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…

                                        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 →
                                        • 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..

                                          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 22 23
                                          • Don't see your idea?

                                          SQL Database

                                          Feedback and Knowledge Base