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.
Chart compares SQL Server database on-premises with SQL Server in Azure VMs, Azure SQL offerings, and Azure Synapse Analytics.
SQL Server database PaaS and cloud offerings provide alternatives to on-premises deployments, but choosing a destination includes trade-offs, and comparing costs may be difficult.
Illustration highlights key components of Azure Synapse Analytics, which are also the basis for pricing.
Azure Synapse Analytics is a multipurpose analytics and data warehouse service for users with T-SQL and Spark skills that can be a hub for analyzing a variety of data sources.