SQL Database release notes

This article lists the new features and improvements in the SQL Database service and in the SQL Database documentation. For SQL Database service improvements, see also SQL Database service updates. For improvements to other Azure services, see Service updates.

Features in public preview

Feature Details
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.
Instance collation with managed instances For information, see Use PowerShell with Azure Resource Manager template to create a managed instance in Azure SQL Database.
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.
Recreate dropped databases with managed instances For information, see Re-create dropped databases in Azure SQL Managed Instance.
Replication with managed instances For information, see Configure replication in an Azure SQL Database managed instance database.
Serverless compute tier For information, see SQL Database serverless (preview).
SQL Analytics For information, see Azure SQL Analytics.
Table Variable Deferred Compilation (under compatibility level 150) For information, see Table Variable Deferred Compilation.
Threat detection with managed instances For information, see Configure threat detection in Azure SQL Database managed instance.
Time zone support for managed instances For more information, see Time Zone in Azure SQL Database Managed Instance.
Transparent data encryption (TDE) with Bring Your Own Key (BYOK) with managed instances For information, see Azure SQL Transparent Data Encryption with customer-managed keys in Azure Key Vault: Bring Your Own Key support.
 

May 2019

Service improvements

Service improvements Details
Hyperscale service tier released for general availability For more information, see Hyperscale service tier for up to 100 TB and Get high-performance scaling for your Azure database workloads with Hyperscale.
Serverless compute tier released for public preview For more information, see SQL Database serverless (preview).
Transaction log rates and target IOPS increased for databases using the vCore-based purchasing model For more information, see Resource limits for single databases using the vCore-based purchasing model and Resource limits for single databases using the DTU-based purchasing model.
 

Documentation improvements

Documentation improvements Details
Hyperscale service tier docs updated for GA release For more information, see Hyperscale service tier for up to 100 TB.
Serverless compute tier docs released with public preview For more information, see SQL Database serverless (preview).
 

April 2019

Service improvements

Service improvements Details
Public endpoints for managed instance in public preview For more information, see Using Azure SQL Database managed instance securely with public endpoint.
Time zone support for managed instance in public preview For more information, see Time Zone in Azure SQL Database Managed Instance.
Securing Azure SQL Databases with managed identities in second public preview release See Securing Azure SQL Databases with managed identities just got easier.
 

Documentation improvements

Documentation improvements Details
Public endpoints for managed instance in public preview For more information, see Using Azure SQL Database managed instance securely with public endpoint.
Time zone support for managed instance in public preview For more information, see Time Zone in Azure SQL Database Managed Instance.
Resource governance in Azure SQL Database For more information, see Resource governance in Azure SQL Database.  

March 2019

Service improvements

Service improvements Details
Read scale-out support for Azure SQL Database released for general availability For more information, see Read scale-out.
 

Documentation improvements

Documentation improvements Details
Added log limits for single databases For more information, see Single database vCore resource limits.
Added log limits for elastic pools and pooled databases For more information, see Elastic pools vCore resource limits.
Added Transaction log rate governance Added new content for Transaction log rate governance.
Updated PowerShell samples for single databases and elastic pools to use az.sql module For more information, see PowerShell samples for single databases and elastic pools.
 

February 2019

Service improvements

Service improvements Details
Creating a resumable online index is now generally available For more information, see Create Index.
Managed instance support for route tables improved For more information, see Network requirements.
Database rename supported in managed instance For more details, see the ALTER DATABASE and sp_rename syntax.
SQL Database as a source of reference data for Stream Analytics. For more information, see Stream Analytics and Azure Stream Analytics now supports Azure SQL Database as reference data input.
Data Migration Assistance adds support for managed instance. For more information, see What's new in DMA.
SQL Server Migration Assistant adds support for target readiness assessment for managed instance. For more information, see SQL Server Migration Assistant.
Data migration service supports migrating from Amazon RDS to managed instance For more information, see Tutorial: Migrate RDS SQL Server to Azure SQL Database or an Azure SQL Database managed instance online using DMS.
 

Documentation improvements

Documentation improvements Details
Adding managed instance deployment option clarifications Updated many articles to clarify applicability to single database, elastic pool, and managed instance deployment options.
Updated tempdb sizes for DTU-based purchasing model For more information, see Tempdb database in SQL Database.
Updated import and export with bacpac file for managed instance support For more information, see Import from BACPAC and Export to BACPAC.
 

January 2019

Service improvements

Service improvements Details
Additional granularity options for compute resources The general purpose and business critical service tiers for single databases and elastic pools now have more fine-grained compute options.
Viewing audit records for managed instance in the Azure portal Viewing audit records for managed instances in the Azure portal is now supported.
Advance threat detection feature renamed to Advanced Data Security Advance threat detection feature renamed to Advanced Data Security for single databases, elastic pools, and managed instances.
 

Documentation improvements

Documentation improvements Details
Managed instances and transactional replication Added article about using transactional replication with managed instances.
Added Azure AD with managed instance tutorial This Azure AD with managed instance tutorial shows you have to configure and test managed instance security using Azure AD logins.
Updated content for job automation using Transact-SQL scripts Updated and clarified content for using job automation using Transact-SQL scripts for single databases, elastic pools, and managed instances.
Security content for managed instances updated Updated and clarified content for the security model for managed instances, and contrasted in with the security model for single databases and elastic pools.
Refreshed all quickstarts and tutorials All of the quickstarts and tutorials in the documentation have been updated and refreshed to match changes in the Azure portal.
Added quickstart overview guides Added a quickstart overview guide for single databases and for managed instances.
Added SQL Database glossary of terms This terms glossary article provides a definitive list of SQL Database terms and links to the primary conceptual page that explains the term in context.
 

Contribute to content improvement

The Azure SQL documentation set is open source. Working in the open provides several advantages:

  • Open source repos plan in the open to get feedback on what docs are most needed.
  • Open source repos review in the open to publish the most helpful content on our first release.
  • Open source repos update in the open to make it easier to continuously improve the content.

To contribute to Azure SQL Database documentation content, see the Microsoft Docs contributor guide overview. The user experience on docs.microsoft.com integrates GitHub workflows directly to make it even easier. Start by editing the document you are viewing. Or, help by reviewing new topics, or create quality issues.