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 Azure Data Lake as Polybase external data source to work for SQL Database too. Not just SQL Data Warehouse.

    Enable Azure Data Lake as Polybase external data source to work for SQL Database too. Not just SQL Data Warehouse.

    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 →
    • 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
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
      • Ability to retrieve the hashed password for a contained database SQL authentication user

        We would like to have the ability to copy a database from one environment to another. For example, production to integ. We also like to use different passwords in each environment for SQL authentication accounts. This means that during the database copy process we need to reset SQL authentication account passwords to the appropriate value for the target environment. However, there doesn't appear to be anyway to retrieve the hashed password from an existing database in order to reset the password on the copied database to the hashed value.

        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 →
        • Queue connections/requests that go over Concurrent Connection limit - don't kill them. This makes Azure SQL a useless toy until fixed.

          This should have been fixed... YESTERDAY. Do not kill my concurrent connections/queries, just queue them up if they go over the soft limit.

          Your horrible design causes my website to go down when it gets high load. This is a horrific design on your part. And please don't tell me to limit my connections on my side. When I use SQL Server in a VM I have no such limits or problems - even when it is a TINY VM. No more excuses, just fix it - it's been years.

          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 →
          • support in-memory technology in basic service tier.

            Hi

            I need to run perf test first with In-memory techonlogy for my website.

            so I have to run migration in basic service tier for table,sp,function and view or else but I did not want to pay during development or migration.

            if we can do it, i can easy to transfer my code to other servie tier when my website has a lot of requests in the future.

            I hope use In-Memory technology in basic service tier.

            Thanks

            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 →
            • Azure SQL DB Gateway IP address change notifications

              Since the IP addresses listed in the documentation below are subject to change, proactive notifications should be provided to ensure users can make necessary updates to their environment before changes occur. This could be an email to affected resource owners, or a notification within the Portal such as through Service Health or Resource Health.
              https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architecture

              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 →
              • feature need-Sync Azure database between Global subscription and China subscription

                support Sync Azure database between Global subscription and China subscription with Azure SQL Sync

                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 →
                • stop updating .net framework versions without asking

                  Our website worked fine until today when you updated the .net framework version to 4.7. Our site worked for years on .net framework 4.6.1. Now today you broke our site and I don't know how to fix it. Please enable the azure control panel to let me choose 4.6.1 not the 3.5 or 4.7 that you just changed it to today. I am in **** trying to figure out how to fix this Unable to load DLL 'SqlServerSpatial120.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) while my family's production website is down. Thanks for doing this…

                  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 →
                  • 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
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                    • Data Sync frequency/minimum sync Interval

                      SQL Data Sync frequency - Increase minimum sync Interval

                      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 →
                      • 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
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                        • Support for Linear interpolation in geography types

                          Support for Linear interpolation in geography types. Aviation data uses both Geodesic and linear interpolation. It would be of enormous use to us to be able to specify a line or part of a polygon to be a parallel.

                          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 →
                          • Native support to translate between different Coordinate reference systems

                            Native support to translate between different Coordinate reference systems. Even if this was down to the user to define a CRS with, say, OGC WKT or a PRJ file

                            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 →
                            • Ability to reduce the number of decimal places lat/longs are written to WKT or GeoJSON with

                              Ability to reduce the number of decimal places lat/longs are written to WKT or GeoJSON with. We have reduced our Json payload by well over 50% by reducing the lat long to 8 decimal places. This is still gives us about 1cm accuracy. However we have had to use C# code using sqlserver.types running outside Sql to perform this task. It would make like much easier if we could do this natively – the only way I can see to do this is SQL is through string manipulation.

                              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 →
                              • Native support for creating a GeoJSON string from a geospatial type

                                Native support for creating a GeoJSON string from a geospatial type. We currently do this by “ToStringing” the geography instance then doing several string REPLACEs to turn it in to GeoJSON. A fast, native function would be awesome.

                                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 →
                                • better mechanism of cross database communication for SQL PaaS.

                                  better mechanism of cross database communication for SQL PaaS.

                                  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 →
                                  • more view to database resource utilization like blocking locks, etc. in SQL PaaS

                                    • more view to database resource utilization like blocking locks, etc. in SQL PaaS

                                    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 →
                                    • SQL Database in Azure does not allow changing UTC to our default, setting UTC 0, considering this, how to migrate an on-premise database fro

                                      SQL Database in Azure does not allow changing UTC to our default, setting UTC 0, considering this, how to migrate an on-premise database from an existing system? Unable to change all code, so it is not possible to use a SQL Database in Azure for this? Is Azure not prepared for my country? Even AWS (Amazon) lets you change UTC, as Microsoft does not allow ???

                                      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 →
                                      • Deprecated SQL Columns

                                        Just thought I submit an enhancement request. The use case for this would be columns in a table that are no longer being used because the relationship is moving from a one to one to a one to many. However, we don’t want to remove the column right away because need to migrate the data. Therefore, it would be great to mark the column as deprecated, similar to how we mark elements (classes, methods, properties, etc.) in C# as deprecated.

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

                                          Able SQL Azure to broadcast and listen AMQP. For LOB UWP to be notified when a condition is reached on SQL Azure

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

                                          SQL Database

                                          Feedback and Knowledge Base