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? |
Availability metric |
Availability is now a metric in the Azure Monitor metrics. Driven by a variety of user connection failures, you can monitor and configure alerts on Azure SQL Database Availability. |
DATEADD number allows bigint |
For DATEADD (datepart , number , date ) , number can be expressed as a bigint. DATEADD (Transact-SQL) |
Copilot skills in Azure SQL Database |
Microsoft Copilot skills in Azure SQL Database include two Azure portal experiences: Natural language to SQL within the Azure portal query editor, and Azure Copilot integration. |
DATEADD number allows bigint |
For DATEADD (datepart , number , date ) , number can be expressed as a bigint. For more information, see DATEADD (Transact-SQL). |
Database watcher for Azure SQL |
Database watcher is a managed monitoring solution for database services in the Azure SQL family. Database watcher collects in-depth workload monitoring data to give you a detailed view of database performance, configuration, and health. Learn more about database watcher. |
Degrees of Parallelism (DOP) feedback |
DOP Feedback is currently available as a limited preview. For more information and how to apply for the preview, see Announcing Degree of Parallelism Feedback Limited 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. |
Hyperscale increased log generation rate |
The transaction log generation rate in Azure SQL Database Hyperscale single databases is set to increase from 100 MiB/s to 150 MiB/s. The increased log generation rate is available as an opt-in preview feature. For more information and to opt in to 150 MiB/s, see Blog: November 2024 Hyperscale enhancements. |
Hyperscale continuous priming |
Continuous priming is an innovative new feature designed to optimize Hyperscale performance during failovers by priming high availability secondary compute replicas. Continuous priming is currently in a gated preview. For more information and to opt in to continuous priming, see Blog: November 2024 Hyperscale enhancements. |
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. |
JSON native data type |
The new json data type and JSON aggregate functions provide new capabilities for handling semistructured data in Azure SQL Database. For more information, see JSON Type and aggregates preview. |
JSON aggregate functions |
Two new json aggregate functions JSON_OBJECTAGG and JSON_ARRAYAGG enable construction of JSON objects or arrays based on an aggregate from SQL data. For more information, see JSON Type and aggregates preview. |
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. |
Microsoft Entra server principals |
The ability to create server principals (logins) for Microsoft Entra identities in Azure SQL Database is in preview. |
Network Security Perimeter |
Azure Network Security Perimeter allows organizations to define a logical network isolation boundary for PaaS resources (for example, Azure Storage and SQL Database) that are deployed outside your organization's virtual networks. It restricts public network access to PaaS resources outside of the perimeter, and access can be exempted by using explicit access rules for public inbound and outbound. |
Regular expression functions |
Regular expression (REGEX) functions return text based on values in a search pattern. Regular expressions. |
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. |
UNISTR (Transact-SQL) |
Azure SQL Database now supports the UNISTR T-SQL syntax for Unicode string literals. For more information, see UNISTR (Transact-SQL). |
Vector data type |
Working with vector data is now easier in Azure SQL Database with the introduction of a new vector data type and functions. For more information, see Intelligent applications with Azure SQL Database. |
|| (String concatenation) and ||= (Compound assignment) syntax support |
Azure SQL Database now supports || (String concatenation) and ||= (Compound assignment) Transact-SQL syntax. |