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?.

Tip

For more announcements, discussion, and community content, see the Azure SQL Database blog.

Note

Microsoft Entra ID was previously known as Azure Active Directory (Azure AD).

Preview

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

Note

Features currently in preview are available under supplemental terms of use, review for legal terms that apply to Azure features that are in beta, preview, or otherwise not yet released into general availability. Azure SQL Database provides previews to give you a chance to evaluate and share feedback with the product group on features before they become generally available (GA).

Feature Details
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.
Copilot in Azure SQL Database Copilot in Azure SQL Database, currently in preview, includes two Azure portal experiences: Natural language to SQL within the Azure portal query editor, and Azure Copilot integration.
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 jobs Updated with a preview refresh and new capabilities in November 2023, elastic jobs are the SQL Server Agent replacement for Azure SQL Database. Elastic jobs now support Microsoft Entra ID (formerly Azure Active Directory) authentication, private endpoints, management via REST APIs, Azure Alerts, and new capabilities and user interface in the Azure portal. Job Agents now provide four capacity tiers to scale concurrency for job execution.
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.
Fabric mirrored databases With Fabric Mirroring, you can mirror databases in Azure SQL Database to Microsoft Fabric. You can continuously replicate your existing data estate directly into Fabric's OneLake, including data from Azure SQL Database.
Free Azure SQL Database Try Azure SQL Database for free, for the life of your subscription. This free offer provides a General Purpose database with 100,000 vCore seconds of compute every month.
Hyperscale elastic pools Manage and scale multiple Hyperscale databases in Azure SQL Database by using Hyperscale elastic pools.
Hyperscale elastic pool maintenance window support You can now 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.
Hyperscale elastic pools Premium-series hardware Premium-series and premium-series memory optimized hardware is in preview for Hyperscale elastic pools.
Hyperscale elastic pools with zone redundancy You can now create zone redundant elastic pools in the Hyperscale service tier. You can migrate existing zone-redundant Hyperscale databases into elastic pools. For more information, read Blog post: Zone redundant Hyperscale elastic pools.
Hyperscale named replica zone redundant support Zone redundancy support for Hyperscale named replicas is in preview.
License-free standby replica Save on licensing costs by configuring your secondary database replica for disaster recovery standby.
Microsoft Entra nonunique name support 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.
Query editor in the Azure portal The query editor in the portal allows you to run queries against your Azure SQL Database directly from the Azure portal.
SQL Analytics Azure SQL Analytics is an advanced cloud monitoring solution for monitoring performance of all of your Azure SQL databases at scale and across multiple subscriptions in a single view. Azure SQL Analytics collects and visualizes key performance metrics with built-in intelligence for performance troubleshooting.
SQL Database emulator The Azure SQL Database emulator provides the ability to locally validate database and query design together with client application code in a simple and frictionless model as part of the application development process.

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
Maintenance window advance notifications March 2024 Advance notifications are now generally available for databases configured to use a nondefault maintenance window.
Azure SQL triggers for Azure Functions March 2024 Azure Functions supports function triggers for Azure SQL Database.
Serverless Hyperscale February 2024 Automatically scale your Hyperscale databases up and down based on usage when using the serverless compute tier, now generally available.
Lower, simplified pricing for Azure SQL Database Hyperscale December 2023 Simplified pricing for Azure SQL Database Hyperscale has arrived! For pricing change details, see Azure SQL Database Hyperscale – lower, simplified pricing!.
Always Encrypted with VBS enclaves November 2023 Take advantage of rich confidential queries and in-place encryption operations for Azure SQL Database with Always Encrypted with virtualization-based security (VBS) enclaves.
DC-series hardware up to 40 vCores November 2023 DC-series hardware from 10 to 40 vCores for General Purpose, Business Critical, and Hyperscale provisioned compute.

Documentation changes

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

March 2024

Changes Details
Advanced notifications for maintenance windows in Azure SQL Database Advance notifications for maintenance windows are now generally available for Azure SQL Database.
Maintenance window for Hyperscale elastic pools (preview) You can now 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.
Copilot in Azure SQL Database preview Copilot in Azure SQL Database, now in preview, includes two Azure portal experiences: Natural language to SQL within the Azure portal query editor, and Azure Copilot integration.
Fabric Mirrored Databases (Preview) You can now mirror databases in Azure SQL Database to Microsoft Fabric. You can continuously replicate your existing data estate directly into Fabric's OneLake, including data from Azure SQL Database.
Hyperscale named replica zone redundant support preview Zone redundancy support for Hyperscale named replicas is now available in preview. For more information, see Blog: Zone redundancy for Hyperscale named replicas.
Azure SQL triggers for Azure Functions GA Azure Functions supports function triggers for Azure SQL Database. This feature is now generally available. Review Azure SQL triggers for Azure Functions to learn more.
Database watcher for Azure SQL preview 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. This feature is now in preview. Learn more about database watchers.

February 2024

Changes Details
Zone redundancy now available for Hyperscale elastic pools (preview) You can now create zone redundant elastic pools in the Hyperscale service tier. You can migrate existing zone-redundant Hyperscale databases into elastic pools. For more information, read Blog post: Zone redundant Hyperscale elastic pools.
Serverless Hyperscale GA Automatically scale your Hyperscale databases up and down based on usage when using the Serverless Hyperscale tier, now generally available.
OBJECT_ID T-SQL syntax preview 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. Using WITH OBJECT_ID to create users and logins in Azure SQL Database is currently in preview. To learn more, review Microsoft Entra nonunique name support.

January 2024

Changes Details
New tutorial: Develop a Kubernetes Application for Azure SQL Database A new tutorial is available to demonstrate how to develop a modern application using Python, Docker Containers, Kubernetes, and Azure SQL Database.

December 2023

Changes Details
Lower, simplified Hyperscale pricing Simplified pricing for Azure SQL Database Hyperscale has arrived! Review the new pricing tier for Azure SQL Database Hyperscale announcement, and for pricing change details, see Azure SQL Database Hyperscale – lower, simplified pricing!.

November 2023

Changes Details
Use Azure Monitor metrics to monitor databases and elastic pools A new reference for monitoring Azure SQL Database with Azure Monitor is available, including a set of recommended alert rules to monitor Azure SQL Database with Azure Monitor metrics and alerts.
Always Encrypted with VBS enclaves GA Take advantage of rich confidential queries and in-place encryption operations for Azure SQL Database with Always Encrypted with virtualization-based security (VBS) enclaves. This feature is now generally available. Review Always Encrypted with VBS enclaves to get started.
DC-series hardware up to 40 vCores GA DC-series hardware from 10 to 40 vCores is now generally available for General Purpose, Business Critical, and Hyperscale provisioned compute. Review Resource limits for more information.
Elastic jobs preview Updated with a preview refresh and new capabilities, elastic jobs are the SQL Server Agent replacement for Azure SQL Database. Elastic jobs now support Microsoft Entra ID (formerly Azure Active Directory) authentication, private endpoints, management via REST APIs, Azure Alerts, and new capabilities and user interface in the Azure portal. Job Agents now provide four capacity tiers to scale concurrency for job execution.
License-free standby replica preview Save on licensing costs by configuring your secondary database replica for disaster recovery standby. This feature is currently in preview. Review License-free standby replica to learn more.  
Premium-series hardware for Hyperscale elastic pools preview Premium-series and premium-series memory optimized hardware is now in preview for Hyperscale elastic pools.

Archive

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

Contribute to content

To contribute to the Azure SQL documentation, see the Docs contributor guide.