Cloud Camp Quarterly

Session Highlight – How to Build a Multi-Tenant SaaS Application Using 60,000 Azure SQL Databases


Whoah! 60,000 databases – can you even imagine that?!?! This is Aidan Finn from MicroWarehouse again and this time I want to discuss this crazy session. When we picked the sessions for Cloud Camp, the title obviously stood out.

Anyone who works with Windows Server has become an accidental DBA. I dislike working with SQL Server – it takes so long to install, apply updates to, and there’s all that messing with upgrades, application integrations, and backups. Run SQL Server in a VM in the cloud has both higher consumption and operational costs – it costs more to run and own.

If you’re working with a new or a modern server application, then you have the platform alternatives of Azure SQL. For legacy workloads, there’s the Managed Instance alternative. With these platform versions of SQL Enterprise (yes!), Azure is cheaper to run (as low as around €4.13/month for a database) and cheaper to own. Azure starts to automatically backup your database a few minutes after you create it, and creates full/differential/transaction log backups with point-in-time restore. Transparent Data Encryption, which is non-disruptive, is enabled by default, and it’s easy to scale from one size to another. You get automatic performance analysis/recommendations, and enabling DR requires just a few clicks. You can see why I’ve been spending some time getting to know Azure SQL.

But you don’t get to know something really well until you do it extreme. I think that 60,000 databases qualifies as extreme. If you want to learn how to scale or manage the performance of a database or application in The Cloud then this is going to be the session for you. Henry Been, a Microsoft Ranger and DevOps & Azure Architect will be presenting this crazy session.


Henry Been
DevOps & Azure Architect | Speaker

Henry Been is an independent architect and developer from The Netherlands. He works with development teams to create great software.

Henry’s interests include the Azure cloud, DevOps, software architecture and the design and implementation of testable and maintainable software. Next to working in different companies, he is also one of the Microsoft ALM | DevOps Rangers


I plan on attending this session. It’s the sort of session where you can learn a lot and, to be honest, it’s relevant to a customer of one of our resellers!