SQL Database release notes

This article lists SQL Database features that are currently in public preview. For SQL Database updates and improvements, see SQL Database service updates. For updates and improvements to other Azure services, see Service updates.

Features in public preview

Feature Details
New Fsv2-series and M-series hardware generations For information, see Hardware generations.
Azure private link Private Link simplifies the network architecture and secures the connection between endpoints in Azure by keeping data on the Azure network, thus eliminating exposure to the internet. Private Link also enables you to create and render your own services on Azure.
Accelerated database recovery with single databases and elastic pools For information, see Accelerated Database Recovery.
Approximate Count Distinct For information, see Approximate Count Distinct.
Batch Mode on Rowstore (under compatibility level 150) For information, see Batch Mode on Rowstore.
Data discovery & classification For information, see Azure SQL Database and SQL Data Warehouse data discovery & classification.
Elastic database jobs For information, see Create, configure, and manage elastic jobs.
Elastic queries For information, see Elastic query overview.
Elastic transactions Distributed transactions across cloud databases.
Memory Grant Feedback (Row Mode) (under compatibility level 150) For information, see Memory Grant Feedback (Row Mode).
Query editor in the Azure portal For information, see Use the Azure portal's SQL query editor to connect and query data.
R services / machine learning with single databases and elastic pools For information, see Machine Learning Services in Azure SQL Database.
SQL Analytics For information, see Azure SQL Analytics.
Table Variable Deferred Compilation (under compatibility level 150) For information, see Table Variable Deferred Compilation.
 

New features

Managed instance H2 2019 updates

  • Auto-failover groups enable you to replicate all databases from the primary instance to a secondary instance in another region.
  • Configure your Managed instance behavior with Global trace flags.

Managed instance H1 2019 updates

The following features are enabled in Managed instance deployment model in H1 2019:

Fixed known issues

  • Aug 2019 - Contained databases are fully supported in managed instance.
  • Oct 2019 - Built-in point-in-time database restore from Business Critical tier to General Purpose tier will not succeed if source database contains in-memory OLTP objects.
  • Oct 2019 - You can use Database Mail feature with external (non-Azure) mail servers using secure connection.
  • Nov 2019 - Database consistency is verified using DBCC CHECKDB after restore database from Azure Blob Storage.

Updates

For a list of SQL Database updates and improvements, see SQL Database service updates.

For updates and improvements to all Azure services, see Service updates.

Contribute to content

To contribute to the Azure SQL Database documentation, see the Docs Contributor Guide.