SQLBits 2014

Patterns & Practices for Scaling Windows Azure SQL Database

This session will discuss the recommended approaches and best practices for partitioning and scaling Windows Azure SQL Database, allowing you to fully leverage the managed relational database service and take advantage of massive scale-out scenarios.
Cloud computing is distributed computing which requires thoughtful planning and delivery – regardless of the platform choice. Because of the inherent complexity of running services at scale, it is important to understand the behavior and performance of the cloud platform in which a database is hosted to match business performance and scale expectations and requirements. This session will look at different scenarios, patterns, and best practices for building scalable databases in Windows Azure SQL Database. We’ll also look at scale-up vs. scale-out models, horizontal partitioning, and some tips for dealing with some of the complexities of cloud database scalability including identity generation, working with relationships, and fan-out queries.