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.
Azure SQL Database adds change data capture (CDC) capabilities to support more complex enterprise applications and brings the service closer to SQL Server parity.
Azure SQL Database increases database size limits on select performance tiers by 30%, potentially helping customers with large databases lower cost.
SQL Server 2012 leaves Extended support in July 2022; organizations need to migrate databases and applications or pay for Extended Support Updates to minimize risks.
Choosing the right Power BI platform requires understanding data management features and limitations on each platform.
Administrators may need to use both Azure Data Studio and SQL Server Management Studio to manage SQL Server deployments for the next few years.
SQL Database Ledger provides blockchain control features that are most like those used in a consortium blockchain.