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 Bulk Access for SQL DB from Data Lake Storage

    Following the announcement of Bulk Loading from Blob Storage (https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/02/23/loading-files-from-azure-blob-storage-into-azure-sql-database/) , I'd like this to be extended to be able to use Data Lake Storage

    3 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Make target service objective for scaling operation available via SQL tables/views

      Target service objective was available in slo_database_objectives in V11, but it not available in V12.
      This makes admin tasks harder.

      30 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • Improve to allow multiple tables to have SET IDENTITY_INSERT ON enabled

        Improve SQL SERVER to allow multiple tables to have SET IDENTITY_INSERT ON enabled.

        At present, per MSDN, only one table can have SET IDENTITY_INSERT ON enabled at a time.

        This seems like a prehistoric limitation.

        1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Expand Index Advisor to cover index health (suggesting unused indexes, fragmentation)

          Index Advisor currently suggests the creation of new indexes.

          It's functionality should be expanded to cover index health (fragmentation) as well as unused indexes that haven't been used.

          3 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
          • Add posibility to check name availability into API

            Hi, when creating an azure environment through API (Storage, SQL server, SQL database) - I need to be able to check if the name is available.

            For Database this is not necessary.

            For storage this is available
            https://docs.microsoft.com/en-us/rest/api/storagerp/storageaccounts#StorageAccounts_CheckNameAvailability

            For Server this is not available
            https://docs.microsoft.com/en-us/rest/api/sql/servers#Servers_List

            So if I want to check whether the admin can actually create these resources to link with the tenant he is creating - I can validate the storage, but then I simply have to try create a database and either it fails or it goes through - or is there some way to check this?

            3 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Show Actions, Status, and Errors in the SQL Data Agent

              The SQL Data Synchronization feature which is currently in preview requires that an agent be installed on the on-premise DB servers which need to be synchronized with Azure SQL DBs. It is easy enough to launch this agent on the database server, and it does show some information about which databases are connected and their status. However, a variety of things can go wrong while setting up the Sync Group (particularly with some aspects of the schema which may prevent schema the schema refresh step). Currently, it is unclear what checks are being made, what process is under way, and…

              1 vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Add .Net Core Support for Microsoft Active Directory Authentication Library for Microsoft SQL Server

                Right now this requires .Net 4.6, we have a Core app, would be great if this supported .Net Standard 1.6

                3 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Blob Auditing Type for Azure SQL Database Threat Detection

                  Blob auditing was recently rolled out for Azure SQL Database, "which provides higher performance, supports higher granularity object-level auditing, and is more cost effective." However, Threat Detection does not currently support blob auditing, only table auditing. As a result, one of the most common reasons to turn on auditing, threat detection, cannot actually use the better performing method. Please allow Threat Detection to use blob auditing types.

                  18 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                  • DATA SYNC - RIP? January 2017

                    DATA SYNC - RIP? January 2017

                    Can we have an up-to-date progress report for Data Sync. It would solve a lot of out client issues but its never come out of preview. Please advise

                    1 vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                    • Introduce a TSQL web-service function

                      There is currently no SQL alternative for a webservice call. Using CLRs was the way to achieve it but theyr aren't available in Azure SQL, The request is for adding a built-in webservice function, tto SQL Server and Azure SQL.

                      3 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Bulk Access to Data in Azure Blob Storage

                        Basically, were looking for the exact functionality documented here: https://msdn.microsoft.com/en-us/library/mt805207.aspx

                        But this is currently only supported on vNext. Is there a timeframe for when this will be available on Azure databases?

                        6 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                        • DQS - Data Quality Services

                          Provide a Data Quality feature for SQL Azure that may be able to use third party providers from Azure Marketplace.

                          1 vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Allow editions other than Premium in the uksouth2 region

                            One of the big advantages with for a managed cloud database is the ability to scale the database up or down as necessary. In the uksouth2 region, only the Premium edition of Azure SQL is available. This does not allow us to properly size the database for its current period of low usage and low revenue. We want to scale it to an affordable level and then scale it up as our customer base grows.

                            3 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Mapping of Azure services to the vNet

                              Company security restrictions do not allow to open port 80, 443, 1433, ... (or other) from a vNet / VPN to the Internet.
                              Mapping Azure services with a public IP to a vNet should become a general feature (not only for SQL as requested in the following request).
                              See also https://feedback.azure.com/forums/217321-sql-database/suggestions/5537689-allow-sql-database-to-join-virtual-network-vpn

                              vNet internal dynamic or static IP / name + port -- mapping -> Public dynamic IP / name + port

                              6 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • Exempt all system functions from DTU limits

                                Even on our P4 database I cannot rebuild indexes on a 5gb table without the operation running absurdly slowly - and killing production. Currently I have to upgrade to at least a P11 just to do standard index maintenance! The quickest solution might be to allow system maintenance functions like this to run outside the DTU limit - even if they also incur a (modest) additional charge. On S3 I cannot even begin to do these things. Short of a complete revamp of the DTU system, exempting system functions from the limits would be a good thing.

                                2 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • Granular data masking management on rule-level

                                  Provide more granular management of Dynamic Data Masking.

                                  This would allow admins to exclude SQL users for a specific masking rule instead of excluding them for the complete masking rule set.

                                  12 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Support DateTimeOffset data type in memory-optimized tables

                                    Add support for DateTimeOffset data type in memory optimized tables

                                    16 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Rename SQL Servers

                                      SQL Server names assigned by the system are casual (ie.: 'lxcdfrgyu').
                                      I would like to change it to a more recognizable one.

                                      Thank you.

                                      3 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Enable Stretch Database From Azure Sql Database

                                        Sql Server 2016 Stretch Database is a wonderful feature. I'd love to be able to Stretch data FROM an existing Production Azure Sql Database so I can move cold data out my production "expensive" database into some lower tier Azure Sql Database.

                                        1 vote
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Faster scaling between service tiers/performance levels

                                          Current database scaling can be slow..
                                          Azure SQL Data Warehouse features the ability to scale between performance levels within seconds. It should also be an aim of Azure SQL DB to also offer scaling within seconds/small number of minutes. Key to this is presumably eliminating the data copying that goes on during scaling.

                                          9 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 11 12
                                          • Don't see your idea?

                                          SQL Database

                                          Feedback and Knowledge Base