What's new in Azure SQL Database?

Applies to: Azure SQL Database

This article summarizes the documentation changes associated with new features and improvements in the recent releases of Azure SQL Database. For more information about Azure SQL Database, see What is Azure SQL Database?.

Preview

The following table lists the features of Azure SQL Database that are currently in preview.

Feature Details
ABORT_QUERY_EXECUTION The new ABORT_QUERY_EXECUTION query hint, currently in preview, can block future execution of known problematic queries, for example nonessential queries causing high resource consumption and impacting critical application workloads. For more information, see Query Store hints: Block future execution of problematic queries.
Approximate or fuzzy string matching Check if two strings are similar, and calculate the difference between two strings. Use this capability to identify strings that might be different because of character corruption. What is fuzzy string matching?
Convert to Hyperscale with geo-replicas (preview) The ability to convert a geo-replicated database non-Hyperscale database to Hyperscale using T-SQL, REST API, PowerShell, or Azure CLI is currently a preview feature. For more information, see Blog: Hyperscale conversion support for geo-replicas.
DATEADD number allows bigint For DATEADD (datepart , number , date ), number can be expressed as a bigint. For more information, see DATEADD (Transact-SQL).
Data Virtualization for Azure SQL Database Data virtualization, now in preview in Azure SQL Database, enables you to leverage all the power of Transact-SQL (T-SQL) and seamlessly query external data from Azure Data Lake Storage Gen2 or Azure Blob Storage. For more information, see Data virtualization with Azure SQL Database (Preview).
Elastic queries The elastic queries feature allows for cross-database queries in Azure SQL Database.
Elastic transactions Elastic transactions allow you to execute transactions distributed among cloud databases in Azure SQL Database.
Fixed server roles To simplify permission management, Azure SQL Database provides a set of fixed server-level roles to help you manage the permissions on a logical server.
Import and export using Private Link You can import or export an Azure SQL Database using private link. Leave Allow Access to Azure Services off when you import or export a database using a service-managed endpoint.
Microsoft Entra server principals The ability to create server principals (logins) for Microsoft Entra identities in Azure SQL Database is in preview.
Query editor in the Azure portal The query editor in the Azure portal allows you to run queries against your Azure SQL Database directly from a web browser.
Regular expression functions Regular expression (REGEX) functions return text based on values in a search pattern. Regular expressions.

General availability (GA)

The following table lists features of Azure SQL Database that have been made generally available (GA) within the last 12 months:

Feature GA Month Details
sys.dm_hs_database_replicas August 2025 You can query the details of Azure SQL Database Hyperscale replicas with the new dynamic management view (DMV) sys.dm_hs_database_replicas.
UNISTR (Transact-SQL) July 2025 Azure SQL Database now supports the UNISTR T-SQL syntax for Unicode string literals. For more information, see UNISTR (Transact-SQL).
|| (String concatenation) and ||= (Compound assignment) syntax support July 2025 Azure SQL Database now supports || (String concatenation) and ||= (Compound assignment) Transact-SQL syntax.
Degrees of Parallelism (DOP) feedback July 2025 DOP Feedback is now generally available for Azure SQL Database. For more information, see Smarter Parallelism: Degree of parallelism feedback in SQL Server 2025.
JSON native data type May 2025 The json data type and JSON aggregate functions provide new capabilities for handling semistructured data in Azure SQL Database.
JSON aggregate functions May 2025 Two json aggregate functions JSON_OBJECTAGG and JSON_ARRAYAGG enable construction of JSON objects or arrays based on an aggregate from SQL data.
Manually initiate cutover for conversion to Hyperscale April 2025 When converting an Azure SQL Database to the Hyperscale service tier, you have a new option to manually initiate the cutover. For more information, see Convert an existing database to Hyperscale.
sys.dm_database_backups February 2025 The sys.dm_database_backups DMV returns information about the automated backups of a database.
Hyperscale support for database and file shrink January 2025 Database and file shrink commands are now generally available for Azure SQL Database Hyperscale. For more information, see the Shrink in Hyperscale Generally Available blog post.
Microsoft Entra nonunique name support November 2024 The CREATE USER Transact-SQL (T-SQL) syntax has been extended to include WITH OBJECT_ID to support creating Microsoft Entra logins and users in Azure SQL Database that have nonunique names.
Lower auto-pause delay for serverless October 2024 Reduce costs by lowering the auto-pause delay for serverless compute in Azure SQL Database. Learn more about the auto-pause delay for serverless.
Hyperscale elastic pools September 2024 Manage and scale multiple Hyperscale databases in Azure SQL Database by using Hyperscale elastic pools.
Hyperscale elastic pool maintenance window support September 2024 You can configure a non-default maintenance window for a Hyperscale elastic pool. For more information, read Blog: Maintenance window support for Azure SQL Database Hyperscale elastic pools.
CURRENT_DATE August 2024 The CURRENT_DATE Transact-SQL (T-SQL) function returns the current database system date as a date value, without the database time and time zone offset.
Maintenance window support for named replicas August 2024 Maintenance window support for named replicas is now generally available. For more information, see General Availability: Maintenance window support for Azure SQL Database Hyperscale named replica.
Maintenance window support for Hyperscale August 2024 Maintenance window support for Hyperscale databases is now generally available.
Automatic backups on secondary replicas August 2024 Mitigate the performance impact on your workload by taking automated backups from the non-readable secondary replica in the Business Critical service tier.

Documentation changes

Learn about significant changes to the Azure SQL Database documentation. For previous years, see the What's new archive.

August 2025

Changes Details
sys.dm_hs_database_replicas You can query the details of Azure SQL Database Hyperscale replicas with the new dynamic management view (DMV) sys.dm_hs_database_replicas.

July 2025

Changes Details
UNISTR Azure SQL Database now supports the UNISTR. This syntax is now generally available. For more information, see UNISTR (Transact-SQL).
| | and | | = string concatenation support Azure SQL Database now supports | | and | | = compound assignment T-SQL syntax. This syntax is now generally available. For more information, see || (String concatenation) and ||= (Compound assignment).
Degrees of Parallelism (DOP) feedback DOP Feedback is now generally available for Azure SQL Database. For more information, see Smarter Parallelism: Degree of parallelism feedback in SQL Server 2025.
Convert to Hyperscale with geo-replicas (preview) The ability to convert a geo-replicated database non-Hyperscale database to Hyperscale using T-SQL, REST API, PowerShell, or Azure CLI is currently a preview feature. For more information, see Blog: Hyperscale conversion support for geo-replicas.
Audit re-architecture GA Enhancements to performance, availability, and reliability in server auditing for Azure SQL Database. For more information, see Auditing.
TLS 1.0 and 1.1 retirement FAQ Azure has announced that support for older TLS versions (TLS 1.0, and 1.1) ends August 31, 2025. For more information, see TLS 1.0 and 1.1 deprecation frequently asked questions. Starting August 2025, versions below TLS 1.2 won't be available.

June 2025

Changes Details
Data Virtualization for Azure SQL Database (preview) Data virtualization, now in preview in Azure SQL Database, enables you to leverage all the power of Transact-SQL (T-SQL) and seamlessly query external data from Azure Data Lake Storage Gen2 or Azure Blob Storage. For more information, see Data virtualization with Azure SQL Database (Preview).

May 2025

Changes Details
JSON native data type GA The json data type and JSON aggregate functions provide new capabilities for handling semistructured data in Azure SQL Database. This data type is now generally available.
JSON aggregate functions GA Two json aggregate functions JSON_OBJECTAGG and JSON_ARRAYAGG enable construction of JSON objects or arrays based on an aggregate from SQL data. These JSON functions are now generally available.

April 2025

Changes Details
Manually initiate cutover for conversion to Hyperscale When converting an Azure SQL Database to the Hyperscale service tier, you have a new option to manually initiate the cutover. For more information, see Convert an existing database to Hyperscale. This feature is currently in preview.

March 2025

Changes Details
ABORT_QUERY_EXECUTION The new ABORT_QUERY_EXECUTION query hint, currently in preview, can block future execution of known problematic queries, for example nonessential queries causing high resource consumption and impacting critical application workloads. For more information, see Query Store hints: Block future execution of problematic queries.

February 2025

Changes Details
Approximate or fuzzy string matching (preview) Check if two strings are similar, and calculate the difference between two strings. Use this capability to identify strings that might be different because of character corruption. What is fuzzy string matching?
DATEADD number allows bigint (preview) For DATEADD (datepart , number , date ), number can be expressed as a bigint. For more information, see DATEADD (Transact-SQL).
Regular expression functions (preview) Regular expression (REGEX) functions return text based on values in a search pattern. For more information, see Regular expressions.
sys.dm_database_backups The sys.dm_database_backups dynamic management view returns information about the automated backups of a database. This DMV is now generally available.
Manually initiate cutover for conversion to Hyperscale When converting an Azure SQL Database to the Hyperscale service tier, you have a new option to manually initiate the cutover. For more information, see Convert an existing database to Hyperscale. This feature is currently in preview.
Import bacpac file size increase The limit for an imported bacpac file size has been increased from 4 GB to 150 GB. For more information on importing a bacpac file generated from SqlPackage, see Quickstart: Import a bacpac file to a database in Azure SQL Database.

January 2025

Changes Details
Hyperscale support for database and file shrink Database and file shrink commands are now generally available for Azure SQL Database Hyperscale. For more information, see the Shrink in Hyperscale Generally Available blog post.

Archive

For previous updates, see the What's new archive.