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. SQL Editor in Azure Portal

    Can we have SQL Query Editor in Azure Portal where we can query to Azure SQL database.

    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 →
    • Why dont we have

      Why dont we have an alert which will fired when DTU is high for a duration. The current alert mechanism fires an alert whenever there is a spike and it is not so useful as just a spike is expected many times and doesnt indicate anything meaningful to me. Hence, we request you have this feature where an alert should be fired when DTU is consistently high for a duration of say 15 minutes. Hope you consider this idea. Looking forward for this to get implemented.

      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 →

        Thank you for submitting this feedback.

        It looks like based on your request description, Azure Monitor provides this functionality:

        https://azure.microsoft.com/en-us/documentation/articles/monitoring-overview-alerts/

        Assuming your requirement is “Alert when average DTU is high for a duration, e.g. for 15-minutes, average DTU is 90%” – this is supported by default when creating an Azure Alert in the portal. So you can select “DTU percentage” as the metric, the condition (greater than, greater than or equal to), and the threshold and period. For example, 50% over the last 5 minutes (average is default).

        If your requirement is “Alert when DTU is at least 90% during a 15-minute period, i.e. the minimum DTU value for 15-minute period is 90%” – Azure Alerts supports a min/max/average/sum over the metric in the specified time window. Currently in the Azure Portal, we don’t expose picking the aggregation type (default is average) but it’s on the backlog as a…

      • Provide a way to deploy Native SSRS to a Web App

        You have discontinued the PaaS option for SQL Reporting.

        The alternative option suggested of running a full version of SQL Server Standard Edition in a VM just to run SSRS when we already are using SQL Database for our data is very expensive. We need to pay for a full SQL Server license when all we really want is an instance of the SSRS Native-mode Web Application. Paying the full SQL Server Database Engine cost is unreasonable in this scenario, and the burden of maintaining an IaaS resource is significant.

        Please provide a Web App or Marketplace Service which hosts…

        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 →
        • free DB plan with 15 mb db for noobs learning

          There is no a free db options to really understand the mechanics of cloud programming. I would appreciate a plan with limited db capabilities for free.

          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 →
          • Azure SQL Data Size

            How to update the database size for 10GB to 20GB. Old portal allows 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 →
            • Ich habe noch nie so etwas unwilliges bedient.

              SQLServer - can't connect
              Virtual Machine - can't connect

              Others made a better job.

              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 →
                • Database shows as "Database not available" in new Portal

                  One of our SQL Databases shows as 'Database not available' in the new portal. The Resource Group is shown, but the Status (---) and Location (Not available) are not.

                  We're also not able to manage the database from the new portal at all; Restore shows a new blade with 'Error loading tile', Resource utilization shows 'No available data' and so on.

                  Other databases on the same server display just fine in the new Portal. The database that shows the error is displaying just find in the 'old' Portal.

                  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 →
                  • Allow additional sysadmin users

                    Provide the ability to have more than one "sysadmin" user that can have access to all DB's

                    2 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 →
                    • DTU Resource Governor

                      I often run into problems where my daily DTU needs are moderate, but I have long spikes in DTU for aggregating data. The problem is that the data-aggregation trips the OLTP and makes primary business time out. So my problem is that I need to have a max DTU for the data-aggregation session so this doesn't happen.

                      I don't care if the data aggregation takes 10 times longer as long as it doesn't trip up the running OLTP transactions.

                      12 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 →
                      • I tried to create a basic tier database instance. This started 1h 20 mins ago. This is crazy slow!

                        I tried to create a basic database instance on an existing server. This started 1h 20min ago. I cannot see the progress of this operation. I then tried to create another database on the same server, and got an error, saying that a deployment was already in progress, and due to time out in 1 week. Clearly this is not commercially viable performance.

                        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 →
                        • Please fix the new portal for Firefox

                          Cannot export database with Firefox. Too much hassle to start IE or Chrome now, so keep using the old portal for now..

                          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 →
                          • Can't I manage database with silverlight via web page like before??

                            How can I manage database via web page??
                            I coun't find management portal.

                            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 →
                            • Repeatedly blades do not load.

                              On some days (I haven't seen a pattern) the portal just doesn't work correctly for new entities. I create a SQL server and the main blade (e.g. sql server) loads find but settings just don't. If I search for the resource it will appear with other databases but clicking on it doesn't do anything (all my other databases load without problems).

                              Can't provide much information, but usually it solves itself after a day or two - so I'm assuming it's some kind of caching issue, but there's no actual error message.

                              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 →
                                • Azure IP Filtering Security isn't working

                                  I've been using a database hosted in Azure for several months. Today, randomly, I could no longer connect to the database hosted in Azure. Nothing had changed on my end. I tried connecting from multiple machines. I tried using SQL Server Management Studio and connecting from a custom-built ASP.Net application that connected to the database. Everything gave the error "Unable to connect to server". All of these methods worked fine yesterday.

                                  In the Azure website, in the database settings, every time I clicked "Set up Windows Azure firewall rules for this IP address", I got this error: "Could not retrieve…

                                  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 →
                                  • Support Azure AD mutli-factor/two-factor authentication (MFA/2FA)

                                    Now that there is support for Azure AD Authentication, please add support for users with multi-factor authentication enabled!

                                    24 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…)
                                      7 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Raising support ticket

                                      I tried to raise a support ticket, filled in all relevant details and submitted.
                                      Its seemed to have worked correctly returned me to create a new ticket but when I tried to move to another part of the port I got the message data not saved.

                                      I tried this a number of times with the same message.

                                      It looks like the ticket was not created because it is not in my outstanding support tickets and I haven't received a confirmation email.

                                      Andy

                                      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 →
                                      • We should have a basic database support for MS SQL database too atleast express edition it would make working with VS more effortless,Thank

                                        I am sure i am not the only one feeling it.
                                        The present portal is way better than it was in last November thanks a lot for it.
                                        It would be better to have a basic express edition facility for MS SQL than MySQL. Then deployment from Visual-studio will be straight forward and better than present. Thanks again :-)

                                        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 →
                                        • Create a NewSQL database without sharding

                                          SQL Database built on SQL Server is not an Internet/cloud database. We shouldn't have to deal with sharding (including Elastic Scale) as application developers. Almost all other aspects of cloud development have been made easy for us except for database management. Why hasn't MIcrosoft created a database similar to many startups out there (MemSQL, VoltDB, NuoDB, Clustrix, etc.)? This is a shame. It would be fantastic to have NewSQL-as-a-service.

                                          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…)
                                            3 comments  ·  Flag idea as inappropriate…  ·  Admin →

                                            Jason –

                                            Thanks for your feedback. As you probably know we already offer a transparently scalable SQL solution in Azure for analytics/data warehousing workloads (Azure SQL Data Warehouse) as well as scalable “NoSQL” solutions like DocumentDB and Azure Tables.

                                            For full SQL Server compatibility in transactional workloads, sharding remains a necessity today in Azure SQL DB, but our goal is to invest in moving more of the sharding “intelligence” into Azure DB itself — governed by simply declaring policy at database design time — rather than requiring developers and devops to manage the specific shards over an application’s lifecycle. The initial efforts you see such as Elastic DB Client Library and Elastic Query capabilities are our first steps in this journey, and hopefully offer an improved experience compared to roll-your-own sharding approaches that were required in the past. But they are not the end of the story.

                                            The challenge with…

                                          ← Previous 1 3 4 5 8 9
                                          • Don't see your idea?

                                          SQL Database

                                          Feedback and Knowledge Base