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. Provide programmatic (PowerShell) way to get quota limit for Azure SQL Servers in subscriptions

    Automated deployment scripts need a way to get the quota limit for Azure SQL Servers in subscriptions. Relying upon the Azure default is insufficient, as the quota limit might have been adjusted.

    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 →
    • On premise encrypted data is not easily migrate to Azure SQL. Allowing the master key to be restored on Azure SQL would make the migration p

      On premise encrypted data is not easily migrated to Azure SQL. Allowing the master key to be restored on Azure SQL would make the migration process seemless.

      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 →
      • Support Event Grid for triggers and/or service broker external activator

        I know Azure Event Grid has been released as preview. SQL Server has features like triggers and service broker that are not currently supported by Azure SQL.

        Do you happen to support Azure Event Grid on Azure SQL so that we can implement triggers and/or service broker external activator?

        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…)
          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
        • Add support for unsigned integer data types

          Add support for unsigned integers (equivalents to ushort, uint, ulong) as SQL data types.

          .NET supports them. SCOPE/U-SQL support them. It's time that SQL DB and ADW support them.

          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…)
            2 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Fix inaccurate tooltip on ssms tab after Change Connection

            In SSMS 2016, the tooltip or balloon on a given tab is not updated if you right-click and select the "Connection | Change Connection" menu option, moving to a different database 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…)
              1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
            • Expanding the [Statement] field in Extended Events

              SQL auditing in Azure Tables is being replaced with Extended Events (.xel) files in Blob Storage. However, the [Statement] field in the .xel file only holds 4,000 characters. SQL Queries longer than 4,000 characters are being truncated and we can't see what they look like.

              Please expand this field to be a nvarchar(max) field.

              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 →
              • Need to be able to see % complete of a COPY

                We had a COPY take an unusually long time during a go-live ( of course ). It was frustrating that we had no way to tell how the copy was proceeding. The view sys.dm_operation_status is only good for seeing that there is a copy in progress, but it does not provide any other useful information.

                Therefore, we need this view to be more useful AND/OR be able to see 'in progress COPY info' in the portal. The activity log is useless for this - it only shows the start.

                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 →
                • Writing Azure SQL Audit logs to a storage account in a different subscription via PowerShell

                  Update Set-AzureRmSqlServerAuditingPolicy to allow you to write to a storage account that is in a different subscription than the Azure SQL DB. This can be done via the Portal but it would be nice to be able to do it using PowerShell to automate the process.

                  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 →
                  • Allow Elastic Jobs in CSP / ARM Subscriptions

                    We have most of our clients already in Cloud Soution Parter (CSP) subscriptions. These Azure Subscriptions are ARM only.

                    Currently SQL Elastic Jobs only works in subscriptions with ASM support, as it provisiones classic CloudServices & classic Storage. Those should be replaced with non classic Storage, and possible Azure Web Jobs to replace the Worker CloudService.

                    Please allow Elastic Jobs y CSP / ARM only subscriptions

                    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 →
                    • BEGIN DISTRIBUTED TRANSACTION

                      Server-side support for T-SQL such as BEGIN DISTRIBUTED TRANSACTION is needed for 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 →
                      • Bacpac import needs the ability to add database in elastic pool

                        Currently, the bacpac import functionality will not let you add the database in an elastic pool. You need to set the tier first during the import. We have an application that let end user add a database from the bacpac file and we need to set the tier then import the bacpac then add it to the elastic pool. The ability to add the database during the bacpac import process to existing elastic pool will save us time and effort. This feature is very important to us users as we can have the flexibility to either add the database from…

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

                          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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                          • Shared query store for elastic scale

                            We use elastic scale to shard our database. It works in multi-tenancy model and each database share the same data schema, views. We noticed than when we move some tenants to newly created shard, azure sql uses inefficient execution plans. It takes some time till statistics are gathered. That'd be great if all shard used same store for statistics so same query executed on each shard uses same execution plan.

                            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 →
                            • Option to enable network (stream) compression from connection string

                              To reduce time and save network bandwidth (=> reducing costs) for transfering raw data from/to Azure SQL Server, it would be very desirable if one could enable compression from connection string (I think even simplest/fastest compression algorithm would be beneficial).

                              This feature would be especially appreciated by users who communicate with Azure SQL Server from different geographic regions (for example Europe <--> West US, etc.)

                              Bonus: allow user to change default compression level for different trade-off between compressed size and speed.

                              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 →
                              • Allow OPENJSON to match to property names while ignoring case

                                Some json serializers change the case of property names from pascal case to camel case while others don't. Some have options to do one or the other. When passing in json data from outside sources, it would be nice if we didn't have worry about matching the case.

                                If this syntax or similar worked without having to match case, it would be very helpful:

                                -- image this was passed in through a proc parameter
                                DECLARE @json VARCHAR(MAX) = N'[
                                { "id": 1, "name": "Bob" },
                                { "id": 2, "name": "Carl" } ]';

                                SELECT ID,
                                [Name]
                                FROM OPENJSON(@json)
                                WITH (
                                ID…

                                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 →
                                • Elastic Database jobs support for V12 dacpac

                                  The current elastic jobs only support V11 dacpac deployments which do succeed in deploying to all of the shards in an elastic pool. The V12 features which we are using (mainly around JSON functions) prevent us from being able to create a V11 dacpac. The only current workaround is to create the tsql scripts via schema compare and modify them to be idempotent to be executed by the elastic job. This is becoming a large task to keep up with our database developers.

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

                                    Restoring BAK instead of BACPAC file by mistake does not error out and takes hours. Suggest to add file format validation logic at the SQL DB import layer.

                                    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Azure SQL Monitoring Tool Enhancement

                                      Need an out of the box solution for monitoring and alerting on such things as blocking locks, long running queries and running sql against the DM tables to build custom dashboards / alerts

                                      10 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 →
                                      • 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
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                        • reduce the lag when connect to the database

                                          reduce the lag when connect to the database, it is very slow when using management studio to connect to database,i need to take 10 seconds to expand the database table, moreover, when i use my visual studio and debug , it always have underlying on open error when trying to use entities to connect

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

                                          SQL Database

                                          Feedback and Knowledge Base