SQL Database

  1. Provide TAGs using Restore-AzSqlDatabase from LTR backup

    We need to setup the tags value at the same time we restore a database from a LTR backup because we have a policy that force to have a tag (DIC=value).

    It's possible to setup tags value with point in time restore via (az sql db restore) but it not possible to do that when we restore from a LTR backup.

    61 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 →
  2. Create AAD databases users when connected as a Service Principal

    When connected to an AAD enabled Azure SQL database as a Service Principal, additional AAD sourced users cannot be created.

    For example:

    CREATE USER [username] FROM EXTERNAL PROVIDER

    Will give an error of:

    Principal 'username' could not be resolved.
    Error message: 'AADSTS65002: Consent between first party applications and resources must be configured via preauthorization.
    Visit https://identitydocs.azurewebsites.net/static/aad/preauthorization.html for details

    The documentation linked to is private to Microsoft. However public documentation does state this use case isn't supported:

    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure?tabs=azure-powershell#create-contained-database-users-in-your-database-mapped-to-azure-ad-identities
    "In the case that the error says access between first-party applications must be handled via preauthorization, the issue is because the user is…

    29 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 →
  3. Gen5 effectively doubles the costs for some customers

    With the phasing out of Gen4, Microsoft is effectively forcing a 2x+ price increase on some SQL Azure customers.

    We heavily use EDPs with Gen4 vCore based pricing. Our typical config is 1.5TB pools with 3 Gen4 vCores at a cost of around $750/month. Our CPU usage is minimal, but our pools are fairly large in terms of storage requirements.

    The same 1.5TB storage allocation for a Gen5 pool requires 6 vCores and costs nearly $1400/month. As our pools have <10% CPU at any given time, this is effectively doubling our costs with no benefit.

    It's even worse when you…

    91 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 →
  4. Advance Notification of Azure SQL maintenance

    Customers can receive advance notification for Scheduled Maintenance to Azure SQL Database.
    Currently the notification is sent when update for Azure SQL is applied.
    But the notification is NOT sent when reconfiguration is performed manually due to any maintenance purpose.

    During reconfiguration happens, many batch jobs cannot connect to database and end abnormally.
    Those batch jobs are very important for their business.
    The customer request to send notification before all maintenance which cause reconfiguration.

    32 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. Enable to control the timing of LTR backup

    Our customers would like to configure the timing of LTR backups or manually create a LTR backup to restore the several databases from the exact same time.

    42 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. Azure SQL PIM Access

    The idea is to have an on-demand access to Azure SQL and will revert the access after the duration. This will help securing and auditing of the database and db server.
    Refer to https://docs.microsoft.com/en-us/answers/questions/40014/azure-sql-pim-like-access.html

    12 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. Shrink the transaction log file after each differential backup

    Currently the log file is only shrunk after each full backup (7 days). To prevent the transaction log file from growing to an unnecessary size, it should be shrunk after each differential backup (12 hours). This should dramatically reduce the size of the log backups saving on backup storage costs.

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

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

    128 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  8 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add SQL memory utilization monitoring for elastic pool databses.

    Add SQL memory utilization monitoring for elastic pool databses.

    we would like to, know the Resource memory utilization of a databases in the eslastic pool.

    31 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 →
  10. 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 →
  11. SQL Elastic Job Agent

    As a SQL DBA, I would like SQL Elastic Job Agent to send email or webhook alert when a job fails, retries, starts, or finished. Alternatively, I would like diagnostics logging or metrics for failed jobs.

    Integration with Azure Monitor would be preferred.

    Thank you!

    12 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. Disable Point-In-Time-Retention (PITR)

    Allow the user the ability to completely disable PITR for database/pools. This would allow users to prevent having additional storage costs for database that don't have a PITR need (i.e. QA database)

    26 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 →
  13. SQL Server is not capable of sorting Integer JSON Fields

    There exists a column : field_values which contains json data.
    The json fields datatype are as as follows:
    name : STRING
    id : Integer
    quality : STRING

    If applied sorting based on "id" then Postgres query provides correct resultset as below,you can see the id sorted correctly
    EG:Entries are ordered=>0,1,2,3,4,5,6,7,8,9,10,11........

    PG Query:
    SELECT * FROM datatable WHERE entityid = 'DT' ORDER BY fieldvalues->'id' ASC, entryid ASC OFFSET 0 ROWS FETCH NEXT 10000 ROWS ONLY

    But when tried the same via SQL Query,then result set is fetched with respect to "id" field,"id" is treated as text hence…

    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 →
  14. Enable creation of MDS databases and Stretch databases in Azure SQL Database serverless

    It is a very common business scenario the data present in tables in
    Stretch databases is uploaded and accessed periodically,
    thus making it a great candidate to be hosted in Azure SQL Database serverless. That way the current model costs, with min 100 DSU, can be avoided.

    Following the same idea as the general Azure SQL Database serverless, the MDS databases are rarely accessed out of the businesses working hours. So having them in Azure SQL first, and even better as Serverless, since predictable pattern of absence of processing power is applicable, will be beneficial.

    24 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 →
  15. Restore SQL MI database to SQL on VM

    Require feature to restore the SQL MI database to SQL on VM. The database size of 5 Gigs takes 30 minutes using the BACPAC method.

    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. Allow storage account with vnet and behind firewall to be used for SQL's advanced threat protection.

    As described in Microsoft documentation https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing#subheading-1 a storage account behind firewall and a storage account with vnet is currently not supported for SQL's advanced threat protection.
    This possess a high security risk where the logs will visible to anyone with access to the subscription, sas uri or storage account key.
    We expect this to be fixed and enhanced so that a storage account with vnet and behind firewall can be used for SQL's advanced threat protection.

    38 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  17. Use Elastic query with Private Endpoint

    From the documentation :
    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-query-vertical-partitioning#best-practices

    Currently the elastic query only works with deny public network access set to NO and allowing all azure services to access the database, there should be a way to get the elastic query working with private endpoint.

    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 →
  18. Build SSDT Data Project for Azure SQL Database Fails on CREATE MASTER KEY

    When adding a master encryption key for an Azure SQL Database project that will use external datasources, Visual Studio 2019 has a parsing error on the CREATE MASTER KEY ENCRYPTION statement. (SQL70015: Statement 'CREATE MASTER KEY' is not supported for the targeted platform). This statement is perfectly valid for Azure SQL Databases and is actually required to use credentials that have a stored secret.

    18 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 →
  19. Enable elastics jobs to use managed service identity

    SQL Server now supports MSI and yet Elastic Jobs still relies on SQL user credentials. It would be much better to be able to give a job an AD identity that can be managed and can be given rights on certain servers and databases.

    65 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 →
  20. Add SQL Management Studio to the Windows Store

    Why isn't it in the Windows Store ?
    It makes installing and patching a lot easier and safer.

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

SQL Database

Categories

Feedback and Knowledge Base