Change data capture (CDC) lets you track all the changes that occur on a database. Though this feature has been available for SQL Server for quite some time, using it with Azure SQL Database is currently in preview.
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 insights is a comprehensive solution for monitoring any product in the Azure SQL family. SQL insights uses dynamic management views to expose the data you need to monitor health, diagnose problems, and tune performance.
The zone redundant configuration feature utilizes Azure Availability Zones to replicate databases across multiple physical locations within an Azure region. By selecting zone redundancy, you can make your general purpose databases and elastic pools resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes to the application logic. The feature is currently only available in the general purpose tier.
General availability (GA)
The following table lists the features of Azure SQL Database that have transitioned from preview to general availability (GA) within the last 12 months:
Azure SQL audit capabilities enable you you to audit operations done by Microsoft support engineers when they need to access your SQL assets during a support request, enabling more transparency in your workforce.
Learn about significant changes to the Azure SQL Database documentation.
You can now use the Maintenance Window feature if your Azure SQL Database is deployed to an availability zone. This feature is currently in preview.
Azure AD-only authentication
It's now possible to restrict authentication to your Azure SQL Database to Azure Active Directory users only. This feature is currently in preview. To learn more, see Azure AD-only authentication.
Query store hints
It's now possible to use query hints to optimize your query execution via the OPTION clause. This feature is currently in preview. To learn more, see Query store hints.
Change data capture
Using change data capture (CDC) with Azure SQL Database is now in preview. To learn more, see Change data capture.
SQL Database ledger
SQL Database ledger is in preview, and introduces the ability to cryptographically attest to other parties, such as auditors or other business parties, that your data hasn't been tampered with. To learn more, see Ledger.
The maintenance window feature allows you to configure a maintenance schedule for your Azure SQL Database, currently in preview. To learn more, see maintenance window.
SQL insights is a comprehensive solution for monitoring any product in the Azure SQL family. SQL insights uses dynamic management views to expose the data you need to monitor health, diagnose problems, and tune performance. To learn more, see SQL insights.