SQL Server on Microsoft Azure IaaS - Optimizations & High Availability
Pluralsight
Course Summary
This course discusses advanced topics for optimizing SQL Server 2012 performance and availability on Windows Azure IaaS Virtual Machines.
-
+
Course Description
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.
-
+
Course Syllabus
Introduction- 7m 3s
—Introduction 7m 3sData Management- 25m 12s
—Introduction 5m 26s
—Demo Geo-Replication 0m 55s
—Disk Best Practices 8m 12s
—Demo Deleting VHDs 1m 41s
—SQL FileGroups 5m 49s
—Demo SQLFileGroups 3m 6sConnections- 24m 2sVirtual Machine Management- 12m 25sHigh Availability Architecture- 16m 11sSQL Server AlwaysOn Availability Listeners- 18m 13sBringing it All Together- 15m 18sSummary- 3m 17s