SQL Database

  1. 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 →
  2. Allow cross queries in Azure SQL Database in a virtual network without requiring "allow access to azure services" enabled.

    Currently, in order to execute cross queries between two SQL databases on the same virtual network, either the public microsoft ip address of the Azure location must be whitelisted on the server firewall, or "allow access to azure services" must be enabled. This design limitation defies the intention of the improved security of placing the Azure Dbs in a virtual network. Suggestion: allow cross queries between databases in a virtual network without externally exposing those databases to anonymous attacks/connections from outside the virtual network.

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

    240 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Maintain PiTR/LTR history after performing a restore

    When a restore is performed for an Azure SQL database, the restored database instance does not carry over the existing PiTR/LTR history. Even if the origination database is deleted, and the restored instance is renamed, the backup history does not carry over to the renamed instance.

    It would be very helpful to either allow an overwrite of the existing database with a PiTR/LTR, or have a way to duplicate the backups from the origination database from geo-replicated blob storage (RA-GRS).

    The following Stack Overflow question may help to understand the issue better:

    https://stackoverflow.com/questions/58097139/restore-azure-sql-db-over-an-existing-db-to-maintain-backup-history

    3 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. Azure SQL final backup before delete

    I see there is a warning and you have to explicitly type 'Yes' to delete the Azure SQL database. However, people still delete the database ignoring the backup retention and pricing tier. It will be very useful if a by-default enabled checkbox that triggers the final backup before the database is being deleted(with no auto retention policy- that means the user will still pay for that backup). Users can choose to unselect the checkbox if the final backup is not required.

    11 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 →
  6. Allow online ALTER of clustered primary key.

    Allow online alter of clustered primary key.

    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 →
  7. Monitoring for database number amount in the pool

    I would like to have the option to setup an alert when the number of databases in the pool reaches a threshold. This is useful to scale up and down the total DTU.

    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 →
  8. No maximum value for MAX_STORAGE_SIZE_MB is documented

    No maximum value for MAXSTORAGESIZEMB is documented.
    In Azure SQL Database, any attempt to set the value of MAX
    STORAGESIZEMB higher than 10240 results in the following error message: "Cannot set Query Store maxstoragesize_mb to nnnnn. The maximum allowed limit is 10240 MB." This limit does not appear to be documented.

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

    27 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. Proide to change Cost Threshold For Perallelism

    We are not able to update cost threshold for parallelism. This setting must be configurable.

    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. Ability to track all the execution without affecting DB performance

    Please provide the execution details for check DB performance

    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 →
  12. 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 →
  13. 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. Better scheduling on Azure SQL Data Sync

    When creating a sync group, allow the user to specify a "first execution" time. Otherwise, if we want a nightly sync at 3am, we need to CREATE the sync process at 3am, rather than just setting it up and leaving it.

    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 →
  15. Audit

    HI Team,

    In the Current SQL Server Auditing , The Resultant LOGS is capturing all the activities related .However , the Log is Very difficult to analyse by any audit team with Minimal Knowledge of SQl Audting.

    Requirement : The Capture Only User Executed Queries on the DB in the Audit Logs

    Issue : Currently all the Logs are Captured under activity_ID 'BCM' and is very difficult to filter out only User Performed activity.

    Feature Request : To Come of with Logs which are more User friendly to read and easy to Understand from the Logs Auditing Stand Point

    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 →
  16. 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 →
  17. Enable Moving Of LTR Copies To New Subscription / Server

    Long term retention copies should be able to be moved to a new subscription. Long term retention copies should be able to be associated with a new database/server. This covers the fact that resources may need to be moved to new subscription. This covers the fac that resources may need to be renamed.

    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 →
  18. Allow tags to be added as part of copy database

    When using Azure Policy to enforce mandatory tags, copy database fails. Please update the UI to allow users to input tags as part of the copy process, or use the tags that the source database has by default.

    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 →
  19. We are looking for Query Store enabling in read only. Please help to enable this feature on secondary node and we can use Query store to che

    We are looking for Query Store enabling in read only. Please help to enable this feature on secondary node and we can use Query store to check the performance easier on the secondary database.

    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. Provide a way to modify or change the SSL certificates

    Provide a way to modify or change the SSL certificates to one of the following:
    • AAA Certificate Services
    • AddTrust Class 1 CA Root
    • AddTrust External CA Root
    • AddTrust Qualified CA Root
    • AffirmTrust Commercial
    • AffirmTrust Networking
    • AffirmTrust Premium
    • AffirmTrust Premium ECC
    • America Online Root Certification Authority 1
    • America Online Root Certification Authority 2
    • Baltimore CyberTrust Code Signing Root
    • Baltimore CyberTrust Root
    • Buypass Class 2 Root CA
    • Buypass Class 3 Root CA
    • Certum CA
    • Certum Trusted Network CA
    • Chambers of Commerce Root
    • Chambers of…

    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