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. Implement FILESTREAM for blobs into Azure Blob Store

    Storing blobs in the database is fairly pointless when you have a dedicated blob store. Implement the FILESTREAM protocol to store blobs in a user's azure storage

    866 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    17 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. PolyBase: Support for Azure SQL Database

    Azure SQL Database does not currently support Polybase, though it is supported in the on-premise version.

    727 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    28 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add Master Data Services (MDS) to Azure hosted MS SQL.

    Add Master Data Services (MDS) to Azure hosted MS SQL.

    640 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    33 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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.

    426 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    26 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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.

    423 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    34 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. R for Azure SQL DB

    It would be great if SQL Server R Services feature of SQL Server 2016 comes to Azure SQL DB as well. I see a great potential for this integration and would enable advanced analytics scenarios on PaaS seamlessly

    361 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    11 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Traffic Manager for SQL Database

    The traffic manager is a great way to account for failover between web nodes in different data centers. However, an analogous paradigm doesn't exist for databases. In the premium tier, you can enable active geo-replication. However, all applications dependent on the primary either need to have their connection strings changed over when failing over between data centers, or they have to have some sophisticated retry logic built in at the application tier. It would be great if applications could point to a single, consistent endpoint and the geo-failover could be handled at a higher level the way it is with…

    298 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. allow database to reside in different resource group to server

    Currently, SQL server databases must be created in the same resource group as the server. It would be great to allow databases to be created in different resource groups. This would allow full environments to be created and destroyed while leveraging elastic pools.

    270 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    unplanned  ·  8 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow the USE statement to switch between databases on the same Azure SQL Server

    We use different databases on the same SQL Server as part of a solution and the limitation of not being able to run USE <database> limits us to Azure SQL VMs only instead of using Azure SQL Server.

    Per Azure Documentation:

    USE statement: To change the database context to a different database you must make a new connection to the new database.

    Seems that there should be a way to overcome this limitation. Help us, Microsoft, you are only hope!

    266 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    11 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Bring SQL Databases (MS SQL Database as a Service) to Azure Stack

    When is comes to app development on PaaS platforms, Databases and DBaaS are "core" & "can't-live-without".

    I see them already included in first release ;)

    243 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    unplanned  ·  9 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Support staging/production scenario as in Windows Azure

    This could be done with the future cloning technique or perhaps a more sophisticated one?

    193 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Enable SQL Profiler for SQL Azure

    While the query performance analyzer in the Azure portal is great, it does not allow for the real-time capturing of queries. Instead, it takes a sample and only shows the most "expensive" queries.

    It can be very difficult to figure out problem queries without SQL Profiler working in SQL Azure. Adding support for this would be a huge win.

    178 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Allow using Query Notifications with Azure SQL Databases

    Please allow using Query Notifications with Azure SQL Databases.
    In combination with OutputCache having SqlDependency set the Query Notifications mechanism should reduce web sites load and increase pages response time.

    178 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Track SQL DB restore progress

    Tracking in detail the restore of a SQL DB is mandatory in order to provide a transparent customer support. At this moment, one can only see if a restore is running (1%) or finished, but the restore progress in percentages cannot be seen. The only reply I can give at this moment to my customers about when the database restore will be finished, is somewhere within 24h.

    173 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Grant access to Azure DB via host name (reverse DNS) instead of IP address

    Clients behind dynamic IP addresses are unable to make use of Azure DB for desktop and server application because I cannot know the IP address that their workstations might be calling from.
    I can use DynDNS to maintain their external host name but good luck to anyone who wants to use DB sync or to direct access the Azure DB databases in this type of environment.

    Static IP is not available to many of our clients as they are in remote locations that only have 3G/4G coverage

    151 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Support for DML operations with external tables in Azure

    I've seen it around in a few places that this might be something that's in the works. Is that certain, and is there an ETA on its release? The elastic database queries are a huge improvement, but our application would benefit greatly from write access as well.

    146 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    11 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Allow SQL databases to be shutdown

    Now that we can shutdown SQL Data Warehouses I'd like to be able to shutdown a SQL database. Even if there are multiple SQL databases on a server, I'd like to shutdown the databases individually since that's what I'm charged for. Just like with VMs I would expect to only be charged for the storage when the database is shutdown.
    As a bonus, shutting down the entire SQL Server would be great too, but I really only care about shutting down a database.

    130 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Auto Scaling for Azure SQL

    Ability to create rules which enable automatically scaling up or down the DTUs on an Azure SQL Database based on usage.

    129 votes
    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. Implement python bindings for azure-sqldb-spark connector

    The azure-sqldb-spark Spark connector (https://github.com/Azure/azure-sqldb-spark) provides support for Spark on Scala, but does not currently provide Python bindings.

    Python-based Spark applications can still connect to MSSQL/Azure SQL databases using a JDBC connection, but this approach does not support bulk-inserts and is therefore quite slow for persisting large Spark dataframes to MSSQL.

    It would be useful if PySpark applications could take advantage of the bulk insert capabilities provided by the azure-sqldb-spark scala package. From the git repo readme: "Comparing to the built-in Spark connector, this connector provides the ability to bulk insert data into SQL databases. It can outperform…

    104 votes
    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. Allow DNS alias masking for SQL Azure Database Server

    We would like to be able to take an azure sql server's instance name (server01.database.windows.net) and add an alias entry to our internal DNS for resolution which aligns to our existing set of onpremise standards.

    98 votes
    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 →
← Previous 1 3 4 5 29 30
  • Don't see your idea?

SQL Database

Feedback and Knowledge Base