The Art and the Science of Designing a Mission Critical SQL Server Solution
Explore the art and science of designing mission-critical SQL Server solutions in this 55-minute conference talk from PASS Data Community Summit. Delve into five basic archetypes for critical database systems and learn how to select the right SQL Server features for optimal implementation. Gain valuable insights on best practices, tips, and real-world advice for utilizing availability groups, clustered instances, and lesser-known availability features. Discover the importance of proper design over simply choosing an HA feature, and equip yourself with knowledge to become the hero of your next mission-critical deployment. Cover topics such as hardware redundancy, server redundancy, site redundancy, database redundancy, two-phase commit, scale-out strategies, partitioning, sharding, federated databases, virtualization, and cloud solutions.