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. 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: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Need a Terminalserverwith access to a SQL-Server

    Need a Terminalserverwith access to a SQL-Server

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Databases with trailing space in the Database name do not appear on the Azure Portal even after support team syncd subscription resources

    We were informed that trailing space in the database name is not supported.

    and resolved it by

    alter database Databasename modify name = [Databasename_]
    alter database [Databasename_] modify name = [Databasename]

    Customer Suggestion:
    Obviously there has to have been multiple users being affected by this spacing issue, and I would recommend a trim function added at the end of the input stream for naming the database either that, or notify the user that the space could cause problems. It might save everyone time in the long run.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. elastic job

    Please make public the road map for Elastic Jobs.

    We are currently using the PowerShell Module Az.Sql 1.1.1-preview and we'd like to know when it is expected to become official.

    Also, there is no GUI in Azure to run/schedule jobs, and we'd like to know if there are any plans to improve the GUI experience for Elastic Jobs

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Enable “per-database charge for elastic pools” in Azure SQL Database (PaaS) Platform.

    Enable “per-database charge for elastic pools” in Azure SQL Database (PaaS) Platform.

    . SQL Database Elastic Pool is a shared resource model that enables higher resource utilization efficiency, with all the databases within an elastic pool sharing predefined resources within the same pool. There is no per-database charge for elastic pools. You are billed for each hour a pool exists at the highest end or vCores, regardless of usage or whether the pool was active for less than an hour

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow me to add my own index to be monitored using index recommendations

    Index recommendations are great, but sometimes I would like to see the impact a specific index would make on my database. The index recommendations area in Azure portal already does this, but only for indexes that it suggests. Would be great it I could just add my own index script in there to be monitored.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. My Database is taking too much time for load As compare another dedicated server Database

    My Database is taking too much time for load As compare another dedicated server Database.

    I have create database in Azure. and i create one database in Dedicated server.
    As compare azure database, dedicated server database performance is too good..
    azure database is taking so much time for load.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Don't ruin SQL Azure database import processes when a new browser client is released

    In the middle of a lengthy (over an hour long) SQL Azure database import process, the Azure web page client, in the middle of my "Importing SQL Database" run, informed me that I needed to close and reopen my browser to get the new browser client. Doing so destroyed my import run, so I had to start over again at the very beginning. Since I had two database imports running simultaneously, the pain was doubled.

    Please fix this problem by allowing users to click past this warning message without having to interrupt any processes currently running. A single OK button…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Need to adjust the server time to a non-UTC timezone

    Being based in the UK, we are having an issue since the daylight time changes occurred recently. We have a delivery/scheduler within our checkout process which is set for UK time and this has caused us a problem. It would be very easy to resolve if we could change the server time within the portal.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add Log Reader functionality to SQL Server like ApexSQL Log

    It is nearly impossible to read db logs. The ApexSQL Log tool does this well. This functionality should be in SQL Server. It would be very useful for MS to purchase this product and incorporate it into SQL Server, or rewrite it as necessary for inclusion.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. sp_adddistpublisher on Azure SQL Managed Instance

    In Azure SQL Managed Instance environment,
    We tried to configure publisher on managed instance via execute following command. After that, we ran exec sp_helpdistpublisher 'azure sql managed instance name' to check and got the empty result.

    USE [master]
    EXEC sp_adddistpublisher @publisher = @@ServerName,
    @distribution_db = N'distribution',
    @security_mode = 0,
    @login = N'<SQL_USER>',
    @password = N'<PASSWORD>',
    @working_directory = N'\\<STORAGE_ACCOUNT>.file.core.windows.net\<SHARE>',
    @storage_connection_string = N'<STORAGE_CONNECTION_STRING>';
    GO

    In contrary, we are able to use SSMS manually configure publisher.
    But we could not input @storage_connection_string parameter in the properties of publisher.

    Could you please check if the sp_adddistpublisher running on azure sql managed instance has problem…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Support for Linear interpolation in geography types

    Support for Linear interpolation in geography types. Aviation data uses both Geodesic and linear interpolation. It would be of enormous use to us to be able to specify a line or part of a polygon to be a parallel.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Have advance notifications prolonged sqlazure reconfigurations

    It would be great to have advance notifications for any sqlazure reconfigurations that may last for more than a couple of minutes.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Reason To Contact American Airlines Customer Service For Travel Queries

    Making your travel easier and hassle-free, the on-the-toes American Airlines Customer Service helps you with ticket booking, easy check-in and reserving the in-flight services. You can inquire about the good deals on ticket reservation and baggage allowance. The customer care agent will guide you with the best of the information to make your travel cheaper and convenient. With the support of American Airlines Customer Service Number 1-844-550-9222, you can find good deals and special discounts on ticket booking
    For More Information Visit Here: https://american.airlinescustomerservice.org/

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. sp_createstats is failing on SQL Azure

    When running sp_createstats on an Azure SQL Database it fails with the below message. In order to easy reproduce, create a new SQL database and run the sp_createstats:
    print @@version
    go
    sp_createstats

    Microsoft SQL Azure (RTM) - 12.0.2000.8
    May 2 2019 20:11:13
    Copyright (C) 2019 Microsoft Corporation

    Table 'testDan.sys.sqlagent_jobs': Creating statistics for the following columns:
    Msg 1088, Level 16, State 12, Line 3
    Cannot find the object "sys.sqlagent_jobs" because it does not exist or you do not have permissions.

    As per the official documentation, sp_createstats is supported on Azure SQL: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-createstats-transact-sql?view=sql-server-2017

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