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.
Microsoft's database management landscape includes on-premises and cloud solutions with proprietary and open-source products that are designed for all enterprise data types and workloads.
SQL Server 2022, released to private preview, is expected to have a combination of Azure-connected features and traditional performance, security, and availability features.
Administrators may need to use both Azure Data Studio and SQL Server Management Studio to manage SQL Server deployments for the next few years.
Azure Synapse Analytics (formerly SQL Data Warehouse) adds new deployment options, analytics features, and data integration to deliver a consolidated, scalable analytics platform.
Azure Synapse Pathway (in preview) is data warehouse migration software that helps automate the conversion of on-premises and hosted data warehouses to Azure Synapse Analytics.