Simple play icon Course
Skills Expanded

SQL Server on Microsoft Azure IaaS - Optimizations & High Availability

by Mike McKeown

This course discusses advanced topics for optimizing SQL Server 2012 performance and availability on Windows Azure IaaS Virtual Machines.

What you'll learn

This course discusses advanced topics for optimizing SQL Server 2012 performance and availability on Windows Azure IaaS Virtual Machines. Topics include maximizing SQL Server disk performance within Azure storage, minimizing latency through Azure Virtual Network connectivity, properly securing administrative operations, and designing for high availability in case of failure. These design recommendations are key to correctly implementing configuration of SQL Server AlwaysOn Availability Groups, which are presented as the prime data replication option. As a part of AlwaysOn we discuss and show how to properly configure SQL Server VMs using Azure Availability Sets and Windows Server Failover Clustering (WSFC), SQL Server Availability Groups and Listeners to manage failover between VMs transparently.

About the author

Mike spent almost two decades with Microsoft in various roles such as Technical Evangelist, Trainer, Consultant, and Programming/Writer. Today Mike is a Microsoft MVP and Senior Cloud Solutions Architect with leading Microsoft partner Aditi Technologies. He has written many articles you can find on MSDN and MSJ. Microsoft recently published his whitepaper on High Availability and Disaster Recovery in Windows Azure. Mike is active in community groups and likes to blog about the Cloud at michaelmc... more

Ready to upskill? Get started