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

      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 seamless login with ADFS for SQL Server Management Studio 17

        We have both Azure Active Directory and an ADFS farm. I would like to enable multi-factor authentication for my users accessing our Azure SQL Databases using SSMS 17.1, but it's too inconvenient. They will revolt.

        My options are:
        1) Enable multi-factor auth (MFA). Users of SSMS must connect using Active Directory Universal Authentication. This causes a forms auth popup which collects email address then redirects to a login form for email+password, and finally a MFA check. User is disconnected after the token timeout period (30 minutes?) after which they must go through this all again.

        2) Leave MFA disabled 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 →
        • Cancel Updating database pricing tier on Azure Portal

          Sometimes it would be good to cancel a scale event instead of letting it finish, then re-scaling back.

          Examples include:
          - Human error when creating scale event (Wrong DB, Wrong Size, etc).
          - Scale event taking too long
          - Changed mind

          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 database specific alerts to be set up at elastic pool level

            At present, you can set up alerts for elastic pool resources and alerts for individual database resources. However, if you have say 100 databases in your elastic pool, setting alerts per database is a real pain.

            It would be good to set up database specific alerts at elastic pool level so it can be managed easily.

            For example, we'd like to set up an alert when the number of database sessions reaches 80% but doing this across all of the databases in an elastic pool isn't easy.

            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…)
              3 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Increase 'Request limit' for P1 databases

              We are constantly hitting the the 200 'request limit' for our P1 database - due to a very chatty workload, that we don't have much control over.

              Even though database utilisation is normally quite low - 30%.

              There is no easy workaround for this limit - and upgrading to a P2 seems massively over-spec as the database would likely be sitting at just 15% utilisation or less.

              We'd even be willing to pay a little bit more to increase the request limit.

              We really feel backed into a corner here - with no option other than doubling our costs to…

              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…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Proper CSV import/export support (and NO, it doesn't currently exist)

                Importing from CSV is a royal PITA, as SQL Server doesn't support quoted and escaped columns. Good luck importing data if it has commas in it. Any delimiter you choose will likely be included in some column and ***** things up. Importing data into MySql, Postgres, Redshift etc etc is soooooo much easier

                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 negative server-level firewall rules, or editable firewall rules on read-only replicas

                  I'd like to allow a customer read-only access to their geo-replica. I'd like to be able to add a database-level firewall rule to the replica, but I cannot because the replica is read-only.

                  If I add an allow rule on the primary database (which will replicate to the replica), then there's a risk the customer could log into the primary, which I don't want.

                  So my only solution is to add a server-level allow rule on the replica server, which exposes all the other databases on that server to authentication attacks.

                  Ideally, I could add allow rules on the read-only…

                  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 →
                  • SQL Database, Overview blade, Monitoring Graph - provide option so Y-axis can be fixed from 0-100% DTU Percentage!

                    The Azure Portal was changed over the last weekend of May 2017, to make the Y-axis of the Monitoring graph only go as high as needed to show the maximum DTU Percentage used during the displayed period.

                    Prior to that weekend, the Y-axis of the Monitoring graph was always scaled from 0 to 100% DTU Percentage.
                    This allowed us to see how busy our DBs were with just a glance.
                    With the change mentioned above, we have to look much more closely now at the scale of the Y-axis, in order to determine the real DB load.
                    This would seem…

                    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…)
                      2 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…)
                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                      • Enable Query Data Store in Secondary Geo Replicated Databases

                        We use Geo Replicated Secondaries to distribute query load among the secondaries. Right now, QDS is only available for the Primary. It would be really nice if we could use all the power of QDS on the secondaries to diagnose issues.

                        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 →
                        • Would like to deny schema access to sql azure database owner (not db_owner role)

                          Once a sql azure database is created by a login, we would like to be able to stop this login from seeing data in the schemas. Row security can be used to hide the data but a user logged in with this login can turn the row security off and then get access to the data.

                          53 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…)
                            5 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Set Azure SQL database size threshold in increments of 5 and 10

                            Currently standard tier does not allow to set a size such as 60GB, 70GB. It only allows increments of 50 after 50GB. i.e. 50GB, 100GB, 150GB.

                            However increments of 10 is possible between 0-50GB.

                            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 →
                            • Update SQL Server Migration Assistant for DB2 to support iSeries databases in addition to LUW and z/OS

                              The SQL Server Migration Assistant for DB2 currently supports the LUW and z/OS flavours of DB2. Our company desperately needs to get off its iSeries 7.1 version flavour of DB2. Please add support for this to the SSMA.

                              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 →
                              • Simple Calculator DTU

                                Please provide a scenario DTU calculator.

                                I know that it is very difficult to tell the amount of DTU needed for each one, but it would be possible for azure to offer a calculator that allows you to calculate based on a scenario already experienced by the azure team.

                                Example:
                                A scenario where only the employees of the company will use, with X specifications and not very complex queries etc. Being on average Y simultaneous employees on average, and other features, if they want to leave well specified.

                                Based on an entire scenario mounted by azure, we would know how…

                                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 →
                                • South India SQL Database price

                                  Hi,

                                  is this a bug in calculation?

                                  Why only South Indian SQL Database Basic price is higher comparing to all other available region.

                                  Azure pricing calculator show $124 per month for South India when other region is just charging $4 or $5.

                                  Anyone Please confirm

                                  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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                  • firewall subnet

                                    Allow Creating Azure SQL Server Firewall rules by specifying subnet such as 1.1.1.1/32 is preferable to specifying a start and end ip.

                                    Workaround is:
                                    ($ip, $cidr) = $subnet -split "/"
                                    $iprange = Get-IPrangeStartEnd -ip $ip -cidr $cidr
                                    $startIp = $iprange.start
                                    $endIp = $iprange.end

                                    Set-AzureRmSqlServerFirewallRule -ResourceGroupName $ResourceGroupName -ServerName $SqlServerName -FirewallRuleName $name -StartIpAddress $startIp -EndIpAddress $endIp

                                    still makes the management messy and seems to be non standard.

                                    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 →
                                    • API to check remaining DTU limit of a server

                                      Can we have an API to get remaining DTU limit of a server? This will be useful to know if a given logical server has hit the limit of 45000 DTUs.

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

                                        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…)
                                          0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                        • SSRS

                                          SSRS PaaS offering

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

                                          SQL Database

                                          Feedback and Knowledge Base