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.
Mike spent almost two decades as an FTE with Microsoft in various roles such as Technical Evangelist, Trainer, Solution Integration Engineer, Consultant, and Programming/Writer. Today Mike is a Senior Cloud Solutions Architect with leading Microsoft Azure partner Aditi Technologies. He has been published many times on MSDN and MSJ and speaks at industry conferences.