Learn about important Azure product updates, roadmap, and announcements. Subscribe to notifications to stay informed.
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.
P15 offers 4000 Database Transaction Units (DTUs)—that’s twice as powerful as our P11 offering—with extremely fast transactional performance, real-time analytics, and up to 1 TB of storage.
You can use Azure Active Directory authentication to centrally manage user and group identities to authenticate with SQL Database and SQL Data Warehouse.
You can use Always Encrypted to help ensure that your sensitive data remains private and confidential while it's stored and queried in Azure SQL Database.
Azure SQL Database elastic pools are ideally suited for SaaS and line-of-business applications that need the performance, availability, and security isolation benefits of provisioning one database for each tenant or application.
SQL Database Advisor and the Performance dashboard are now generally available in the Azure portal.
Starting in mid-June 2016, in Azure SQL Database, the default compatibility level will be 130 instead of 120 for newly created databases.
We've expanded our geo-replication features by enabling Active geo-replication across Azure SQL Database Basic and Standard service tiers.
JSON functionalities are available in Azure SQL Database.
Simplify how you create, deploy, and schedule your data movement pipelines by using the click-through copy wizard for Azure Data Factory.
Azure Data Factory supports Australia regions for data movement.
Azure SQL Database Query Store collects detailed historical information about all queries, significantly reducing the time to diagnose and resolve performance issues.
Azure SQL Database Index Advisor helps you improve the performance of your databases by providing index recommendations based on your historical database usage.
Azure SQL Database Query Performance Insight helps you understand the impact of your query workload on database resource consumption.