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. 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.

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

      SSRS PaaS offering

      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 →
      • New Pricing Tiers - X Small Databases

        I think current Basic Elastic 50 and Single Database are still expensive for small databases, currently I have got 7 databases, size together 200MB. How can be the Basic for ~$74.40/mo and pool 5GB good for this?

        Currently I am paying them as Single Databases but it is also expensive as my databases will never get 2GB.

        You could create additional Tiers for Single Databases of max size 100MB and 500MB and Elastic Pool could be indeed also 1GB or 2 GB.

        Similar requests were closed as Completed

        https://feedback.azure.com/forums/217321-sql-database/suggestions/4908333-sql-azure-more-scalable-pricing-for-multiple-smal

        https://feedback.azure.com/forums/217321-sql-database/suggestions/9908991-add-extra-small-elastic-database-pool

        I can see the advantage of Basic 50 Elastic Pool…

        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 →
        • Decouple the eDTU and GB in elastic pools

          We have many (308) databases in 1 elastic pool, these are transitionally light, but storage heavy databases.

          We are currently about to run out of available storage in the pool, however our average DTU sits around 6% - being forced to add another 100 DTU for purely to get more storage is a waste, as our databases don't need to extra DTU.

          Being able to add more storage while keeping the DTU and 200 would be great.

          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 →
          • Elastic pools, ability to configure minimum eDTU per database singularly

            My request is to have the possibility to setup for each database, singularly, the minimum eDTU available.

            At the moment it's possible to set a maximum and a minimum for all databases.

            I think, for the nature of this kind of services, it's crucial to allow to maybe setup 0 as minimum for databases you do not care (eg: testing-staging instances, new projects) and a higher minimum to the more significant ones.

            Maximum will be interesting as well, but minimum i think is more important to guarantee a quality of service.

            In little elastic pools, it's easy be over the…

            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 →
            • Acquire TabStudio plugin and integrate into SSMS

              www.tabsstudio.com plug-in allows for editor tabs to be displayed vertically on multiple rows, rather than just the default behavior of right-left navigation on a single row when too many opened documents exceed the available width. BTW, that product works for Visual Studio with the same functionality. Add the new configuration settings to Tools | Options |Environment | Tabs and Windows setting page.

              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 →
              • Need the ability to set a time zone per Azure sql database

                We need to be able to set the timezone for an Azure sql or DW database. This should be a database option.

                Now we are faced with changing all of our code which references getdate() and similar date functions.
                We shouldn't have this extra difficulty in moving to a cloud database.

                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 →
                • Support for Julia Programming Language along with R

                  Please add support for Julia Programming language. It will improve performance in statistical computing

                  http://julialang.org/

                  https://en.wikipedia.org/wiki/Julia_(programming_language)

                  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…)
                      2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Enable Bulk Access for SQL DB from Data Lake Storage

                      Following the announcement of Bulk Loading from Blob Storage (https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/02/23/loading-files-from-azure-blob-storage-into-azure-sql-database/) , I'd like this to be extended to be able to use Data Lake Storage

                      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 →
                      • Make target service objective for scaling operation available via SQL tables/views

                        Target service objective was available in slo_database_objectives in V11, but it not available in V12.
                        This makes admin tasks harder.

                        30 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 →
                        • Improve to allow multiple tables to have SET IDENTITY_INSERT ON enabled

                          Improve SQL SERVER to allow multiple tables to have SET IDENTITY_INSERT ON enabled.

                          At present, per MSDN, only one table can have SET IDENTITY_INSERT ON enabled at a time.

                          This seems like a prehistoric limitation.

                          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 →
                          • Expand Index Advisor to cover index health (suggesting unused indexes, fragmentation)

                            Index Advisor currently suggests the creation of new indexes.

                            It's functionality should be expanded to cover index health (fragmentation) as well as unused indexes that haven't been used.

                            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 →
                            • Add posibility to check name availability into API

                              Hi, when creating an azure environment through API (Storage, SQL server, SQL database) - I need to be able to check if the name is available.

                              For Database this is not necessary.

                              For storage this is available
                              https://docs.microsoft.com/en-us/rest/api/storagerp/storageaccounts#StorageAccounts_CheckNameAvailability

                              For Server this is not available
                              https://docs.microsoft.com/en-us/rest/api/sql/servers#Servers_List

                              So if I want to check whether the admin can actually create these resources to link with the tenant he is creating - I can validate the storage, but then I simply have to try create a database and either it fails or it goes through - or is there some way to check this?

                              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 →
                              • Show Actions, Status, and Errors in the SQL Data Agent

                                The SQL Data Synchronization feature which is currently in preview requires that an agent be installed on the on-premise DB servers which need to be synchronized with Azure SQL DBs. It is easy enough to launch this agent on the database server, and it does show some information about which databases are connected and their status. However, a variety of things can go wrong while setting up the Sync Group (particularly with some aspects of the schema which may prevent schema the schema refresh step). Currently, it is unclear what checks are being made, what process is under way, and…

                                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 →
                                • Add .Net Core Support for Microsoft Active Directory Authentication Library for Microsoft SQL Server

                                  Right now this requires .Net 4.6, we have a Core app, would be great if this supported .Net Standard 1.6

                                  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 →
                                  • Blob Auditing Type for Azure SQL Database Threat Detection

                                    Blob auditing was recently rolled out for Azure SQL Database, "which provides higher performance, supports higher granularity object-level auditing, and is more cost effective." However, Threat Detection does not currently support blob auditing, only table auditing. As a result, one of the most common reasons to turn on auditing, threat detection, cannot actually use the better performing method. Please allow Threat Detection to use blob auditing types.

                                    18 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 →
                                    • DATA SYNC - RIP? January 2017

                                      DATA SYNC - RIP? January 2017

                                      Can we have an up-to-date progress report for Data Sync. It would solve a lot of out client issues but its never come out of preview. Please advise

                                      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…)
                                        2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 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…)
                                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 11 12
                                          • Don't see your idea?

                                          SQL Database

                                          Feedback and Knowledge Base