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.
Presented by Scott Klein at SQLBits XII