Microsoft uses an internally written service called MSAsset to manage all Microsoft data center hardware around the world. MSAsset is used for tracking Microsoft’s servers, switches, storage devices, and cables across the company and requires 24/7 availability to accommodate break-fix requirements.
Database compatibility level 140 is now the default for new databases created in Azure SQL Database across almost all regions. As of this writing, there are already 539,903 databases in Azure SQL Database already running in compatibility level 140.
As of today, 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 created…
We observed that most customers fared well by simply replicating their on-premises approach.
We are announcing the official public preview of compatibility level 140 in Azure SQL Database.