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

            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 →
            • 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 →
                • 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 "インデックスの削除".

                  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 →
                  • Distributed / cross-database queries within an elastic pool

                    We're familiar with elastic queries, but there's a class of cross-database query scenarios that they don't address.

                    What we really need is the ability to perform a query across multiple databases. In SQL Server on-premises, this is done with a three- or four-part notation to reference the external database. That option doesn't exist in Azure and is required for a number of scenarios.

                    For example, Dynamics GP uses multiple databases, so it simply can't run on Azure SQL. We have additional third-party systems that have the same requirement. So we literally have no way to move to Azure as a…

                    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…)
                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • PaaS - Only pay for what you use

                      The Microsoft Azure statement for "only pay for what you use" is misleading for PaaS non-production environments. By design, non-production environments are typically only utilized when needed. However, in Azure, for PaaS databases, you are paying 100% of the utilization hours, regardless if you need to use the database or not. This is a flaw in the design in Azure.

                      Note that this capability is now available in Amazon AWS and puts Microsoft Azure at a drastic disadvantage when comparing pricing if it is known upfront that "only pay for what you use" isn't true for PaaS databases. See article…

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

                        For Parallel developments we want spin up multiple copies of the database with less storage foot print leveraging virtualizations/Clones . Is there a possibility to expose the database backup's or any API's to update our master system to get the real time updates from Azure SQL DB so that we can have the near real time update to our Development for CD.. We have a workaround by doing a backpack or performing object level tracking for changed data.
                        It will be easier if we have much simpler way to do that.

                        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 T-SQL equivalent command for the Switch-AzuremRmSQLDatabaseFailOverGroup

                          Provide T-SQL equivalent command for the Switch-AzuremRmSQLDatabaseFailOverGroup

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

                              Make the semantic search capability of SQL Server available in Azure SQL Database.

                              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 →
                              • Enable SQLAzure to "On Premises" database migration via Data Migration Assistant (DMA)

                                Since the SQLAzureMW as been made unavailable, our only option for migrating databases is the Data Migration Assistant (DMA).

                                DMA does not allow for SQL Azure to On Premises migration only.

                                SQLAzureMW was the best way I had found to make local copies of SQL Azure databases. This ability is critical for developers and IT folks.
                                Please add this feature to the DMA.

                                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 →
                                • sp_msforeachdb for Azure Database

                                  SQL Server 2008 through 2016 had this undocumented stored procedure which allowed the DBA's to execute a certain task/script on multiple database at one shot but with Azure database/logical server this stored procedure is no more available.

                                  15 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…)
                                    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • When using blob datasources with bulk insert, using a subfolder within the referenced blob container causes character convertsion issues

                                    When doing an export/import operation between 2 databases using blob storage, special characters are scrambled when pointing to files on a subfolder within the blob container. When referencing files on the root location, the data is imported (using bulk insert) without issues.

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

                                          SQL Database

                                          Feedback and Knowledge Base