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 SQL Database to join Virtual Network (VPN)

    I have Cloud Service with web/worker roles connected to SQL Database (web edition).

    I also have Virtual Network with point-to-site client (P2S) connection, but I cannot connect to my SQL Database (web edition) via VPN (eg using SSDM). Instead I have to use internet connection.

    IP address assigned by my ISP has short lifetime and is reset daily. This means that almost every time I want to perform Admin tasks, I have to log onto Windows Azure portal to change my IP address in the SQL database firewall (defining a range of addresses is not an option).

    VPN would mean…

    1,310 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…)
      46 comments  ·  azure.microsoft.com  ·  Flag idea as inappropriate…  ·  Admin →

      Thanks folks for the feedback here. We are making progress on adding VNet support to SQL DB.

      We are also looking for a few customers to talk with and potentially add them to the private preview. Not all scenarios are likely to be supported initially but we are seeking feedback on include:

      1) Removing access to all Azure IPs if you want to connect to an Azure VM: Today when a SQLDB is created we allow all Azure IPs to access that DB (this leaves it open to malicious VMs within Azure) as this is the easiest way to connect SQLDB to Azure VMs. With VNETs you would be able to connect a specific VM to a specific SQLDB removing access to all Azure VMs.

      2) Easier management of VIPs: Another way to handle connection to VMs is to set firewall rules to allow specific VMs IP to access the…

    • Enable SQL Service Broker in SQL Azure

      Service Broker should be available in Windows Azure.

      531 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…)
        27 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • Implement FILESTREAM for blobs into Azure Blob Store

        Storing blobs in the database is fairly pointless when you have a dedicated blob store. Implement the FILESTREAM protocol to store blobs in a user's azure storage

        445 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…)
          10 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • MySQL and PostgreSQL as DAAS from MS (like an Azure SQL database)

          MySQL and/or PostgresSQL as a DAAS from Microsoft or atleast please buy ClearDB.

          I work for a University and we really need mysql/postgresql to exist as an offering from MS and not from a provider as we cannot always use the non MS offerings for Mysql for your systems . Our databases are primarly mysql/postgresql and it's not a realistic scenario to convert/migrate to Azure SQL. I Think alot of universities need this as a native offering in azure. The ClearDB solution is something that we can use but not for everything, for this kind of solution we really need…

          369 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…)
            31 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • OData Support

            1. Create a new Database.
            2. Check an "Enable OData data services"
            3. Get a non-code OData service over the database

            354 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 →
            • Azure SQL Database User Managment

              Please add a GUI to manage the users and their privileges in Azure SQL databases.

              210 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…)
                6 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • Make SQL Column Store Feature Available for Standard Tiers

                Please don't make column store indexes premium only feature. We can use column store in SQL Standard Edition so why here should be different? Premium features should be performance gains to existing features, not banning them altogether for those of us who can't afford the premium prices.

                157 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…)
                  8 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Support staging/production scenario as in Windows Azure

                  This could be done with the future cloning technique or perhaps a more sophisticated one?

                  135 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 →
                  • Offer postgresql as a PaaS/DaaS service, not via a third party

                    First and foremost: I understand that anyone can spin up a VM and just put postgres (or anything else) on it. This suggestion is not satisfiable by that advice.

                    What I and countless others would like to see is postgres offered as a 1st class (by Microsoft) database as a service solution.

                    Right now the only DB could I confidently use on Azure is SQL Server. The third party integration of MySQL by ClearDB leaves a lot to be desired and indeed - it would be better if Microsoft in-housed an option for all the as-a-service DBs, just like RDS.

                    99 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 →
                    • transparency of database outages

                      support is difficult to get and to understand. My databases randomly become unavailable at times with no explanation as to the cause. Just not available and then magically its back up and running.

                      Why ???

                      90 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…)
                        13 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Allow using Query Notifications with Azure SQL Databases

                        Please allow using Query Notifications with Azure SQL Databases.
                        In combination with OutputCache having SqlDependency set the Query Notifications mechanism should reduce web sites load and increase pages response time.

                        52 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 →
                        • SQL Server for Mac

                          I need to work on SQL Server express locally because we are using SQL Azure as our prod environment. The problem is, I am working on my Mac. Is there a way to work around this without using a VM? Can you please make a version of SQL Server to run on Mac OS X?

                          49 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 →
                          • Allowed IP addresses 24 hour rule

                            Allowed IP Addresses must be configured in order to connect remotely to Azure Databases (and other services).

                            While working remotely, instead of having to create a permanent "allowed ip address", allow us to create an allowed ip address for a specific amount of time.

                            47 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 →
                            • CDC

                              Please support Change Data Capture in SQL Azure. This is big for small-medium size data warehouse / data mart applications, as well as for mobile applications that do updates based on changed data. Also, CDC is perfect for people who want to implement database table update auditing without writing a bunch of boilerplate database table auditing code themselves.

                              45 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 →
                              • Enable GZip/Deflate Compression of SQL Azure OData Response

                                OData's AtomPub protocol is very verbose. My calculations indicate that AtomPub multiplies Data Transfer Out bytes by a factor of 8.75. (See Querying OData.org’s SQL Azure Northwind Sample Data Service: http://oakleafblog.blogspot.com/2010/03/odataorgs-sql-azure-northwind-sample.html).

                                Despite the Accept-Encoding: gzip, deflate header, SQL Azure OData responses aren''t compressed. I agree with this comment by Scott Hanselman - failure to compress OData responses is LAME.

                                41 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 →
                                • intellisense

                                  Please enable intellisense on Azure SQL databases. We have had it since SQL server 2008 and seems crazy that it is not available on Azure.

                                  37 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 →
                                  • Support the dbmail.

                                    The feature dbmail in SQL 2005 makes email sending much easier, should keep it in SQL Azure.

                                    35 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 →
                                    • View & Edit SQL Server database data

                                      In the old portal it was possible to view and edit the data of an SQL Server database.
                                      This feature was very compelling to me, and I'd like to see the implementation of it, or at least a temporary reference to it meanwhile.
                                      Otherwise I have to go back and use the old portal.

                                      34 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 →

                                        Thanks for the feedback. We’re working on a lot of great stuff and will continue to expand the functionality in the preview portal to match the full portal over time. You’ll see things like this become available over time.

                                      • 32 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 →
                                        • Alphanumeric ORDER BY

                                          Please add support of alpha numeric ORDER BY of text values. A good sample you will find here: http://www.davekoelle.com/alphanum.html
                                          Without this feature is impossible to made a paging (skip, take) of for example file names.

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

                                          SQL Database

                                          Feedback and Knowledge Base