SQL Database

  1. Cost estimates when migrating to vCore model database/elastic pool are misleading

    When converting a database or elastic pool from an eDTU model to a vCore model, the "estimated cost" displayed is misleading because it does not include (or even mention) that there may be additional backup costs - which are unquantifiable.

    We moved a Premium RS pool to vCore when Premium RS was retired, and it was only after a few months that we realized that the backup costs were dominating the storage costs.

    Worse is that backup is RA-GRS, which is more expensive than regular DB storage ...

    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 Full SQL Audit Logs to the Azure Monitor

    It would be nice if we could monitor schema changes on a database from the Azure Monitor.

    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. Support for Single User Mode

    Single user mode that will work for an Azure SQL Database, (WIth or Without geo replication)

    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. Lower the price of SQL Azure

    Today the price of the cheapest vCore based SQL Azure is $368.19 (in East US, Gen5, 2 vCores). However, the same with MariaDb is $127.90. Azure SQL Database is almost 3x more expensive than Azure Database for MariaDB. I understand that SQL Server must be licensed, so I'd glad to pay some extra, but it seems overpriced.

    We simply cannot afford Microsoft SQL Server with this pricing and will choose MariaDb/Postgres. Once we have a profiable business there willl be no way to go back to MSSQL even if we could then afford paying the licence fee.

    Please note that…

    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 →
  5. Enable lockdown of Blob firewall to selected networks for the purposes of storing Azure SQL auditing logs etc

    Enable lockdown of Blob firewall to Selected networks/Trusted Microsoft Services for the purposes of storing Azure SQL auditing logs and Azure SQL Database vulnerability assesments.

    Last thing anyone wants is an internet hack on the blob that contains log files listing your vulnerabilities, users, tablenames and other juicy content found in the audit and scan logs.

    Can hardly believe that this passes any compliance regimens!

    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. Report ResourceWriteSuccess when an Azure SQL Database is renamed via SQL script.

    Azure SQL Server is not reporting an event to ARM to indicate that a database was renamed (ResourceWriteSuccess event would be appropriate). If you have an Event Grid Subscription for the event ResourceWriteSuccess on a resource group, and rename an Azure SQL Database via T-SQL, you will not receive the ResourceWriteSuccess event. I don't know if this is intentional. The SQL Database disappears in the portal, and reappears minutes later with the new name. This indicates to me that a resource was created or updated, according to the definition of the ResourceWriteSuccess event.

    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 →
  7. there should be option to down grade from Azure SQL DWH to Azure Sql.

    there should be option to down grade from Azure SQL DWH to Azure Sql.

    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. Automated Backup of SQL DB: Should be visible to customer.

    As of today, we have no visibility of automated backup. Though, we rely of Microsoft to have successful backup but as a consumer/customer, we should have listing of backups when it is done and what is the status of backups.

    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. Azure SQL Server Elastic Pools auto scale - Auto Pilot

    Azure SQL Server Elastic Pools and Databases should have an option to configure max usage and it should scale automatically. We should be charged by its usage. The feature should be similar to the AutoPilot feature of Cosmos DB.

    It takes a lot of work to be able to scale up and down Elastic Pools, and since it is service it should have this feature.

    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. Completed notification of reconfiguration

    There should be some kind of notification when reconfiguration is completed especially when it takes more time than normally. There was a situation where couple of our databases were very long time (many hours) in pausing status while reconfiguration was going on. It was annoying when you did not know when reconfiguration was completed instead you have to check time to time what is status of databases.

    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 →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. 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 →
  19. Single & Elastic Databases - Support for "pausing" active geo-replication

    Let's say I have a SQL server w/ a single database. I can setup a corresponding geo-replicated database in a different region quite easily. My question is about "pausing" geo-replication for a while. As of today, I can stop the replication using the ALTER statement. But I cannot add the replication back w/ an ALTER statement, unless I drop the database altogether. So it would be great to have the ability to "pause" or "un-pause" a geo-replication with the help of API's.

    The use case is during database upgrades. Roughly I wanted to accomplish this.


    1. App A points to database…
    1 vote
    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. Management connectivity from Azure via separate nic

    We use ExpressRoute and do not allow public IP's in our VNets. This causes a problem when it comes to deploying SQL Managed instance, as we need to allow inbound connectivity on ports 9000, 9003, 1438, 1440, 1452. Could it not be arranged for this connectivity to happen via a separate network unseen to the consumer so that no inbound firewall rules are required?

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

SQL Database

Categories

Feedback and Knowledge Base