SQL Database

  1. Ability to create consolidated Vulnerability scan report across multiple sql servers/databases

    Allow to create aggregate reports by sql servers and its databases instead of database by database which does not scale

    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. Azure SQL managed instance replication - general availability time frame?

    I understand replication for Azure SQL Managed instance is in preview mode. Wondering, if you have any approximate time frame when it can be used for Production database. Looks like decision makers in my company would feel comfortable once the product is in 'general availability' mode

    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. Authenticate using Azure AD DS

    Just like how Azure Files supports authenticating using Azure AD Credentials from Azure AD DS domain joined machines, it would be great to be able to authenticate to Azure SQL in a similar manner.

    We have some legacy apps running in Azure VMs that users log into, it would be great to be able to authenticate to SQL using their current logged in credentials (similar to how Windows or Azure AD Integrated authentication works)

    Currently we are prompting them for credentials and using the Active Directory Password authentication mode.

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

    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 →
  5. Hyperscale: Bring back copy database

    We really, really need the ability to copy Hyperscale databases just like other Azure SQL tiers!

    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. Support AzureRm powershell sending database/server audit logs to write to Log Analytics

    Azure Automation account still dont fully support Az modules. It is very hard to setup a new Automation account with Az only.

    I have a lot of Runbooks written using AzureRm and would like the RM to be updated to include the log analytics workspace instead of only storage.

    AZ command: (supports Log Analytics)
    =========================
    Set-AzSqlServerAuditing
    Set-AzSqlDatabaseAuditing

    AzureRm Command: (does not support Log Analytics)
    ===================================

    Set-AzureRmSqlServerAuditing
    Set-AzureRmSqlDatabaseAuditing

    9 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 →
  7. Enable XE sqlserver.backup_restore_progress_trace

    This event was introduced in SQL Server 2016 and is also available in Azure SQL Database Managed Instance.
    In order to track (automated) backup times/running time and restore progress this would be very helpful in backup/restore monitoring for Azure SQL 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 →
  8. Recover SQL Server

    There is an option to recover deleted SQL databases. But when by accident you've deleted the server there is no chance to recover the server back up (if you don't configured a backup).
    Of course a warned man counts for two and you definitely need to configure backup. It would be nice if the same option as recover databases was available with recover sql servers.

    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. Implement Azure SQL Server backup

    At present, MS is not offering any backup capabilities for backing up an Azure SQL Server(Logical container) and master database. Please include them in the offering as this will help customers to recover from accidental deletions/catastrophes. MS did mention that it can be restored from product group on best effort basis if its within 7 days however no guarantee was provided.

    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. Azure SQL DB DACPAC task in DEvOps does not support AD authentication with a SErvice Principal

    The only way to deploy to Azure SQL DB using the DACPAC task in Azure Devops is to use SQL Login Authentication. Microsoft Integrated authentication does not work despite the options being available (perhaps because it's connecting to Azure SQL DB and not Managed Instance or Enterprise).

    This means I have to add user security groups manually to my Azure SQL DB rather than in a DevOps task.

    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 →
  11. There needs to be an option to get notified when Azure SQL databases are stuck during a scaling execution.

    We scale down and up the databases to save costs at night when no one is using the databases.

    Until this issue is completely resolved, I would like to be able to configure an e-mail notification when the database is stuck. This will allow us to be pro-active in contacting Azure support to expedite remediation.

    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. Add General Purpose service tier supported region

    We were trying to deploy Gen4 resources in different regions. But some deployments fail due to some regions not supporting Gen4. In the Documentation, we found that Australi region is not supporting. But we found that "UAE North", "UK South", "UK West", "South Africa North" and "France Central" also not supporting Gen4 resources. Is it poosible to add this to documentation.? It might help developers to time. :)

    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 →
  13. [INFORMATION_SCHEMA].[COLUMNS] does not respect DENY column-level permissions

    When a column-level permission is denied to a user, the column is still visible to the user in INFORMATION_SCHEMA.COLUMNS, and it causes issues when external apps (such as ORM or SSIS) try to access the table.

    Per the documentation at "https://docs.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/columns-transact-sql?view=sql-server-2017":

    "Returns one row for each column that can be accessed by the current user in the current database"

    USE [master];
    GO
    BEGIN TRY
    DROP LOGIN [test_user];
    END TRY
    BEGIN CATCH
    END CATCH

    CREATE LOGIN [test_user] WITH PASSWORD=N'password', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;
    GO
    BEGIN TRY
    DROP DATABASE [security_test];
    END TRY
    BEGIN CATCH
    END CATCH

    CREATE DATABASE [security_test];
    GO …

    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 →
  14. Choose size of restored database files

    When you restore a database, it creates each files with their original size.
    But sometime you need to extend the file or shrink the files according to the disk space and free space in the original files.
    It would be great to implement a "target size" for each restored file during restoring the database.

    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. [Bug] Unable to add firewall rule failed with irrelevant chinese error message in China Azure Cloud.

    无法重写服务器 gbsintern 的防火墙规则和刷新刀片式服务器。
    错误代码: undefined
    错误消息: An unexpected error occured while processing the request. Tracking ID: 'eb8923ca-62bc-4837-9e34-501eb4c1b654'

    But I got error message below with azure cli.

    Operation failed with status: 'Conflict'. Details: Windows Azure SQL Database supports a maximum of 128 firewall rules.

    If i delete one old rule , i can add new rule.

    4 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 →
  16. Provide the same reports that are available for on-premises SQL Server instances

    In SSMS, when right-clicking a standalone SQL Server database and going to Reports > Standard Reports, there are a large number of predefined reports available.

    However, doing the same on a SQL Azure database yields only two reports.

    It would be extremely useful if some, or preferably all, of the reports available on standalone SQL server instances were also available in SQL Azure. This would also mean questions like https://stackoverflow.com/questions/14685596/queries-to-generate-a-disk-usage-by-top-tables-report-in-sql-azure/14710177 would no longer be necessary.

    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 →
  17. elastic job

    Please make public the road map for Elastic Jobs.

    We are currently using the PowerShell Module Az.Sql 1.1.1-preview and we'd like to know when it is expected to become official.

    Also, there is no GUI in Azure to run/schedule jobs, and we'd like to know if there are any plans to improve the GUI experience for Elastic Jobs

    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. provide query plan in Query performance insights pane in azure portal

    In SQL databases, Query performance insights gives a good view of resource consuming queries. It will be great for developers and operations to have a query plan view for such queries, similar to the one offered in SQL Management Studio.

    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. Generate connection string for Geo-Replica immediately

    In case of DB disaster recovery timing is quite important and DB restoration takes significant time and for us means these steps:
    1) Create new DB from backup (wait for complete)
    2) Enable read-only Geo Replication to 2 regions (wait for complete)
    3) Take connection string from 2 and change devops configs and schedule config build (wait for complete)
    4) Deploy services using config with new connection strings

    So step 3 could be done in parallel to waiting for step 2 if we knew connection string ahead of time and save much valuable time in case of disaster

    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. A feature request from customer: SQL DB should calculate each schema's size for customer automatically

    A feature request from customer: SQL DB should calculate each schema's size for customer automatically rather than let customer use DMV to calculate which is very time and resource consuming.

    Current query:
    SELECT SUM(reserved_page_count)*8*1024 FROM sys.dm_db_partition_stats, sys.objects WHERE sys.dm_db_partition_stats.object_id = sys.objects.object_id and sys.objects.schema_id={0}

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

SQL Database

Feedback and Knowledge Base