SQL Server in the Cloud - The available options
summary
Compares concrete Azure options: builds a SQL Server VM from the Marketplace (VM templates, BYOL licensing, auto-shutdown and managed identities), shows creating an Azure SQL Database (DTU vs vCore, serverless), and explains Managed Instance and SQL VM differences. Demonstration deploys a VM and creates a database; VM shows a quoted cost (~$0.61/hour) and a DB quote that falls from ~$236 to ~$5 when switching tiers. Warns that serverless triggers via Defender can spin up billable compute and recommends elastic pools for many small databases.
AI-written summary · about
chapters (24)
- 0:00Intro
- 2:05About me
- 3:22About the conference
- 4:03Happy hour
- 9:12Cloud architectures
- 11:18Bad movement to the cloud
- 12:51Lift and shift
- 14:58There is no cloud
- 15:55Application modernization
- 17:31Choosing a cloud provider
- 19:33Virtual Machines
- 20:53Virtual Machine Licensing
- 23:53Virtual Machine Demo
- 26:15Create Virtual Machine
- 28:03Create Virtual Machine Image
- 30:48Create Private Network
- 33:08Virtual Machine Identity
- 34:03Auto Shutdown
- 35:03SQL Server Settings
- 36:18Cost
- 38:08Azure SQL
- 46:23Azure Virtual Machine
- 49:33Azure SQL Database
- 55:13Configuration
related talks
18mHow to reduce your SQL Database costs on Azure
49mSQL Server on Azure VM - Configuring for Price-Performance
52mMore for less: Cost optimizing your Azure SQL databases
47mAzure SQL - more or/and less than SQL Server
50mSQL Server to Azure SQL: Performance and Availability
48mBuilding SaaS solutions on Azure SQL Database
59mWhat's new on Azure IaaS for SQL Server VMs
01h 01mLatest Innovations for SQL and Operational Databases for Developers