Select Page

General availability: Database compatibility level 150 in Azure SQL Database

With last week’s launch of SQL Server 2019, database compatibility level 150 moves out of public preview and into general availability status. With this change in status, the default compatibility level for new databases created in Azure SQL Database is ... continue reading
Migrating to Azure SQL Database with Zero Downtime for Read-Only Workloads

Migrating to Azure SQL Database with Zero Downtime for Read-Only Workloads

First published on MSDN on Feb 15, 2018 Special thanks to MSAsset engineering team’s Peter Liu (Senior Software Engineer), Vijay Kannan (Software Engineer), Sathya Muhandiramalage (Software Development Engineer II), Bryan Castillo (Principal Software Engineer) and Shail Batra (Principal Software Engineering ... continue reading

Compatibility Level 140 is now the default for Azure SQL Database

First published on MSDN on Jan 10, 2018 Database compatibility level 140 is now the default for new databases created in Azure SQL Database across almost all public regions. As of this writing, there are already 539,903 databases in Azure ... continue reading

Default compatibility level 140 for Azure SQL databases

First published on MSDN on Aug 24, 2017 As of this writing, the default compatibility level for new databases created in Azure SQL Database is 130. Very soon, we’ll be changing the Azure SQL Database default compatibility level for newly ... continue reading
2019-04-12_9-27-52.png

Intelligent Query Processing Q&A

In this blog post we’ll share intelligent query processing (IQP) customer questions and answers. This is intended to supplement the more in-depth coverage in the Books Online topic “Intelligent query processing in SQL databases”. If you have additional questions not ... continue reading