Building multi-tenant SaaS applications in the cloud means balancing requirements such as ease of development, manageability, isolation of tenants, and cloud provider cost. Various design patterns such as sharding or single database per tenant have emerged as architectural blueprints for the data tiers of these applications. In this session, we will review the most prominent design patterns and discuss their pros and cons under different requirements. Last but not least, the session illustrates how to leverage the Elastic capabilities in Azure SQL Database to implement these design patterns.
Debra is a Principal Program Manager with a proven track record of successfully planning, designing, executing and delivering high quality software for 20+ years at Microsoft. Currently, Debra is delivering enterprise-class features for Azure SQL Database including our Elastic features. Debra is also a subject matter expert on database technologies and the application data-tier with a focus in the design and implementation of Business Continuity Disaster Recovery (BCDR), High-Availability, Data Protection and scale-out technologies of SQL Server and Azure SQL Database.