I want to do a quick summary post of the many different types of Azure SQL Database available and I am not talking about elastic pools, VMs etc, more so the singleton type.
- Azure SQL Database (I call normal mode) – A choice between the DTU model (Basic, Standard and Premium) and vCore (General Purpose and Business Critical). Within this space there are two different architecture types used by Microsoft under the covers.
- Azure SQL Database Serverless – Automatically scales compute based on workload demand and bills for compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns.
- Azure SQL Database Hyperscale – vCore variant allowing Support for up to 100 TB of database size.
- Azure SQL Database Edge – Running on ARM and Intel architecture, Azure SQL Database Edge – now in private preview – brings the most secure Microsoft SQL engine to the edge. This productivity tool for edge computing combines new capabilities such as data streaming and time series with in-database machine learning and graph features.