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. Need the ability to set a time zone per Azure sql database

    We need to be able to set the timezone for an Azure sql or DW database. This should be a database option.

    Now we are faced with changing all of our code which references getdate() and similar date functions.

    We shouldn't have this extra difficulty in moving to a cloud database.

    544 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    29 comments  ·  Flag idea as inappropriate…  ·  Admin →

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

    448 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    34 comments  ·  Flag idea as inappropriate…  ·  Admin →

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

    81 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    planned  ·  3 comments  ·  Flag idea as inappropriate…  ·  Admin →

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

    37 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →

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

    25 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

  6. Need ability to check table fragmentation in sql azure

    21 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →

  7. 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
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →

  8. 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
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

  9. 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
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    planned  ·  AdminSQL Database feature voting forum admins (Product Owner, Microsoft Azure) responded

    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

  10. 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.dmoperationstatus 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
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Database

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice