Learn about important Azure product updates, roadmap, and announcements. Subscribe to notifications to stay informed.
Now generally available, storage add-ons allow the purchase of extra storage without having to increase DTUs or eDTUs.
Use mssql-scripter, an open-source command-line interface, to generate database scripts in Azure Cloud Shell.
You can use mssql-scripter on Linux, macOS, and Windows to generate DDL and DML T-SQL scripts for database objects in SQL Server, Azure SQL Database, and Azure SQL Data Warehouse.
Azure SQL Data Sync provides unidirectional and bidirectional data synchronization capabilities between Azure SQL Database and SQL Server endpoints deployed anywhere in the world.
Azure SQL Database will be accessible only through the Azure portal from July 1, 2017.
SQL Analytics, a solution based on Azure Log Analytics, will help manage and monitor your Azure SQL databases. Get visibility into the health, performance, and usage of your SQL databases using dashboard views, with detailed reporting and alerting built into the solution.
All new Azure SQL databases will be encrypted with transparent data encryption by default, to make it easier for everyone to benefit from encryption at rest.
Azure SQL Database threat detection will provide a new layer of security by detecting suspicious activities that indicate potential security threats.
Azure SQL Database will introduce new security features in preview including Row-level Security, Dynamic Data Masking, and Transparent Data Encryption. Together, these will help customers further support organizational and industry compliance policies.
New T-SQL string functions are available in Azure SQL Database.
Azure SQL Database enables the direct load of files stored in Azure Blob storage by using BULK INSERT and OPENROWSET commands.
You can experience an interactive query experience directly in the Azure portal.
Clustered columnstore indexes support NVARCHAR(MAX), VARCCHAR(MAX), and VARBINARY(MAX) columns.
JSON functions, computed columns, and the CROSS APPLY operator are added in memory-optimized tables and natively compiled stored procedures in Azure SQL Database.
New Japanese collations _XJIS_140 and Japanese_Bushu_Kakusu_140 are available in Azure SQL Database. The new collations support Ideographic Variation Sequences that are used in the Japanese language.
Effective immediately, Query Store is turned on by default in all new and existing databases in Azure SQL Database (including elastic database pools).
In-Memory OLTP is generally available in all Azure SQL Database Premium databases and enables large performance gains for transaction processing. Columnstore indexes enable large performance gains for analytics queries.
You can use temporal tables to track the full history of data changes directly in Azure SQL Database, without the need for custom coding.
Now customers can run their production workload in SQL Database for a day, and Advisor will provide relevant tuning recommendations to improve performance.
SQL Database Advisor is now significantly faster when tuning your database performance, requiring only a day of activity before producing the tuning recommendations.