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
|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.|
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:
- Support for subscriptions with Azure monthly credit for Visual Studio subscribers and increased regional limits.
- Support for SharePoint 2016 and SharePoint 2019 and Dynamics 365 Business Central
- Create instances with server-level collation and time-zone of your choice.
- Managed instances are now protected with built-in firewall.
- Configure instances to use public endpoints, Proxy override connection to get better network performance, 4 vCores on Gen5 hardware generation or Configure backup retention up to 35 days for Point-in-time restore. Long-term backup retention (up to 10 years) is still not enabled so you can use Copy-only backups as an alternative.
- New functionalities enable you to geo-restore your database to another data center using PowerShell, rename database, delete virtual cluster.
- New built-in Instance Contributor role enables separation of duty (SoD) compliance with security principles and compliance with enterprise standards.
- Managed instance is available in the following Azure Government regions to GA (US Gov Texas, US Gov Arizona) as well as in China North 2 and China East 2. It is also available in the following public regions: Australia Central, Australia Central 2, Brazil South, France South, UAE Central, UAE North, South Africa North, South Africa West.
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 CHECKDBafter restore database from Azure Blob Storage.
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.