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 a Terminalserverwith access to a SQL-Server

    Need a Terminalserverwith access to a SQL-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 →
  2. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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 →
  9. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Azure Portal Query Editor incorrectly parses GO batch terminators in literals

    The query editor interprets "GO" embedded in string literals as a batch terminator and executes the preceding text, resulting in a syntax error:

    SELECT 'repro
    GO';
    GO

    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 →
  16. Add Adobe filters with Azure SQL DB instances

    So far only MS filters are supported in SQL DB instance. It would be nice to include Adobe filters also.

    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 →
  17. Migrate long term back ups from one Azure SQL Server to Another Azure SQL Server

    It would be nice if there was a way to move the back up files from one server to another or just the ability to have access to them.

    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 →
  18. Management tool like phpMyAdmin for all created MySQL databases

    I may be missing it based on my subscription level, but a management tool that you can use in the portal to manage your MySQL databases that you create. It would be just like phpMyAdmin or SQL management studio in the way you can add tables and input data into the tables.

    This would be great for us users that use a laptop with a small hard drive and even a tablet to quickly populate a database and just work on the application we are creating. Just a thought though

    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 →
  19. Long-term recovery config is broken in the portal

    Configuration of long-term recovery is broken in the portal. I understand this feature is in preview (but it's been in preview for 14 months!):

    I've created an RS vault in the same resource group as the SQL Server and DBs.
    The Long Term recovery blade in the portal recognizes this.
    Select a couple DBs and click Configure.
    Enter the policy details and click OK.
    Click Save to apply the new policy. Nothing happens.
    Navigate away from the blade and receive the "Unsaved changes" warning.

    I WAS able to configure long term recovery using Azure PowerShell as shown here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-backup-retention-configure#powershell

    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. Subscription dropdown when creating SQL Database

    In portal preview I accidentally created new sql server in wrong subscription. When I try to recreate in correct subscription it now says server name is already taken.

    In my numerous attempts at trying to recreate, I noticed that if I do create the server prior to selecting the subscription it then wipes out my data entry when I switch my subscription choice, which I kind of expected. Therefore I would place the Subscription dropdown prior to selecting/creating what server you want your database on.

    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