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. MySQL/PG/Maria Export/Import Feature

    Add feature to export and import MySQL/PG/MariaDB databases

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. JSON_MODIFY results in unexpected JSON for some nested object scenario

    Azure SQL Database, Compatibility Level 13

    Goal: Change from:

    { "a": { "Q" : "x", "R" : "y" } }

    into

    { "b" : { "q1": "x", "r1": "y" }, "a" : {} }

    using nested/chained JSON_MODIFY calls.

    However, this seems to lead to unexpected/incorrect results depending on the order of the JSON_MODIFY calls when chained:

    Repro:

    DECLARE @Json NVARCHAR(max) = '{"a":{"Q":"x","R":"y"}}'

    -- Results in unexpected/incorrect result: {"a":{"r1":"y"}}
    SELECT JSON_MODIFY(JSON_MODIFY(JSON_MODIFY(JSON_MODIFY(JSON_MODIFY(@Json,
    '$.b', JSON_QUERY('{}')),
    '$.b.q1', 'x'),
    '$.b.r1', 'y'),
    '$.a.Q', NULL),
    '$.a.R', NULL)

    -- Changing the sequence so the "deletes" are first appears to be a workaround:
    -- Deletes first, results correct: {"a":{},"b":{"q1":"x","r1":"y"}} …

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. When transactional replication (subscriber/publisher) feature will be enabled on azure elastic database?

    Need to enable transactional replication on azure elastic database using subscriber and publisher to replicate database from on premise to azure elastic database.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. bacpac

    Restoring BAK instead of BACPAC file by mistake does not error out and takes hours. Suggest to add file format validation logic at the SQL DB import layer.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  5. Dev/Test Pricing for DTU

    https://azure.microsoft.com/en-us/pricing/dev-test/

    This page states Dev/Test pricing for Azure SQL Database.

    However, the pricing calculator does not show price changes for DTU when toggling on Dev/Test pricing.

    https://azure.microsoft.com/en-us/pricing/calculator/?service=sql-database

    Please support dev/test pricing for Azure SQL Database DTU model.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Deleting Azure SQL VNETs

    Deleting Azure SQL DB VNETs via the Azure portal is broken.

    Even as an admin we always get error code 404 The subscription cannot be found (across any subscription). The way to remove them is via "az sql server vnet-rule delete " via Azure command line. Please fix because it is a basic functionality needed via the portal.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  9. Force user to read replica Azure SQL Database where Read Scale-Out has been Enabled and user only has readonly access,

    Is there any way to force a user to read from a read only replica where that user has only been granted readonly access to a database? It seems that we're relying on any external application to be a good citizen and provide the ApplicationIntent in the connection string.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  10. Per server DTU bundles

    Can we get a server with fixed DTUs and be billed on the per server DTU rather than for each individual database? This is useful when migrating from on-premise + when I want to manage the per database DTU by myself or I just don't want to care about the per database DTU.

    Elastic pool based on the server!

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Bigger free SQL DB

    I suggest you to increase free space for sql DB. MongoLab currently gives 500MB for free and this encourages me to choose this database to verify me application. I'd rather choose SQL DB but it's too small for my startup. If my startup succeed it's too late to change database.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Solve the problem in retrieving data from SQL DB

    Hi Azure team,

    We are facing some problems with Azure SQL database.
    Failed to retrieving data from Azure SQL database to Android app

    It showing exception (Exception Screenshot attached)

    Coding we tried through Android Studio 2.3.3 project

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Report database integrity error

    Currently a DB integrity check failure is detected only by MSFT and reported to the owner of the DB.
    Suggestions:
    1. Report immediately the error on the Azure portal.
    2. Allow other Accounts beside the "serveradmin" to execute DBCC CHECKDB thru Elastic jobs/Automation/remote execution
    3. Have SCOM integrated in order to raise an alert when such even occur so owner support team is alerted without delays.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Printing documentation pages from Edge, Firefox, and Chrome is still broke!

    In Edge only the first page is formatted for printing. All the rest of the pages are gone. In Chrome, Edge, and Firefox a bunch of characters on the right are truncated. In order to get them on the printed page one has to use such a tiny font that the pages are really hard to read. Before you made these changes a couple weeks ago, the printed pages in all these browsers were of top quality. Now they are largely unuseable!! This will drive Azure customers away, while before the high quality of your printed pages were a big…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. Fix inaccurate tooltip on ssms tab after Change Connection

    In SSMS 2016, the tooltip or balloon on a given tab is not updated if you right-click and select the "Connection | Change Connection" menu option, moving to a different database server.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  16. Easy Alerting on Database Size

    Our small 1GB SQL Azure database recently reached its size limit which affected our web site and services. I'm astounded that there is no easy way within the Azure Portal or management UX to quickly and easily setup alerting on the size limit -- especially considering the impact that not being able to write to our database has had on our website and services.

    Placing some easy alerting on database size within the Azure Portal or management UX would also provide a great place to upsell other monitoring services for SQL Azure.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  17. Get Best Service through Delta Airlines Customer Service

    Enjoy better travel service & fine food service in Delta Airlines. if you are flying with Delta airlines our customer service executive helps you in any moment where you have any query and issues regarding service provideed by delta airlines. if you getting issues in flight booking , cancel a reservation , old refund status, or any other policies related question and need information about cheap flights contact our Delta Airlines Customer Service Number. they give you detail information regarding your issues which clear your queries and give update knowledge about flights and policies. for more info visit our website …

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. Azure Portal displays weird pricing for SQL Managed Instance which is 10 times cheaper than the Azure Pricing Calculator

    Azure Portal displays weird pricing for SQL Managed Instance which is 10 times cheaper than the Azure Pricing Calculator.

    Pricing is inconsistent and buggy.
    The images shows the inconsistency issue

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Why cant i add two accounts as admins with the setadmin in azure ad without creating a group?

    In Azure AD authentication, we should be able to add more than one user as admin. At present it does not allow to do this without having both users in a windows group and adding the group. This is a limitation.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Support required for AD integrated auth or AD password auth from Linux to Azure SQL .

    Support required for AD integrated auth or AD password auth from Linux to Azure SQL .

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    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