Choosing the Right Data Store--An Overview of Azure Data Platform Choices
summary
Clear mapping of Azure options with limits and gotchas: choose VMs for legacy features and full control; Managed Instance supports cross-database queries, CLR and SQL Agent and fits lift‑and‑shift workloads; Azure SQL Database offers Hyperscale up to 100 TB and a serverless auto‑pause option but has cross‑db limits; Synapse is an MPP data warehouse priced for scale (DWU30,000 cited as >$300k/month) and is poor for row‑by‑row OLTP; Cosmos DB is multi‑API, globally writable but global writes and conflict resolution multiply cost.
AI-written summary · about
chapters (10)
- 0:00Welcome to Azure data stores
- 1:06Azure data platform overview
- 3:10Cloud service models and PaaS
- 5:15Azure SQL and variants
- 7:21SQL Server on Azure VMs
- 10:13SQL database service tiers
- 13:23Managed instance vs Azure SQL
- 14:28Synapse Analytics for warehousing
- 16:42Cosmos DB features and pricing
- 18:50Summary
related talks
51mIntroduction to Azure Data Platform
56mMigrate Databases to the Cloud - Why, How and Best Practices
52mMore for less: Cost optimizing your Azure SQL databases
20mChoosing between Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory
01h 01mLatest Innovations for SQL and Operational Databases for Developers
49mSQL Server on Azure VM - Configuring for Price-Performance
55mAzure SQL database, Azure Synapse Analytics, Azure Databricks?
01h 15mChoose Azure SQL Database and Learn What Every Developer Should Know