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. Allow DNS alias masking for SQL Azure Database Server

    We would like to be able to take an azure sql server's instance name (server01.database.windows.net) and add an alias entry to our internal DNS for resolution which aligns to our existing set of onpremise standards.

    53 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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    • Master Data Services (MDS) configured to Azure SQL.

      Master Data Services (MDS) currently does not support having Azure SQL DB as it Data source. We have entity store on PaaS and MDS on IaaS and we want to MDS to be configured to Azure SQL instead of on-prem SQL.
      Or even better to have MDS as PaaS.

      50 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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
      • [bug] SQL Azure Database Information Not Available in Preview Portal

        Experiencing a repeated bug in the preview portal with Azure SQL Database. Occasionally after altering the service level tier of an existing database that database no longer appears in the Portal UI. The server will still appear, and you can drill down to the database name, but you are never able to access the database details or monitoring metrics via the preview portal. The standard portal works correctly and displays the correct database information.

        24 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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
        • Azure database export fails when split_string is involved

          Database compatabilty level 130.

          Repro steps:

          alter function dbo.tt
          (@id varchar(max))
          returns table
          return
          select
          * from
          dbo.string_split(@id,',') t
          inner join
          dbo.numbers n
          on n.id=t.value

          Export dacpac fails stating unresolved reference split_string,while the function itself works

          19 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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
          • Adding Azure AD groups to Azure SQL Database with Special charecters like '&'. Currently it is not alowing.

            Adding Azure AD groups to Azure SQL Database with Special characters like '&'. Currently it is not allowing. Corporate AD groups have special characters and we need this feature should be available for successful client satisfaction. It is critical for enterprise applications.

            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…)
              3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
            • Deadlock with Always Encrypt Azure Key Vault

              We use Always encrypt from Azure App Service in ASP.Net with column key in Azure Keys vault. I work most of the times, but when column key is refreshed we see deadlock if the load is significant. We have seen this with around 10 queries per second.

              I have attached a screen dump from Log Analytics that shows that 3 x 500 KeyVault opertation occuring in connection with this deadlock. 500 is the size of our connection pool. After a few minutes Tasks are cancelled and the service resumes. But during that time no database access is possible.

              To me…

              12 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 →
              • We need a regulator to easily start and stop of your Azure SQL services

                We need a regulator to easily start and stop of your Azure SQL services to save the cost. So whenever we require, we can start or stop services which feature is available in AWS

                Lets take an example, if we are using Standard S0 pricing tier with 15 GB database size and our database is not in use after pick hours so here I need
                to stop Azure sql database which is not available in current feature and also i can't scale down the database to basic tier because my database size is more than 5GB

                can you please provide…

                5 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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                • South India SQL Database price

                  Hi,

                  is this a bug in calculation?

                  Why only South Indian SQL Database Basic price is higher comparing to all other available region.

                  Azure pricing calculator show $124 per month for South India when other region is just charging $4 or $5.

                  Anyone Please confirm

                  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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                  • Show Database Pricing Tier on Azure Portal

                    I've multiple Azure DBs to manage and desire a single view to tell all pricing tier at once on portal.

                    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…)
                      2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                    • Translation in Japanese: "インデックスのドロップ" を "インデックスの削除" にしてほしい

                      Translation in Japanese:
                      I want to translate "DROP INDEX" to "インデックスの削除" instead of "インデックスのドロップ" in Japanese.
                      Other Items last word in Automatic turning is Kanji, not Katakana.
                      Like. "FORCE PLAN" to "プランの強制", "CREATE INDEX" to "インデックスの作成",
                      So, I want to translate "DROP INDEX" to "インデックスの削除".

                      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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                      • Fix shema issue recommendation for 'invalid_column' is useless without the column. Please fix.

                        Right now the 'invalid_column' recommendation doesn't show the table or the column that's at issue making it virtually impossible to tell what's actually wrong especially when deploying to production environments correctly with batched SQL changes in tools like entity framework or Red Gate etc.

                        Please fix this to add the table and column that's the issue.

                        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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                        • Inconsistent AzureAD logon experience when using MFA

                          We are using MFA enabled AzureAD accounts to access Azure SQL.

                          When accessing SQL databases we must select 'Active Directory Universal with MFA Support' from SSMS in order to login, Active Directory Password Authentication does not work as there is no support to log in using MFA - this is the behaviour I expect.

                          However, if i invite my MFA enabled AzureAD account into a second AzureAD directory and grant that account permission to access a SQL database in a subscription linked to the second AzureAD directory then i can log in using Active Directory Password Authentication
                          i.e. MFA is…

                          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 →
                          • Restoring Azure SQL database without knowing database size

                            When you need to restore an Azure SQL database that is in the elastic pool, and the free space in the elastic pool is not big enough to fit the restore, it runs for hours, and then fails. Without telling you why it failed.

                            It would be nice if you saved the size of the database together with the backup, so we could see the size required for the restore.

                            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 →
                            • Renaming stored procedure bug

                              When renaming a Stored Procedure from "spFoo1" to "spFoo2" via SSMS Object Explorer, I've noticed that the name of the
                              stored procedure name is still "spFoo1" in the [sys].[sp_helptext] 'spFoo2'. I haven't tested this for functions, etc. This causes big confusion if multiple people are going through the code with tools such as RedGate and aren't aware of the change or issue and are just going with the name. It may be good to have the option to validate that the stored proc code compiles and rollback the rename if it can't.

                              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 →
                              • Expose SQL Server and Database tags via the REST API When Listing Resource

                                Please expose SQL Server and Database tags via the REST API when listing the resource i.e. https://management.azure.com/subscriptions/{subscription-id}/resourceGroups/{resource-group-name}/providers/Microsoft.sql/servers?api-version={api-version}

                                The documentation shows that a tag JSON object should be returned when the resource is listed but this isn't the case; tags are available if the resource is queried directly though.
                                i.e. https://management.azure.com/subscriptions/{subscription-id}/resourceGroups/{resource-group-name}/providers/Microsoft.sql/servers/{server-name}?api-version={api-version}

                                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 →
                                • Don't replace a manually-entered database name when importing a SQL Database.

                                  When importing a SQL Database using the SQL Servers 'Import Database' feature, selecting a bacpac file from Azure Storage should not overwrite anything that I've manually entered into the 'Database name' field with the name of the bacpac file.

                                  2 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 →
                                  • Broken link on Database Configure page in old portal

                                    See the screenshot attached - the link for "Learn More" is broken on Databases -> Pick Databse-> Configure is broken.

                                    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 →
                                    • Better message on new portal when IP address for SQL database not found

                                      On the old portal, I at least get a message when trying to set firewall rules that the IP address of the SQL database cannot be found. On the new portal, the blade just sits there an does nothing.

                                      Also, whatever the core problem is, it would be nice if that was fixed. I cannot connect to the SQL database with SQL Server Management Studio. Even though the database is active, and the MYSQL migration tool is currently pumping data into the database.

                                      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 option to select MS SQL Collation during VM+MS SQL provisioning in AZURE Portal

                                        Every time MS SQL Deployment (IAAS) in AZURE, we've to raise Ticket to AZURE Support for request to change Collation Type. It is challenged for us since we don't have DBA in place. Please consider to make the option enable during VM+MS SQL provisioning in AZURE Portal.

                                        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 →
                                        • SQL Database Metric shows 100% peaks for DTUs in hourly view, switch to Daily shows 50% peaks

                                          SQL Database Metric shows 100% peaks for DTUs in hourly view, switch to Daily shows 50% peaks.

                                          I am trying to work around if we are reaching DTU limits and the charts show different values for daily than hourly. Especially when there are 100% peaks in hourly.

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

                                          SQL Database

                                          Feedback and Knowledge Base