Hindi na suportado ang browser na ito.
Mag-upgrade sa Microsoft Edge para samantalahin ang mga pinakabagong tampok, update sa seguridad, at teknikal na suporta.
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
Deploy Azure SQL Database for free, for the life of your Azure subscription. This free offer provides up to ten free General Purpose databases, each with 100,000 vCore seconds of compute, every month.
For more announcements, discussion, and community content, see the Azure SQL Database blog.
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 |
|---|---|
| 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. |
| 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. |
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 |
|---|---|---|
| Availability metric | February 2025 | Availability is presented as 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. For more information, see Blog: Availability metric is now generally available. |
| sys.dm_database_backups | February 2025 | The sys.dm_database_backups DMV returns information about the automated backups of a database. |
| Free Azure SQL Database | January 2025 | Use Azure SQL Database for free, for the life of your subscription. This free offer provides up to ten free General Purpose databases, each with 100,000 vCore seconds of compute, every month. For more information, see Blog: General availability of Azure SQL Database free offer. |
| 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. |
| Fabric mirrored databases | November 2024 | 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. |
| 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 pools also support Premium-series hardware and zone redundancy. For more information, see Hyperscale Elastic Pools are now generally available. |
| 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. |
| Database compatibility level 160 is now default | June 2024 | Database compatibility level 160 is now the default for new databases created in Azure SQL Database. For more information on this announcement, see General availability: Database compatibility level 160 in Azure SQL Database. |
| Hyperscale named replica zone redundant support | June 2024 | Zone redundancy support for Hyperscale named replicas is now generally available. For more information, see Hyperscale secondary replicas. |
| License-free standby replica | May 2024 | Save on licensing costs by configuring your secondary database replica for disaster recovery standby. |
| Elastic jobs | April 2024 | Elastic jobs, now generally available, are the SQL Server Agent replacement for Azure SQL Database. Elastic jobs now support Microsoft Entra ID authentication, private endpoints, management via REST APIs, Azure Alerts, and more new features since preview began. |
| 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. |
Learn about significant changes to the Azure SQL Database documentation. For previous years, see the What's new archive.
| 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. |
| Availability metric | Availability is presented as 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. For more information, see Blog: Availability metric is now generally available. |
| 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. |
| Changes | Details |
|---|---|
| Free Azure SQL Database | Use Azure SQL Database for free, for the life of your subscription. This free offer provides up to 10 free General Purpose databases, each with 100,000 vCore seconds of compute, every month. For more information, see Blog: General availability of Azure SQL Database free offer. |
| 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. |
| SQL Insights retired | SQL Insights has been retired and is no longer available. Use database watcher or another monitoring solution to monitor Azure SQL Database. |
For previous updates, see the What's new archive.
To contribute to the Azure SQL documentation, see the Docs contributor guide.
Pagsasanay
Learning path
Use advance techniques in canvas apps to perform custom updates and optimization - Training
Use advance techniques in canvas apps to perform custom updates and optimization
Sertipikasyon
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Dokumentasyon
What is the Azure SQL Database service? - Azure SQL Database
Get an introduction to SQL Database: technical details and capabilities of the Microsoft relational database management system (RDBMS) in the cloud.
Azure SQL Database documentation - Azure SQL
Find documentation about Azure SQL Database, a platform-as-a-service (PaaS) based on the latest stable version of Microsoft SQL Server.
What is Azure SQL? - Azure SQL
Learn about the different options within the Azure SQL family of services: Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VM.