SQL Database

  1. Give an option to create bacpac file for azure SQL Data-warehouse

    We have an azure data warehouse database and we want to take a back up of the objects in it (stored proc, tables and other scripts). It seems like there is an option to create bacpac files using the export option in azure database but not available for Azure SQL Datawarehouse. Is it correct?

    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. Add support for encryption with 4096-bit keys stored in Azure Key Vault

    Currently the ENCRYPTBYASYMKEY() function only support an RSA key up to 2048-bits, which is currently not the highest available (https://docs.microsoft.com/en-us/sql/t-sql/functions/encryptbyasymkey-transact-sql?view=sql-server-ver15)

    And also storing a key/certificate inside the database isn't state of the art in 2020.

    So it would be nice if we could see an integration with Azure Key Vault (to store our keys/certificates centrally) for Azure SQL databases. And then indirectly also support 4096-bit keys to encrypt content inside the database.

    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 →
  3. TempDB Log Used Percent Usage

    Current metric on azure portal reflects the current log file usage, even though the file is set to autogrow. Hence the percentage would be better used with comparison to the total file size of temp log.

    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 →
  4. 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 →
  5. 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…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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 →
  7. 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.

    29 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. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. 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.

    56 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 →
  14. 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 →
  15. 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.

    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. 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 →
  17. 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 →
  18. 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 →
  19. 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 →
  20. 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 →
← Previous 1 3 4 5 37 38
  • Don't see your idea?

SQL Database

Categories

Feedback and Knowledge Base