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. Change Data Capture

    Allow Change Data Capture in SQL Azure

    It has been available in SQL server since 2008, the jump to SQL Azure seems logical.

    332 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      21 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Automatic Fail-over to secondary region similar to Global DocumentDB

      Recently, Microsoft introduced a feature "Global DocumentDB database" along with "multi-homing APIs" which provides transparent & automatic fail-over to secondary database with no human intervention.

      It will be helpful to have a similar feature for Azure SQL Database where users can enable Geo-Replication and will not have to worry about manual fail-over to secondary in case when Primary / master is unavailable

      77 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        planned  ·  3 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

        24 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 →
        • Azure database export fails when split_string is involved

          Database compatabilty level 130.

          Repro steps:

          alter function dbo.tt
          (@id varchar(max))
          returns table
          return
          select
          * from
          dbo.string_split(@id,',') t
          inner join
          dbo.numbers n
          on n.id=t.value

          Export dacpac fails stating unresolved reference split_string,while the function itself works

          19 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
          • 17 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 →
            • REST service for the enumeration of SQL Azure databases on a SQL Azure server.

              Currently it is not possible to enumerate the databases inside a SQL Azure server, please add a REST service to query databases inside each server.

              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…)
                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
              • Add allowed IP - adresses functionallity

                I am missing the management off allowed IP adresses. Please add this in the new portal!

                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 →
                • Missing Firewall option in new portal

                  I read in some documentation that I can set firewall options in the new portal. However, I can't find it anywhere in the new portal.
                  I had to switch to the old portal to allow my IP addrress access.

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

                    I do see that the documentation here needs fixing (will submit this request to the content team):

                    https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/

                    In the meantime, you can do the following:
                    If you’re not currently connected, connect to the Azure portal.
                    On the default blade, click SQL servers.
                    On the SQL servers blade, click the server on which to create the firewall rule.
                    You’ll see a blade with a Settings section and “Firewall” as an option.

                    Thanks for submitting this feedback.

                    Best Regards,

                    Joe Sack
                    Principal PM, SQL Server and Azure SQL DB

                  • Need to be able to see % complete of a COPY

                    We had a COPY take an unusually long time during a go-live ( of course ). It was frustrating that we had no way to tell how the copy was proceeding. The view sys.dm_operation_status is only good for seeing that there is a copy in progress, but it does not provide any other useful information.

                    Therefore, we need this view to be more useful AND/OR be able to see 'in progress COPY info' in the portal. The activity log is useless for this - it only shows the start.

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

                    SQL Database

                    Feedback and Knowledge Base