Building SaaS solutions on Azure SQL Database

on YouTube ↗48m

" summary

Azure SQL Database supports two practical SaaS patterns: elastic pools (single database per tenant) and hyperscale serverless (true multi-tenant). Elastic pools host up to 500 DBs per 2 vCore pool and can hit a floor of 88 cents per month per database using the DTU model; Dynamics 365 runs over 3 million databases with heavy automation and only a couple of DBAs. Hyperscale serverless scales to 128 vCores and 100 TB, auto-scales per-second billing, and performs ~20-minute restores for 100 TB. The Wingtip demo app and elastic jobs repository deploys the pattern end-to-end.

AI-written summary · about

" chapters (8)

1. 0:00Introduction to SaaS
2. 2:11Data management challenges
3. 6:24SaaS design patterns
4. 11:20Choosing your platform
5. 17:27Hyperscale architecture
6. 24:24Serverless scaling
7. 29:51Managing pools at scale
8. 35:52Demo and conclusion

" related talks

• 52mMore for less: Cost optimizing your Azure SQL databasesAditya Badramraju, Arvind Shyamsundar · SQLBits 2022
• 46mDatabase-Per-Tenant Architecture Using .Net Core and Azure SQL DatabaseErwin Staal · DevDays Europe 2022
• 52mMore for less: Cost optimizing your Azure SQL databasesAditya Badramraju, Arvind Shyamsundar · SQLBits 2024
• 17mAutomatic compute scaling with serverless for Hyperscale in Azure SQL DatabasesAdrian Marinica · dotnetdays 2023
• 01h 01mSQL Server in the Cloud - The available optionsDennes Torres · Global Azure 2021
• 51mAzure SQL Hyperscale Deep DiveDenzil Ribeiro, Paraic Nolan · SQLBits 2020
• 43mDatabase capabilities you need for your next awesome app Q&AAndrew Liu, Shawndell Elfring, Marc Shea, Ken Myers, Yoni Nijs, Nikisha Reyes-Grange, Michal Toiba · Microsoft Build 2023
• 18mHow to reduce your SQL Database costs on AzureSulamita Dantas, Leonardo Fonseca · Data Con LA 2021