SQL Database

  1. Ability to view backup storage usage via Portal, Powershell, or DMV

    As there is currently a $0.10/GB charge for PiTR storage over the size of the database size it will be important to have a way to view backup storage usage so you can best plan how long to have your retention set to best optimize your billing.

    If possible this could be a property in Get-AzSqlDatabase and Get-AzSqlElasticPool.

    39 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  2. Support AzureRm powershell sending database/server audit logs to write to Log Analytics

    Azure Automation account still dont fully support Az modules. It is very hard to setup a new Automation account with Az only.

    I have a lot of Runbooks written using AzureRm and would like the RM to be updated to include the log analytics workspace instead of only storage.

    AZ command: (supports Log Analytics)
    =========================
    Set-AzSqlServerAuditing
    Set-AzSqlDatabaseAuditing

    AzureRm Command: (does not support Log Analytics)
    ===================================

    Set-AzureRmSqlServerAuditing
    Set-AzureRmSqlDatabaseAuditing

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

    46 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  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…

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

    21 votes
    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. 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: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. 15 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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.

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

    86 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 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.

    213 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  14. Azure SQL Database serverless manually pause and resume

    It would useful to have the possibility to manually pause and resume a serverless sql database

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Round-robin read replicas and provide performance metrics of replicas in portal

    There is more than one read-replica and it would be a huge performance benefit to be able to round-robin the connection to them. Would also be great to get visibility into the replicas via the Azure portal.

    22 votes
    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. 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.

    9 votes
    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. Azure SQL Managed Instance DNS alias

    Just like DNS alias is supported for Azure SQL database https://docs.microsoft.com/en-us/azure/sql-database/dns-alias-overview,
    we need same functionality supported for Azure SQL managed instance, abstraction layer to redirect traffic during upgrades, massive data maintenance etc.

    2 votes
    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. 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: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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.

    9 votes
    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. 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: Microsoft
    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.

← Previous 1 3 4 5 31 32
  • Don't see your idea?

SQL Database

Feedback and Knowledge Base