SQL Database

  1. 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 →
  2. 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 →
  3. 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…

    22 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 →
  4. 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 →
  5. 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 →
  6. 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.

  7. Enable serverless feature via ARM template

    Currently serverless feature not supported by ARM template. Manually changing to serverless from the portal results in an sku name of GP_S_Gen5_1 (choosing the most basic). If I update my fully-working ARM template with this SKU name (instead of S0) for example, I get an error on deployment reporting:

    "error": {
    "code": "InvalidSkuName",
    "message": "Invalid SKU name 'GP_S_Gen5_1'."
    }

    However this is already the value of the sku name on resource JSON export as a result of the change via Portal.

    NOTE: There were other detected changes to the JSON export (from Portal changes), which I also ensured were updated…

    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 →
  8. [Bug] Unable to add firewall rule failed with irrelevant chinese error message in China Azure Cloud.

    无法重写服务器 gbsintern 的防火墙规则和刷新刀片式服务器。
    错误代码: undefined
    错误消息: An unexpected error occured while processing the request. Tracking ID: 'eb8923ca-62bc-4837-9e34-501eb4c1b654'

    But I got error message below with azure cli.

    Operation failed with status: 'Conflict'. Details: Windows Azure SQL Database supports a maximum of 128 firewall rules.

    If i delete one old rule , i can add new rule.

    4 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 →
  9. The operation has been cancelled by user

    subnet we are able to destroy without removing all references which can cause multiple issues. like if we have added firewall rule in sql server which can cause issues like new subnet we can't add in firewall rule.

    3 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 →
  10. Enable elastics jobs to use managed service identity

    SQL Server now supports MSI and yet Elastic Jobs still relies on SQL user credentials. It would be much better to be able to give a job an AD identity that can be managed and can be given rights on certain servers and databases.

    3 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 →
  11. HIPAA Compliance for Azure Database Migration Service

    Azure Database Migration Service is not HIPAA compliant. How can we move terabytes of PHI data to Azure SQL DB?

    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 →
  12. Sync schema changes

    It would be very helpful if Sync Groups would also sync schema changes. If a new column is added to one of the tables it would be helpful to sync to the other tables automatically.

    Because Sync Group does not do that, I had to write my own program to sync some databases together.

    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. Need to have provison to run Python or R script s AZURE SQL Server which is in on-prem but not available in AZURE cloud

    Need to have provison to run Python or R script s AZURE SQL Server which is in on-prem but not available in AZURE cloud

    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 have provison to run Python or R script s AZURE SQL Server which is in on-prem but not available in AZURE cloud

    Need to have provison to run Python or R script s AZURE SQL Server which is in on-prem but not available in AZURE cloud

    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. A feature request from customer: SQL DB should calculate each schema's size for customer automatically

    A feature request from customer: SQL DB should calculate each schema's size for customer automatically rather than let customer use DMV to calculate which is very time and resource consuming.

    Current query:
    SELECT SUM(reserved_page_count)*8*1024 FROM sys.dm_db_partition_stats, sys.objects WHERE sys.dm_db_partition_stats.object_id = sys.objects.object_id and sys.objects.schema_id={0}

    6 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. 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: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Azure Data Sync for Managed Instance

    Hey Guys,
    Can you tell me if you have in plan to enable this service for Azure Managed Instances?

    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. TDE- Encryption Key Rotation

    Service-Managed keys are said to be protected by built0in server certificates, however it does not state the following:

    1, How often the keys are rotated.
    2, How are the keys backed up.
    3, How to access the keys.

    Reference doc missing the info:
    https://docs.microsoft.com/en-us/azure/sql-database/transparent-data-encryption-azure-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 →
  19. Resource health maintenance

    Show in Resource Health the "Azure Scaling and Maintenance Tasks" from the Azure Backend,
    Currently is showed: Database is "Unavailable" with not helping reasons and suggestions.

    3 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. query optimizer assumes uniform distribution

    The query optimizer makes 4 assumptions about the data in tables.
    One of them is that the values in statistics are uniformly distributed in the table.
    For example, we have a table with 1,000,000 rows and
    in one column half are '0' and '1'.
    The column statistics show this.
    All the '1' values are at the front of the table and all the '0' at the back.
    For a query like "select .. where flag = '0'",
    the query optimizer picks a "cluster index scan" execution plan
    because the uniformity assumptions makes in think the values are
    0 1 0…

    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

Categories

Feedback and Knowledge Base