Azure updates

Learn about important Azure product updates, roadmap, and announcements. Subscribe to notifications to stay informed.

Products

    December 2016

    Dec 28

    Public preview: New T-SQL language features

    JSON functions, computed columns, and the CROSS APPLY operator are added in memory-optimized tables and natively compiled stored procedures in Azure SQL Database.

    Dec 28

    Public preview: New Japanese collations are available 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.

    Dec 7

    Query Store is turned on by default for Azure SQL Database

    Effective immediately, Query Store is turned on by default in all new and existing databases in Azure SQL Database (including elastic database pools).

    November 2016

    Nov 9

    General availability: In-Memory OLTP in Azure SQL Database Premium

    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.

    October 2016

    Oct 12

    General availability: Temporal tables in Azure SQL Database

    You can use temporal tables to track the full history of data changes directly in Azure SQL Database, without the need for custom coding.

    September 2016

    Sep 29

    Improved automatic tuning boosts Azure SQL Database performance

    Now customers can run their production workload in SQL Database for a day, and Advisor will provide relevant tuning recommendations to improve performance.

    Sep 6

    Major update to SQL Database Advisor makes database performance tuning much faster

    SQL Database Advisor is now significantly faster when tuning your database performance, requiring only a day of activity before producing the tuning recommendations.

    August 2016

    Aug 24

    General availability: New Azure SQL Database Premium performance level, P15

    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.

    Aug 4

    General availability: Azure Active Directory authentication for SQL Database and SQL Data Warehouse

    You can use Azure Active Directory authentication to centrally manage user and group identities to authenticate with SQL Database and SQL Data Warehouse.

    July 2016

    Jul 7

    General availability: Always Encrypted for Azure SQL Database

    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.

    May 2016

    May 12

    General availability: Azure SQL Database elastic pools

    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.

    May 12

    General availability: SQL Database Advisor and Performance dashboard

    SQL Database Advisor and the Performance dashboard are now generally available in the Azure portal.

    May 10

    Mid-June 2016 brings compatibility level 130 for new Azure SQL databases

    Starting in mid-June 2016, in Azure SQL Database, the default compatibility level will be 130 instead of 120 for newly created databases.

    April 2016

    Apr 29

    Active geo-replication available on all Azure SQL Database service tiers

    We've expanded our geo-replication features by enabling Active geo-replication across Azure SQL Database Basic and Standard service tiers.

    March 2016

    Mar 30

    Public preview: JSON in Azure SQL Database

    JSON functionalities are available in Azure SQL Database.

    Mar 11

    Code-free copy wizard for Azure Data Factory

    Simplify how you create, deploy, and schedule your data movement pipelines by using the click-through copy wizard for Azure Data Factory.

    Mar 8

    General availability: Azure SQL Database Query Store

    Azure SQL Database Query Store collects detailed historical information about all queries, significantly reducing the time to diagnose and resolve performance issues.

    Mar 8

    General availability: Azure SQL Database Index Advisor

    Azure SQL Database Index Advisor helps you improve the performance of your databases by providing index recommendations based on your historical database usage.

    Mar 8

    General availability: Azure SQL Database Query Performance

    Azure SQL Database Query Performance Insight helps you understand the impact of your query workload on database resource consumption.

    Explore