Database compatibility level 170 is now the default for new databases created in Azure SQL Database and SQL database in Microsoft Fabric across all public regions.
The alignment of SQL versions to default compatibility levels are as follows:
100: in SQL Server 2008 and Azure SQL Database
110: in SQL Server 2012 and Azure SQL Database
120: in SQL Server ...
Updated Jun 19, 2025
Version 3.0
theSQLSith
Microsoft
Microsoft