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. 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…)
        0 comments  ·  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.

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

                  13 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 →
                  • 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 →
                        • PolyBase: Support for Azure SQL Database

                          Azure SQL Database does not currently support Polybase, though it is supported in the on-premise version.

                          21 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 →
                          • allow database to reside in different resource group to server

                            Currently, SQL server databases must be created in the same resource group as the server. It would be great to allow databases to be created in different resource groups. This would allow full environments to be created and destroyed while leveraging elastic pools.

                            4 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 →
                            • Database Swap

                              Hey team,

                              It would be a very nice feature to be able to swap a staging database to production without renaming or downtiming.

                              Cheers!

                              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 →
                              • Add better interoperability with Application Insights

                                In Query Performance Insights, you can find long running and frequent queries, but to make this actionable, you need a way to find out which server operations are executing those queries so you can optimize.

                                There is no easy way to find this information today. You can do a "top down" search in Application Insights (AI) to find slow server operations, and then search their dependencies....but there is not a way to search for that specific query that you originally found in Query Performance (QP) to be slow or frequent. So the data is in AI, it's just not queryable.

                                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 Limits on DTU usage by account while still allowing workload to complete

                                  When creating an account used to connect to Azure SQL to execute workloads consider providing for a DTU usage limit.

                                  The workload requested using the account would still complete but just take longer. In this way we can limit lower priority requests such that they don't consume all available resources when requesting an intensive operation.

                                  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 →
                                  • Track SQL DB restore progress

                                    Tracking in detail the restore of a SQL DB is mandatory in order to provide a transparent customer support. At this moment, one can only see if a restore is running (1%) or finished, but the restore progress in percentages cannot be seen. The only reply I can give at this moment to my customers about when the database restore will be finished, is somewhere within 24h.

                                    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 →
                                    • Support Transact-SQL Bulk Insert on SQL Database

                                      Bulk Insert is usefull to import large data set set in SQL
                                      The data file may be hosted in a storage blob

                                      It looks that bcp can be used but this is an "out of process" method and it's limited to 1000 rows (?!?)

                                      http://thecodegarden.net/bulk-insert-azure-sql/

                                      In my case, it's for exporting/importing tenant data in a multi-tenancy application. Dataset may have million rows.

                                      5 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 →
                                      • Per server DTU bundles

                                        Can we get a server with fixed DTUs and be billed on the per server DTU rather than for each individual database? This is useful when migrating from on-premise + when I want to manage the per database DTU by myself or I just don't want to care about the per database DTU.

                                        Elastic pool based on the server!

                                        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 to query analysis services directly from sql database

                                          Right now there is no way to combine results from sql and azure analysis services without additional layer of code that would query analysis services and insert results to sql database.

                                          Before azure we had something called OPENQUERY, that would allow us to query on the specified linked server using syntax that makes sense for that linked server (for example MDX).

                                          Current implementation of azure elastic query doesn't really help in this situation.

                                          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 →
                                          ← Previous 1 3 4 5 10 11
                                          • Don't see your idea?

                                          SQL Database

                                          Feedback and Knowledge Base