SQL Database

  1. location

    When using the student account to creating the azure sql. it always show that the server location is not availbe to the subscription.

    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. Hyperscale: support for Transparent Data Encryption using Key Vault (BYOK)

    It would be great to have support for Transparent Data Encryption (TDE) using a Key Vault generated key, commonly referred as Bring Your Own Key or BYOK).

    6 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 →
  3. Database Service Objective changer - "Unknown"

    When we perform Database Service Objective change through TSQL (Sql Server Management Studio) , it's details of operation like, caller, IP address and event initiated by are not logged in the Azure portal.

    Sample TSQL Command:
    ALTER DATABASE [DBNAME]

    MODIFY ( EDITION = 'Premium', SERVICE_OBJECTIVE = 'P6')

    5 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 →
  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. 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 →
  6. SQL Database and SQL Server auditing settings should allow disabling BATCH_COMPLETED_GROUP

    I want to disable BATCHCOMPLETEDGROUP when forwarding auditing logs to Log Analytics workspaces and choose a setting that better satisfies my auditing requirements as described here: https://docs.microsoft.com/en-us/azure/templates/microsoft.sql/2017-03-01-preview/servers/databases/auditingsettings#databaseblobauditingpolicyproperties-object.

    When enabling either or both SQL Database and Azure SQL Server auditing, you also need to enable the diagnostic setting 'SQLSecurityAuditEvents’. This comes with the default setting to log events from the BATCHCOMPLETEDGROUP. This logs all t-sql statements issued on the database.

    Right now, important statements as ALTER USER and ALTER ROLE are drowned out by the noise created by harmless statements. And these harmless statements also increase…

    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. point in time restore - to validate the target database tier if it will fit database size before starting the restore process

    point in time restore - to validate the target database tier if it will fit database size before starting the restore 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 →
  8. 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 →
  9. Provide greater transparency over patch status of known applicable CVE's

    As a Independent Software Vendor (ISV) that uses Azure SQL DB to run our Software as a Service offering to our customers we get challenges from those customers to verify that the service they are using is mitigated against published CVE's. Where those CVE's are applicable to things like SQL Server or Windows OS we do not have any transparency to assert if the Azure SQL DB service is patched. We have to open a support ticket for each incident. Would love to see some transparency over patched applicable CVEs

    9 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. 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 →
  11. firewall

    Track Firewall Rules for Change Management and Security
    It would be great if there was an historical record of firewall rules from inception of both the Azure SQL server as well as any Database. What should be recorded is the user/principal that added/deleted/modified a firewall rule(s) and the context of that rule(s). There needs to be the ability to store this (an all auditing information) for long term storage, securely, and this should allow for interaction into Log Analytics, Security Center and Alerting. Finally, there should not be different methods for logging this information but universally standardized, example, using the…

    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. SQL Database must have configuration time for apply new patches

    Currently, azure apply patches and update during the working hours for the Azure database. Due to that business affected.

    Please give time frame for apply this type of release on live server.

    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. Read data from Azure Blob store into SQL

    Please implement a method for reading data from Azure Blob into SQL DB.

    2 of the top 3 issues are asking for this, both have been rejected - please impletent a method that would be allowable.

    https://feedback.azure.com/forums/217321-sql-database/suggestions/413287-implement-filestream-for-blobs-into-azure-blob-sto

    https://feedback.azure.com/forums/217321-sql-database/suggestions/17376250-polybase-support-for-azure-sql-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 →
  14. zone

    Allow zone redundancy to be available for DTU pricing model when DB size is greater than 1TB. The only recourse we have when a DTU DB needs to be bumped past 1TB is to switch it to vCore, and that is not always the direction we want to take.

    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. Increase the SQL pool size to 4TB in 500eDTU

    We have less number of customers and they want to keep 10 years of data. So we need more storage space than the performance. Please give an option to increase the storage to 4TB in 500 eDTU in premium tier

    Thank you.

    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. Permissions dropped and recreated by SSDT during publish

    SSDT drops and recreates permissions during publish. Without any changes being made to the project, I can repeatedly publish, and SSDT will generate a bunch of these:

    PRINT N'Dropping Permission...';
    GO
    REVOKE...

    followed by a bunch of these:

    PRINT N'Creating Permission...';
    GO
    GRANT... ... AS [dbo]

    It doesn't do this if I use the Azure admin user, but that's not a suitable user to use as we have several developers who may publish to certain dbs. It does do it if I use a database user which is a member the the db_owner database role.

    If I specify in my…

    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 →
  17. VSCode unable to create a firewall

    VS Code (SQL server connect) asks me to create a firewall when trying to connect to an Azure SQL db (Yes. My account is already logged in).

    When creating the firewall, it asks for start and end IPs, and then throws me the error mentioned in the screenshot.

    (PS: I already have a valid firewall for my server. So, I am also unable to understand why VScode asks me to create a new one)

    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 →
  18. Allow SQL DNS Alias failover group

    Azure SQL Databases allow creating dns aliases for servers. However what does not work is to create a DNS alias against the names of a failover group. The attempt fails as the failover group is not a resource itself. We need the ability to make changes to our backend transparent for the database users.
    The current limitation means the failover feature looses its value. We cannot have our application point to the failover group name but instead must implement a custom failover mechanism that redirects DNS aliases to the right servers (since we do connect directly to the database and…

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

SQL Database

Categories

Feedback and Knowledge Base