Monthly updates for Azure SQL Database: November 2019
Now in general availability, a new configuration option, PAUSED_RESUMABLE_INDEX_ABORT_DURATION_MINUTES, has been added to ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL) for resumable online index operations.
Azure Active Directory (Azure AD) server principals (also known as Azure AD logins) for managed instance are now in general availability.
New metrics are now available to monitor Azure SQL Database backup storage consumption.
Support is now available in preview for T-SQL Data Definition Language (DDL) for Windows users and groups migrating from SQL Server databases to SQL managed instance with Azure Active Directory (Azure AD) authentication.
Managed instance backup storage billing went into effect November 1, 2019. Backup storage is free of charge up to sizes equal to the size of the provisioned storage, while any additional GB is charged at a fixed amount depending on region.
Transparent data encryption with customer-managed keys for Azure SQL Database managed instance is now generally available
Transparent data encryption (TDE) with customer-managed keys for Azure SQL Database managed instance is now generally available.
Azure Private Link, which provides private connectivity to Azure services, is now available in all regions.
Now in preview, M-series and Fsv2-series are new hardware options in Azure SQL Database specialized for workloads requiring very high compute or memory scale, or very fast CPU speed.
UTF-8 support is now generally available for Azure SQL Database, allowing more options to companies extending their businesses to a global scale, where the requirements of providing global multilingual database applications and services is critical to meet customer demands, and specific market regulations.
Now in preview, the Azure SQL Database experience in the Azure portal offers an entry point to create an app with PowerApps that’s automatically connected to a table in a given database. Quickly create low-code, robust user experiences for any device using data from your SQL Database tables.
Stream real-time data into a SQL Database table directly from the Azure portal using Azure Stream Analytics (now in preview).
Azure SQL Database serverless is a new compute tier that optimizes price-performance and simplifies performance management for databases with intermittent, unpredictable usage. Serverless automatically scales compute for single databases based on workload demand and bills for compute used per second.
Microsoft SQL Server 2019 is now generally available for purchase.