SQL Database

  1. Database Auditing setup

    Database Auditing setup by a specific group. Currently by default are BATCHCOMPLETEDGROUP, SUCCESSFULDATABASEAUTHENTICATIONGROUP AND FAILEDDATABASEAUTHENTICATIONGROUP. I want only the SUCCESSFULDATABASEAUTHENTICATIONGROUP AND FAILEDDATABASEAUTHENTICATIONGROUP.

    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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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.

    4 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. Allow configuring of default connection settings (e.g. XACT_ABORT setting value) at a database level

    With Azure SQL the ability to configure default settings for connections to the server is not possible.

    With SQL Server I would have done this:
    EXEC sys.sp_configure N'user options', N'16384'
    GO
    RECONFIGURE WITH OVERRIDE
    GO

    But that sproc does not exist in Azure SQL. The alternative of "ALTER DATABASE SCOPED CONFIGURATION" does not allow setting of the default that I want - which is to force the default value of XACT_ABORT to ON for all connections to my Azure SQL database.

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

    7 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 →
  12. Add SLA for import/export

    We've had some very small (<1GB) databases stuck in being imported for up to 24 hours. In some cases 50GB databases import in 2 hours.

    4 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. 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 →
  14. 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 →
  15. Currently there is no Alerting for Managed Databases, Allow DBA to create Alerts

    Enable Alert system for Database Alerting
    to get notifications on 1105,9002, table integrity errors

    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 →
  16. Support backup retention configuration through Azure CLI

    Seems like it is not possible to configure the long term retention periods for SQL backups for single databases. There is functionality to do that for managed instances but it doesn't work for single databases. Or I am missing something...?

    8 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 →
  17. Improve the documentation for adding additional on-premises dbs.

    Had an azure sql db replicating with on-premises db for two years. Simply wanted to add other on-premises dbs to replicate with existing Azure hub. Clear documentation on creation of the new db schema, with data or not, and how to avoid messing up the existing sync process!

    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. Enable operators, alerting and database mail for elastic database jobs

    Elastic db jobs currently do not support operators, alerts or database mail integration. This is an important feature for all scheduled job functionality

    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. Official Support for SAP ASA

    Migration from Sybase ASA databases would be much easier if SSMA supported Sybase ASA as a source.

    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. Multiple Full Text Search Indices

    Azure SQL Database only supports one full text search index. It would be great if Azure SQL Database could support multiple full text search indices.

    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