Azure SQL Managed Instance provides a PaaS offering with features and management options similar to SQL Server on-premises.
SQL Server 2022 introduces new availability and backup options that ease management and reduce risk but bring new limitations and changes.
SQL Server 2022 introduces new Azure-connected features that offer unique benefits, but they also bring additional costs, trade-offs, dependencies, and risks.
SQL Server 2022 introduces new Azure-connected features, but also important incremental updates to core performance, availability, and security features.
SQL Server 2022 can use Azure Active Directory authentication directly, supporting new forms of authentication and removing dependencies on Windows domain controllers.
Azure SQL Managed Instance introduces two Business Critical premium hardware options with higher performance, memory, and database sizes, designed for enterprise workloads.
SQL Server 2012 left Extended support in July 2022, but customers have multiple migration options and a support program to extend the life of SQL Server deployments.
Microsoft’s Intelligent Data Platform is a marketing effort to promote new Azure database and analytic features and the upcoming SQL Server 2022 version.
SQL Server remains Microsoft’s preferred structured data technology; however, several open-source Azure services now compete with SQL Server, and one is available on-premises.
The chart compares Microsoft’s on-premises and hosted database management offerings, their query languages, and the data types they support.
Sidebar explains the various data types and technologies used in Microsoft database management offerings.