Episode

Deployment options for Azure SQL Database

Data Exposed

Learn more about the deployment options for Azure SQL Database.

More information: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-technical-overview

  • [00:00] - Introduction
  • [00:41] - Deployment options in Azure SQL Database, including elastic pool, single database and Managed Instance
  • [03:33] - DTU service tiers (Basic, Standard, Premium)
  • [07:08] - vCore service tiers (General Purpose, Hyperscale, Business Critical)
  • [08:08] - General Purpose tier: Provisioned vs Serverless
  • [09:16] - Compute Generation: Gen4 vs Gen5
  • [10:01] - Decision points for Provisioned vs Serverless compute tiers
  • [13:25] - Saving money with Azure Hybrid Use Benefits
  • [13:58] - Business Critical tier and read scale-out
  • [15:42] - Hyperscale tier
  • [21:03] - Summary of deployment options
  • [22:17] - Finalizing the creation of a new Azure SQL Database
  • [23:02] - Summary and wrap-up