SQL Database

How can we improve Azure SQL Database?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Use T-SQL to query DB/Server Tags

    I would like to be able to query the DB and server tags via T-SQL so that I can use it in queries

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Bug report - Discrepancies typed as 'discrepencies '

    Team,

    Under "Data Security" , while showing vulnerability assessment overview

    VA2061 - Auditing should be enabled at the server level

    Below description has spelling wrong for "Discrepancies "

    "Azure SQL Database Auditing tracks database events and writes them to an audit log in your Azure storage account. Auditing helps you understand database activity and gain insight into discrepencies and anomalies that could indicate business concerns or suspected security violations, as well as helps you meet regulatory compliance.
    For more information see https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing "

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. MySQL/PG/Maria Export/Import Feature

    Add feature to export and import MySQL/PG/MariaDB databases

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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.

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Export SQL Full and Diff backups directly to blob storage

    If I need local access to a DB backup from the recent past (not the current state), for support or dev purposes, presently I first need to restore a new copy of the database, wait for an unknown amount of time, and then export the bacpac to blob storage.

    I'd like to explore and export the existing full and diff backups directly to blob storage for download, or even better, directly download.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Azure Active Directory admin and user-defined database roles

    We've created two seperate Azure AD groups, a group called Admins and a group called Readers.

    The Azure AD group "Admins" is configured as Azure AD Admin on the SQL database making every member of this group a db_owner.

    The second group "Readers" has been created as a contained DB user with the following statements.

    CREATE USER [Readers] FROM EXTERNAL PROVIDER;
    ALTER ROLE db_datareader ADD MEMBER [Readers]
    ALTER ROLE custom_datareader ADD MEMBER [Readers]

    The second role custom_datareader is used for row-level security.
    However we've noticed that the role isn't applied if a member is both in the "Admins" and "Readers"…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. SQL Managed Instance - support the rename of databases when in geo-replication set-up.

    The ability to rename databases in SQL Managed instance. as well as being supported on a single instance, needs to be supported on a databases in an Always On Group. As the Database ID (GUID) could be used to reference the database in the replicated copy; I would have thought this would be a quick win?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Revised response to: Error SQL71564: Error validating element [sql user]: The element [sql user] has been orphaned from its login

    The above error causes a import of a SSMS data tier application (bacpac file) to fail. To generate such an export may have taken a significant amount of time to execute. The resolution to the issue would have been to create the required logins or delete the users and then re-export. A more friendly way of dealing with this would be to prompt during the import process. Provide the option to let the import continue and to not create any orphaned users.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. SSMS Export data-tier application should warn if tables do not have a clustered index

    It would be helpful to know up front (issue a warning earlier in the process) that it is mandatory in Azure for tables to include a clustered index. In fact, this is not true as my initial Azure test database contained a table with no indexes at all. Indexes are not mandatory in SQL Server.

    I am sure this is about trying to prevent bad indexing strategies being imported into the Cloud. As a suggestion could you have a check box on the export process "Target export is for Azure". If this is checked then you can warn users about…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Export data-tier application should warn if tables do not have a clustered index

    It would be helpful to know up front (issue a warning earlier in the process) that it is mandatory in Azure for tables to include a clustered index. In fact, this is not true as my initial Azure test database contained a table with no indexes at all. Indexes are not mandatory in SQL Server.

    I am sure this is about trying to prevent bad indexing strategies being imported into the Cloud. As a suggestion could you have a check box on the export process "Target export is for Azure". If this is checked then you can warn users about…

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Implement Multi DB Export from cmdlets in AZ Powershell

    Implement Multi DB Export from New-AzSqlDatabaseExport cmdlet in AZ Powershell

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. create elastic job agents

    I want to try elastic job agents service. However when config Preview terms, this prevent my accepted to start this service? So, How could I register this service?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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.

    8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Azure SQL Database copy operations shouldn't require write access to the source database

    When performing a database copy operation between two different servers it appears that write access is required to both the destination server and the source database.

    See the following error from the Az CLI:

    $ az sql db copy \
    --resource-group source --server source --name source \
    --dest-resource-group dest --dest-server dest --elastic-pool dest --dest-name dest
    ERROR: The client '<client>' with object id '<object id>' has permission to perform action 'Microsoft.Sql/servers/databases/write' on scope '/subscriptions/<subscription>/resourceGroups/dest/providers/Microsoft.Sql/servers/dest/databases/dest'; however, it does not have permission to perform action 'Microsoft.Sql/servers/databases/write' on the linked scope(s) '/subscriptions/<subscription>/resourceGroups/source/providers/Microsoft.Sql/servers/source/databases/source'.

    This isn't ideal in use cases where you're automating the copy of…

    24 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Support CLR triggers on the Azure SQL DB

    Support CLR triggers on the Azure, SQL PAAS DB, Presently its available on Named instance.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Replicate the logins to secondary replica in failover group in Azure SQL Database.

    We used to have sp_help_revlogins script in onpremises which used to help us in migrating the logins and passwords of SQL server to another instance. Coming to Azure SQL Database, where we have N number of logins we are unable to create the sp_help_revlogins stored procedure in master database in order to fetch the logins data. As it is the logical master and not the actual master. Hence, we do not have the write permissions to it. It would be great it this logins and user migration can enabled which would help us to configure failover groups and migration seamlessly.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Support serverless mode for SQL Database Hyperscale as well

    It's so useful for daily batch job or so. We want to avoid unnessary management task for it.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Support serverless mode for SQL Database Hyperscale as well

    It's so useful for daily batch job or so. We want to avoid unnessary management task for it.

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Notification when a planned failover event occurs.

    Database instances will failover when the backend decides it is needed to better balance the Azure Service Fabric for the platform.

    We would like to have a way to get notified when these events occur.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 29 30
  • Don't see your idea?

SQL Database

Feedback and Knowledge Base