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 connection from Power BI

    I'd like the option to allow connections from Power BI ONLY
    Current options allow me to

    1. Allow access to Azure services
    Not sufficient, will allow connection from all resources in Azure

    2. IP Whitelist
    As far as I understand it's not possible to whitelist Power BI without whitelisting an entire data center

    3. Virtual network
    This alternative allow me to install a VM with Gateway, however this results in unnecessary costs

    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  ·  Flag idea as inappropriate…  ·  Admin →
    • Add DTU as a column in Query Performance Insights

      As it stands, QPI shows things like CPU, data and log IO which are components of the DTU calculation but not the entire store. This has made our work trying to understand how we are showing 30-60% DTU usage in the overall graph in overview but not a since query in the top 20 of QPI showing anything over 1% in CPU, data or log IO. It would be a big help if the max cost in DTUs for listed queries in QPI was available to take some of the guess work out. With this different way of measuring performance…

      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  ·  Flag idea as inappropriate…  ·  Admin →
      • Managed instance does not support restoring database with over 280 files?

        Hi,

        I am currently trying to restore a .bak file to an MI instance. When I do RESTOREFILELIST, it looks like the DB contains 341 files (including mdf/ndf/log).

        When I then try to RESTORE the DB, I receive the error in SSMS that [Msg 41916, Level 16, State 0, Line 7 Maximum number of 280 files for SQL Database Managed Instance reached.]

        Does this mean that any managed instance does not support restoring a database with over 280 files?

        Or is this just a problem trying to restore the DB through SSMS/T-SQL? If this is a SSMS/T-SQL problem, would I…

        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  ·  Flag idea as inappropriate…  ·  Admin →
        • Performance of Storage IO for non-BusinessCritical tier are not matching almost any real-world application

          Performance of DB are almost completely defined by the Storage IO latency. It is impossible to have decent performance for a "normal" real-world environment with a SQL Database if you don't choose the BusinessCritical tiers, which are very expensive. The same performance can be achieved with a VM at 1/4 of the price, just by adopting a couple of basic SQL Server strategies.
          Either:
          1) Decrease dramatically the cost of the BusinessCritical tier
          2) Enable some Storage configuration for the user, maybe with the help of support team (e.g. store Logs in fast SSD local disks, etc.)
          3) decouple the…

          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  ·  Flag idea as inappropriate…  ·  Admin →
          • Sql Server Agent SSMS Error in Job Creation Managed Instance

            although I can create a job, if you lose context and come back in SSMS the job upon creation says already created, Appears to have a update problem.

            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 →
            • Audit log queue details

              My understanding is that there are buffers in place that limit the number of concurrent writes to audit logs, however that information is not public. Can you share the details of the queue buffer limits or, even better, make this a feature that customers can control on their own?
              Thanks.

              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  ·  Flag idea as inappropriate…  ·  Admin →
              • Add ability in Azure SQL DB to have use minimal logging

                Would like the ability in Azure SQL DB to use minimal logging just an an om premise SQL Server would do. For example, doing an insert into an empty table with only a clustered index and specifying WITH (TABLOCK) should do minimal logging.

                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  ·  Flag idea as inappropriate…  ·  Admin →
                • Add ability to stop/start Elastic Pool

                  I would like the ability to start/stop an elastic pool for development purposes. The pricing lists hourly pricing, so I assumed it would be a possibility. If I can schedule it to shut off at night, and pause all SQL databases, then I have a separate elastic pool just for development purposes, and put that elastic pool in our development Resource Group

                  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  ·  Flag idea as inappropriate…  ·  Admin →
                  • Allow acces to Azure services by region

                    On the SQL Firewall page have an option that says Allow access from Azure Services in Region where each azure region is listed and you select which ones to whitelist. The reason for this in my case is that I have functions on a function app that is on a consumption plan and so I had to get the azure data center up range for Canada central, Convert them to IPv4 start and end IPs and then manually enter them into the whitelist. And I’d expect they change over time. The Boolean allow access to azure services option currently available…

                    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  ·  Flag idea as inappropriate…  ·  Admin →
                    • PRODUCT Aggregate Function

                      Azure SQL Server (et al.) supports the SUM Aggregation function which allows the addition of all underlying items in an aggregated group.

                      It would be great if you supported a PRODUCT equivalent that multiplied all items in a group. This style of function is presently native in Excel and would mean that we no longer need to resort to complicate Logarithmic maths to perform the same operation.

                      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  ·  Flag idea as inappropriate…  ·  Admin →
                      • Send maintenance notification in advance

                        Recently we have got maintenance notification one day before maintenance starts.
                        It's very useful for me, however, I'd like to get it earlier, e.g. 3 business days before the maintenance.

                        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  ·  Flag idea as inappropriate…  ·  Admin →
                        • Printing documentation pages from Edge, Firefox, and Chrome is still broke!

                          In Edge only the first page is formatted for printing. All the rest of the pages are gone. In Chrome, Edge, and Firefox a bunch of characters on the right are truncated. In order to get them on the printed page one has to use such a tiny font that the pages are really hard to read. Before you made these changes a couple weeks ago, the printed pages in all these browsers were of top quality. Now they are largely unuseable!! This will drive Azure customers away, while before the high quality of your printed pages were a big…

                          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 →
                          • Elastic query without opening firewall to all of Azure

                            From the documentation at
                            https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-query-vertical-partitioning#best-practices

                            It says "Ensure that the elastic query endpoint database has been given access to the remote database by enabling access for Azure Services in its SQL DB firewall configuration"

                            There should be a way to enable elastic query without allowing anything in Azure to connect by setting "Allow access to Azure services" to ON.

                            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…)
                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • "ALTER DATABASE <db name> ADD FILE <logical file name>" doesn't work under specific condition in Managed Instance

                              I restored to Managed Instance via ".bak" file. this source DB configured some database file.

                              After restored, I executed
                              "ALTER DATABASE <db name> ADD FILE <logical file name>",
                              following error occured.

                              -----
                              Unable to open the physical file "https://wasd2p*****.blob.core.windows.net/managedserver-********071/data/829f3544-******_3.ndf". Operating system error 80: "80(The file exists.)".
                              -----

                              (if source DB's database file is single, work correctly.)

                              execute this T-SQL with changing "logical file name",
                              physical file name's seq number in error message incremented
                              and finally, it worked.

                              is this bug ?

                              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…)
                                4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                              • 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…)
                                  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                • Add the feature to turn off/on Azure Database for MySQL server

                                  We need to have the same "Server name" after turning on the Azure Database again, would be nice if some cost would be lower as we just use Storage in a stopped state.
                                  Cloud is all about "Pay as you go"!

                                  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…)
                                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Automatically provision larger VMs for importing BACPAC files using the Portal

                                    The Azure SQL Database Import/Export Service internally creates a VM(or worker role) which is too small to enable complete importing of larger files. In such cases, we get a “System Out Of Memory Exception” message and the process fails. Although the workaround of using our own VM with sqlpackage.exe, this is slower, less convenient, and more expensive (we do not normally have an available VM of an appropriate configuration available). Please see Microsoft Premier Ticket 118070418515259 for details. Note that in our case, this entire export/import process is a workaround for being unable to directly copy a database between subscriptions.

                                    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  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Remove or increase number of databases limitation from Elastic Pools or Managed Inscances.

                                      At this moment we have arround 6000 databases distributed by 14 elastic pools only because we cannot place more tham 500 databases on each of them.
                                      Each of the elastic pools have less than 60% of storage used and the maximum number of eDTU used is allways under 15%.
                                      So, basically we are wasting DTU's and consequently money on all this elastic pools.

                                      7 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  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Implement password expiry & password history & certain number of account lockout for Azure SQL databases

                                        We could see below gaps for Azure SQL Database (for PAAS scenario)

                                        1) There is no Password History
                                        2) There is no Password Expiry
                                        3) There is no Account Lockout set (wherein account will be locked out after certain number of failed attempts) which could lead to bruteforce attacks.

                                        All these above parameters must be addressed and aligned in accordance with Industry Standard.

                                        As discussed with Omeswar Reddy Danwada uploading this idea

                                        6 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • failover

                                          Allow VNET access for Azure SQL Failover Group

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

                                          SQL Database

                                          Feedback and Knowledge Base