SQL Database

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

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

    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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. Elastic job: Add cron style scheduling

    It would be good to be able to schedule elastic jobs to run for example first Saturday of month at 11.00pm.

    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. Error out appropriately when trying to restore a .bak file.

    I wasted 9 hours today (plus a week with a Data Box Disk) trying to restore a .bak through the Azure Portal to a SQL Database.

    Because it's not supported, it should have been able to tell me within the first few minutes

    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. Ability to view backup storage usage via Portal, Powershell, or DMV

    As there is currently a $0.10/GB charge for PiTR storage over the size of the database size it will be important to have a way to view backup storage usage so you can best plan how long to have your retention set to best optimize your billing.

    If possible this could be a property in Get-AzSqlDatabase and Get-AzSqlElasticPool.

    71 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Advance filtering for Azure Database for threat detection

    We often receive alerts for "Someone has logged on to your SQL server '***' from an unusual location.". Most of the time, this was triggered by our DBAs within our office network. As the subscription owner receives too much of these "false-negative" alerts, these alert no longer make sense to them.

    Our office had a dynamic pool of public IPs. If Azure could implement an advance whitelisting feature, this would be a great help.
    For example, if DBA groups access these DBs from an IP range.

    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 →
  16. Enable same region support for VNET Integration

    Currently if you enable VNET Integration for an azure storage account in the same region as Azure SQL Server, Polybase access to the content in the storage account fails. App Services has a VNET Integration feature in preview that allows same region access as an example.

    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 →
  17. Azure SQL Database serverless manually pause and resume

    It would useful to have the possibility to manually pause and resume a serverless sql database

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Azure SQL DB export PS command need to validate presence of .bacpac value in the storage uri parameter

    Azure SQL DB export PS command need to validate presence of .bacpac value in the storage uri parameter.

    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. sp_createstats is failing on SQL Azure

    When running sp_createstats on an Azure SQL Database it fails with the below message. In order to easy reproduce, create a new SQL database and run the sp_createstats:
    print @@version
    go
    sp_createstats

    Microsoft SQL Azure (RTM) - 12.0.2000.8
    May 2 2019 20:11:13
    Copyright (C) 2019 Microsoft Corporation

    Table 'testDan.sys.sqlagent_jobs': Creating statistics for the following columns:
    Msg 1088, Level 16, State 12, Line 3
    Cannot find the object "sys.sqlagent_jobs" because it does not exist or you do not have permissions.

    As per the official documentation, sp_createstats is supported on Azure SQL: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-createstats-transact-sql?view=sql-server-2017

    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. improving of deleting azure sql database that call

    Azure SQL Database that to be set dashboard can select delete menu from it ( I attached image png file). It behaves that way only when Auzre SQL database is selected. Selecting other azure resources can not select delete menu. Other resource only can select "Remove this item from dashboard". As a result, the operator executes "Delete from SQL Database" in the intention of "remove from tile".
     I believe that "delete" menu have to delete from when selected from Azure SQL database in dashboard.

    3 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 →
  • Don't see your idea?

SQL Database

Categories

Feedback and Knowledge Base