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

    Please improve the time zone of Azure SQL Database so that users can change it.

    When migrating to Azure SQL Database, it takes a lot of time to change all the programs of the application.

    59 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 →
  2. Include improved & regressed query plan links in sys.dm_db_tuning_recommendations

    When you enable Automatic Index Tuning, and Azure adds indexes, the portal's validation screen shows a count of the number of improved and regressed queries. However, there's no easy way to tell which queries they were.

    To facilitate that, how about in the "details" JSON column of sys.dm_db_tuning_recommendations, you add something to help us join to Query Store or the plan cache to see which queries they were?

    45 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 →
  3. Azure SQL Database copy operations shouldn't require write access to the source database

    When performing a database copy operation between two different servers it appears that write access is required to both the destination server and the source database.

    See the following error from the Az CLI:

    $ az sql db copy \
    --resource-group source --server source --name source \
    --dest-resource-group dest --dest-server dest --elastic-pool dest --dest-name dest
    ERROR: The client '<client>' with object id '<object id>' has permission to perform action 'Microsoft.Sql/servers/databases/write' on scope '/subscriptions/<subscription>/resourceGroups/dest/providers/Microsoft.Sql/servers/dest/databases/dest'; however, it does not have permission to perform action 'Microsoft.Sql/servers/databases/write' on the linked scope(s) '/subscriptions/<subscription>/resourceGroups/source/providers/Microsoft.Sql/servers/source/databases/source'.

    This isn't ideal in use cases where you're automating the copy of…

    24 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 →
  4. Bug: DDL Triggers are NOT disabled during Bacpac import

    During the import of a Bacpac DDL triggers are not disabled and therefore are fired on each trigger defined DDL operation as they are carried out during the import process.

    An example of this is a trigger firing on ALTER TABLE actions, where the import process is recorded by the trigger in an audit table. However when the contents of the audit table itself is attempted to be imported a duplicate primary key error is thrown as the import process has already written rows to the table.

    As an example:
    Create a DDL trigger using the attached text file on…

    23 votes
    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. 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…

    125 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 →
  6. About using special symbol such as # in Database name

    Currently, creating with Database name # does not work properly on Azure Portal.
    We will seek urgent measures.
    There are many requests for this content.

    24 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 →
  7. Multiple readable secondaries with Failover Group

    We are currently using Auto-Failover Group feature. We have primary in US west coast and single read-only secondary in east coast. We would like to have additional read capable secondaries in Europe and Asia to improve read performance on our geo-distributed application.

    It will be good if multiple secondaries from different regions are allowed to be added to a failover group. In general, just Geo-replication doesn’t serve our purpose because of all the reasons for why someone would need a failover group:
    - Mission critical data so we want better availability and reliability for writers
    - We don’t want to…

    82 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Restrict the IP address range to a subset rather than the full region when using the redirect policy

    Restrict the IP address range to a subset rather than the full region when using the redirect policy. In the documentation (https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architecture#connection-policy) it states that when using the redirect policy that "clients must allow outbound firewall rules to all Azure IP addresses in the region using Network Security Groups (NSG) with service tags) for ports 11000-11999, not just the Azure SQL Database gateway IP addresses on port 1433". Customer wants to reduce this from all IP address in the region to a smaller subset.

    13 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 →
  9. 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 →
  10. Fix quality of daily cost data visibility

    On various days / weeks there are gaps in cost data for various resources. This tends to self-heal after up to 1 week (incl. history correction). All custom control / alerting which looks on anomalies in cost trends fail due to this; we also loose opportunity to act quickly on unexpected cost raises due to changes, testing activity or unplanned activity on prod - it's critical to see this data at least with daily delay, ideally near real-time.

    Examples of incidents: on Dec 8-9 we stopped getting cost data for any of our SQL DWs, SQL DBs or PostgreSQL DBs…

    16 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 →
  11. Please add details in Activity Logs (Firewall enable)

    There was a situation that we don't able to login to our database. We investigated and found out that the Firewall settings (Allow Access to Azure Services) of that database has been turned-OFF. So we turned it ON. we don't know who turned OFF the switch. So we go to the Activity Logs, and we see who are the people who touch the settings but unable to determine who turned-OFF or ON since there are no word "ON" "OFF" in the activity logs. Can you include this to the Activity Logs? for us to determine who actually turned-OFF or ON…

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

    Thanks for the valid suggestion. Your feedback is now open for the user community to upvote & comment on. This allows us to effectively prioritize your request against our existing feature backlog and also gives us insight into the potential impact of implementing the suggested feature.

  12. Make Standard Reports Available for Azure SQL

    It has always been helpful to be able to right click on a database, go to Reports -> Standard Reports and run things like "Index Usage Statistics", etc. I know you can get it all via DMV's, etc. but it's nice to be able to just click a couple times and get a report generated.

    9 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 →
  13. Azure SQL Threat Detection Filters IP from Azure SQL Query Editor

    Today we received an alert as "An unfamiliar principal successfully logged on to server [SERVERNAME]" with some following details:

    Client IP address: 23.96.227.***

    Client IP location: Chicago, United States

    Data center: North Central US

    Client application: Azure SQL Query Editor

    After working with MS Support Technician, it turns out that Detection Threats doesn't recognize internal IP from a server node assigned by Azure SQL Query Editor.

    This alert created huge pressure and noise in order to identify the origin of this connection.

    It is great if any IP from Azure internal nodes are whitelisted by Threat Detection.

    8 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 →
  14. Allow Recovery Model to be changed to SIMPLE in Azure SQL Database

    According to this article (https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/12/28/lesson-learned-50-adding-pk-led-to-transaction-log-full-error/) the recovery model of a Azure SQL Database cannot be altered from the default option FULL. In a very data intensive setup, this blows up the transaction log -> the LOG IO percentage in portal is at 100% all the time. Allowing the SIMPLE recovery model should improved the performance significantly.

    30 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 →
  15. Vulnerability Assessment - allow periodic recurring scans without requiring email address for results

    Currently, enabling Azure SQL Advanced Data Security -> Vulnerability Assessment -> Periodic recurring scans at the server level requires an email address be provided so database scan results can be emailed.

    Would like to see an option for emailing scan results rather than requiring scan results be emailed after each scan, and/or allow the "Send scan reports to" field to be left blank.

    This benefits situations where vulnerability-related information cannot be sent over email.

    8 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 →
  16. Got "Setup Failed" during installation of Microsoft SQL Server Management Studio

    Got "Setup Failed"
    "The certificate was explicitly marked as untrusted by the user (0x800B0111)"
    during installation of Microsoft SQL Server Management Studio

    I have to say, I didn't change any certificates before installation and follow all provided instructions...
    After I got this issue, I tryed to solve this with provided documentation: I didn't find any installed files or folders in Registry to delete.
    Also, I got the same issue while installing older versions of Microsoft SQL Server Management Studio.
    I cannot find any useful information what is the main problem :(

    I have Windows 10 x64 OS. Added log file…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Provide SQL Server Connector functionality for Azure SQL PaaS

    In order for an EKM provider to communicate with an Azure Key Vault the database must be either Azure SQL IaaS or an on-prem instance of SQL Server. When using Azure SQL Paas, however, it would be great to have this level of security available as well as the ability to manage credentials in one area and within a Key Vault.

    21 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 →
  18. Allow ElasticPool SQL Database to join P2S Virtual Network (VPN) - Round 2

    This is round 2 of the idea posted here:

    https://feedback.azure.com/forums/217321-sql-database/suggestions/5537689-allow-sql-database-to-join-virtual-network-vpn?tracking_code=704e9fed32d702f27033e3c1be63d789

    which was closed since SQL databases now have "virtual network" endpoints. However, these endpoints still do not work with P2S VPN connections using Azure VPN Gateway, so I don't know why this idea was closed as completed.

    This means that we either need to create our own workarounds, such as SSH tunnels via VMs inside Azure, or we need to keep using the IP whitelisting method (the latter of which defeats the whole purpose of using a VNET-based access control). In addition, security auditors don't look kindly on databases with…

    97 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. merge replication

    Support merge replication between Azure SQL and e.g. occassionally connected laptop clients with sql server express as the subscriber.

    7 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. Keep Azure SQL Premium RS

    Microsoft should reconsider retiring the Premium RS tier of Azure SQL. It provides a service for companies like ours that want to host their QA/Staging environments in Azure but don't need the full reliability of the Premium tier. None of your other offerings will work for us. We make use of In-Memory tables (OLTP). This option is only available in the Premium/Business Critical tiers. Both of which are too expensive for QA/Staging environments. To retire this option without providing anything of comparable value is a mistake. How can customers feel confident in moving their applications to the cloud if Microsoft…

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

SQL Database

Feedback and Knowledge Base