SQL Database

  1. Transient login failures due to load balancing and updates, or unplanned occurrences

    We are experiencing the issue with Transient login failures due to load balancing and updates, or unplanned occurrences. It's not acceptable for our business.

    Is there any way to fix these problems as its impacting to our business transactions.

    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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  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. 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 →
  17. 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 →
  18. Schedule time for Azure SQL Data Sync

    Currently you can set the frequency for synchronization but you cannot set the time.

    https://github.com/MicrosoftDocs/azure-docs/issues/40261

    The specific usecase I have is to synchronize data between a staging environment and a production environment every day at midnight. This way content administrators can set up data and see how it looks in production in the staging environment without impacting production and any data changes they would like to keep will get synced to production daily.

    Bonus points if we can just move to a cron schedule like Azure Functions. It would support so many scenarios for scheduling.

    19 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 →
  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