SQL Database

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

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

    28 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 →
  3. Allow SPN's to create AAD Users

    As we follow best practices and fully automate Azure using SPN's while leveraging AAD for users, we wish to create AAD users in SQL DB using our SPN's.

    When attempting to create AAD users in a database using an SPN, we received this error:
    "Principal 'xxxxxx' could not be created. Only connections established with Active Directory accounts can create other Active Directory users."

    We were told by support that "At this time, the statement CREATE USER [] FROM EXTERNAL PROVIDER; is not supported for SPN."

    Request we make this possible...

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

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

    34 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Azure SQL Managed Instance DNS alias

    Just like DNS alias is supported for Azure SQL database https://docs.microsoft.com/en-us/azure/sql-database/dns-alias-overview,
    we need same functionality supported for Azure SQL managed instance, abstraction layer to redirect traffic during upgrades, massive data maintenance etc.

    26 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 final backup before delete

    I see there is a warning and you have to explicitly type 'Yes' to delete the Azure SQL database. However, people still delete the database ignoring the backup retention and pricing tier. It will be very useful if a by-default enabled checkbox that triggers the final backup before the database is being deleted(with no auto retention policy- that means the user will still pay for that backup). Users can choose to unselect the checkbox if the final backup is not required.

    10 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. Allow Recovery Model to be changed to SIMPLE in Azure SQL Database

    According to this article (https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/12/28/lesson-learned-50-adding-pk-led-to-transaction-log-full-error/) the recovery model of a Azure SQL Database cannot be altered from the default option FULL. In a very data intensive setup, this blows up the transaction log -> the LOG IO percentage in portal is at 100% all the time. Allowing the SIMPLE recovery model should improved the performance significantly.

    141 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Support AzureRm powershell sending database/server audit logs to write to Log Analytics

    Azure Automation account still dont fully support Az modules. It is very hard to setup a new Automation account with Az only.

    I have a lot of Runbooks written using AzureRm and would like the RM to be updated to include the log analytics workspace instead of only storage.

    AZ command: (supports Log Analytics)

     Set-AzSqlServerAuditing
    
    Set-AzSqlDatabaseAuditing

    AzureRm Command: (does not support Log Analytics)

      Set-AzureRmSqlServerAuditing
    
    Set-AzureRmSqlDatabaseAuditing

    9 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 →
  9. Enable serverless feature via ARM template

    Currently serverless feature not supported by ARM template. Manually changing to serverless from the portal results in an sku name of GPSGen5_1 (choosing the most basic). If I update my fully-working ARM template with this SKU name (instead of S0) for example, I get an error on deployment reporting:

    "error": {

    &quot;code&quot;: &quot;InvalidSkuName&quot;,
    
    &quot;message&quot;: &quot;Invalid SKU name &#39;GP_S_Gen5_1&#39;.&quot;

    }

    However this is already the value of the sku name on resource JSON export as a result of the change via Portal.

    NOTE: There were other detected changes to the JSON export (from Portal changes), which I also ensured…

    16 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 →
  10. Schedule time for Azure SQL Data Sync

    Currently you can set the frequency for synchronization but you cannot set the time.

    https://github.com/MicrosoftDocs/azure-docs/issues/40261

    The specific usecase I have is to synchronize data between a staging environment and a production environment every day at midnight. This way content administrators can set up data and see how it looks in production in the staging environment without impacting production and any data changes they would like to keep will get synced to production daily.

    Bonus points if we can just move to a cron schedule like Azure Functions. It would support so many scenarios for scheduling.

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

    11 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 →
  12. Include improved & regressed query plan links in sys.dm_db_tuning_recommendations

    When you enable Automatic Index Tuning, and Azure adds indexes, the portal's validation screen shows a count of the number of improved and regressed queries. However, there's no easy way to tell which queries they were.

    To facilitate that, how about in the "details" JSON column of sys.dmdbtuning_recommendations, you add something to help us join to Query Store or the plan cache to see which queries they were?

    56 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. connecting to a serverless db using an alias should wake db

    currently if you connect to an azure sql serverless db using an alias, the db will not start no matter how many times you try to connect or what connection timeout is used. this works as expected if you use the real sql server name.

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. Resize HyperScale Storage

    HyperScale database storage is incrementing exponentially, after we transferred database to HyperScale, it first incremented 20GB, than it incremented 30GB, and now it incremented 50GB, there is no way to reduce size. Either it is a bug that is incrementing exponentially or we need ability to resize, right now 80% of database is unused.

    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 →
  15. Implement python bindings for azure-sqldb-spark connector

    The azure-sqldb-spark Spark connector (https://github.com/Azure/azure-sqldb-spark) provides support for Spark on Scala, but does not currently provide Python bindings.

    Python-based Spark applications can still connect to MSSQL/Azure SQL databases using a JDBC connection, but this approach does not support bulk-inserts and is therefore quite slow for persisting large Spark dataframes to MSSQL.

    It would be useful if PySpark applications could take advantage of the bulk insert capabilities provided by the azure-sqldb-spark scala package. From the git repo readme: "Comparing to the built-in Spark connector, this connector provides the ability to bulk insert data into SQL databases. It can outperform…

    172 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 →
  16. makta

    Please improve the time zone of Azure SQL Database so that users can change it.

    When migrating to Azure SQL Database, it takes a lot of time to change all the programs of the application.

    59 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. Ability to export Azure SQL Performance Recommendations

    Our production Azure SQL does not allow developers to access (segregation of duties and security considerations). However, we want to share developers with Azure SQL performance recommendations so that they can improve the product logic.

    It seems Azure SQL Contributor permission is required for developers to review the details. If can allow export the recommendations, it could be performed automatically, then it will be very helpful.

    I guess other organizations could have similar challenges?

    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. Restored DBs in elastic pool goes to standard

    Steps to reproduce.

    Delete a DB that in an elastic pool.
    Recover the DB from deleted DB and use the latest PITR backup available.
    The restored DB doesnt go back to the original elastic pool but rather gets created as "Standard S0: 10 DTUs"
    Is this the expected behaviour.

    https://github.com/MicrosoftDocs/azure-docs/issues/46243#issuecomment-574939813

    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 →
  19. Build SSDT Database Project for Azure SQL Database Fails with AAD Users

    When adding an AAD user to a database project of type Azure SQL Database, the build fails with incorrect syntax on "FROM EXTERNAL PROVIDER", even when trying to add the uses in a post deployment script. However if the type is changed to Azure SQL Database Managed Instance, the project builds correctly.

    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 →
  20. Can't change database when logged in with "Active Directory Universal with MFA Support"

    When logged in to Azure SQL db using AAD with MFA option, I am unable to change databases via the database drop-down Listbox, even though the list is populated with the databases. Also, the "Change Connection" button on the "SQL Editor" toolbar is disabled. The Error received is:

    "TITLE: An error occurred while changing the current database.
    USE statement is not supported to switch between databases. Use a new connection to connect to a different database."

    HOWEVER, when logging in to the same Azure SQL db using AAD-Password, I AM able to change database via the drop-down Listbox and the…

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

SQL Database

Categories

Feedback and Knowledge Base