SQL Database

  1. Provide TAGs using Restore-AzSqlDatabase from LTR backup

    We need to setup the tags value at the same time we restore a database from a LTR backup because we have a policy that force to have a tag (DIC=value).

    It's possible to setup tags value with point in time restore via (az sql db restore) but it not possible to do that when we restore from a LTR backup.

    56 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 →
  2. Gen5 effectively doubles the costs for some customers

    With the phasing out of Gen4, Microsoft is effectively forcing a 2x+ price increase on some SQL Azure customers.

    We heavily use EDPs with Gen4 vCore based pricing. Our typical config is 1.5TB pools with 3 Gen4 vCores at a cost of around $750/month. Our CPU usage is minimal, but our pools are fairly large in terms of storage requirements.

    The same 1.5TB storage allocation for a Gen5 pool requires 6 vCores and costs nearly $1400/month. As our pools have <10% CPU at any given time, this is effectively doubling our costs with no benefit.

    It's even worse when you…

    84 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 →
  3. Advance Notification of Azure SQL maintenance

    Customers can receive advance notification for Scheduled Maintenance to Azure SQL Database.
    Currently the notification is sent when update for Azure SQL is applied.
    But the notification is NOT sent when reconfiguration is performed manually due to any maintenance purpose.

    During reconfiguration happens, many batch jobs cannot connect to database and end abnormally.
    Those batch jobs are very important for their business.
    The customer request to send notification before all maintenance which cause reconfiguration.

    29 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. Enable to control the timing of LTR backup

    Our customers would like to configure the timing of LTR backups or manually create a LTR backup to restore the several databases from the exact same time.

    41 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 →
  5. Add SQL memory utilization monitoring for elastic pool databses.

    Add SQL memory utilization monitoring for elastic pool databses.

    we would like to, know the Resource memory utilization of a databases in the eslastic pool.

    31 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 →
  6. Enable creation of MDS databases and Stretch databases in Azure SQL Database serverless

    It is a very common business scenario the data present in tables in
    Stretch databases is uploaded and accessed periodically,
    thus making it a great candidate to be hosted in Azure SQL Database serverless. That way the current model costs, with min 100 DSU, can be avoided.

    Following the same idea as the general Azure SQL Database serverless, the MDS databases are rarely accessed out of the businesses working hours. So having them in Azure SQL first, and even better as Serverless, since predictable pattern of absence of processing power is applicable, will be beneficial.

    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 →
  7. Disable Point-In-Time-Retention (PITR)

    Allow the user the ability to completely disable PITR for database/pools. This would allow users to prevent having additional storage costs for database that don't have a PITR need (i.e. QA database)

    24 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 →
  8. Allow storage account with vnet and behind firewall to be used for SQL's advanced threat protection.

    As described in Microsoft documentation https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing#subheading-1 a storage account behind firewall and a storage account with vnet is currently not supported for SQL's advanced threat protection.
    This possess a high security risk where the logs will visible to anyone with access to the subscription, sas uri or storage account key.
    We expect this to be fixed and enhanced so that a storage account with vnet and behind firewall can be used for SQL's advanced threat protection.

    35 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 →
  9. Provide greater transparency over patch status of known applicable CVE's

    As a Independent Software Vendor (ISV) that uses Azure SQL DB to run our Software as a Service offering to our customers we get challenges from those customers to verify that the service they are using is mitigated against published CVE's. Where those CVE's are applicable to things like SQL Server or Windows OS we do not have any transparency to assert if the Azure SQL DB service is patched. We have to open a support ticket for each incident. Would love to see some transparency over patched applicable CVEs

    9 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 →
  10. 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.

    51 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. Azure SQL Database serverless manually pause and resume

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

    55 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Database Service Objective changer - "Unknown"

    When we perform Database Service Objective change through TSQL (Sql Server Management Studio) , it's details of operation like, caller, IP address and event initiated by are not logged in the Azure portal.

    Sample TSQL Command:
    ALTER DATABASE [DBNAME]

    MODIFY ( EDITION = 'Premium', SERVICE_OBJECTIVE = 'P6')

    5 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 →
  13. Build SSDT Data Project for Azure SQL Database Fails on CREATE MASTER KEY

    When adding a master encryption key for an Azure SQL Database project that will use external datasources, Visual Studio 2019 has a parsing error on the CREATE MASTER KEY ENCRYPTION statement. (SQL70015: Statement 'CREATE MASTER KEY' is not supported for the targeted platform). This statement is perfectly valid for Azure SQL Databases and is actually required to use credentials that have a stored secret.

    10 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 →
  14. Add support for encryption with 4096-bit keys stored in Azure Key Vault

    Currently the ENCRYPTBYASYMKEY() function only support an RSA key up to 2048-bits, which is currently not the highest available (https://docs.microsoft.com/en-us/sql/t-sql/functions/encryptbyasymkey-transact-sql?view=sql-server-ver15)

    And also storing a key/certificate inside the database isn't state of the art in 2020.

    So it would be nice if we could see an integration with Azure Key Vault (to store our keys/certificates centrally) for Azure SQL databases. And then indirectly also support 4096-bit keys to encrypt content inside the database.

    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 →
  15. Hyperscale: support for Transparent Data Encryption using Key Vault (BYOK)

    It would be great to have support for Transparent Data Encryption (TDE) using a Key Vault generated key, commonly referred as Bring Your Own Key or BYOK).

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

    202 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. You could show the Alert message on portal during changing the default configuration

    You could show the Alert message on portal during changing the default configuration instead of only sending the email.

    Customer may miss the notification email for upcoming update, it would be better to pop up the alert message while creating Azure service or overview page of service.

    For example, the backup retention of database was changed from 35 days to 7 days from 1 July, 2019. There is no option to change backup retention day while creating the Azure SQL/SQL Database.

    It would be helpful if you show the notification in Azure SQL Database overview or creating configuration.

    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 →
  18. Allow SPN's to create AAD Users

    As we follow best practices and fully automate Azure using SPN's while leveraging AAD for users, we wish to create AAD users in SQL DB using our SPN's.

    When attempting to create AAD users in a database using an SPN, we received this error:
    "Principal 'xxxxxx' could not be created. Only connections established with Active Directory accounts can create other Active Directory users."

    We were told by support that "At this time, the statement CREATE USER [] FROM EXTERNAL PROVIDER; is not supported for SPN."

    Request we make this possible...

    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 →
  19. Give an option to create bacpac file for azure SQL Data-warehouse

    We have an azure data warehouse database and we want to take a back up of the objects in it (stored proc, tables and other scripts). It seems like there is an option to create bacpac files using the export option in azure database but not available for Azure SQL Datawarehouse. Is it correct?

    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 →
  20. TempDB Log Used Percent Usage

    Current metric on azure portal reflects the current log file usage, even though the file is set to autogrow. Hence the percentage would be better used with comparison to the total file size of temp log.

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

SQL Database

Categories

Feedback and Knowledge Base