2014
Pluralsight
Mike McKeown
2h 1m
English

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.

01. Introduction
01. Introduction.mp4

02. Data Management
01. Introduction.mp4
02. Demo Geo-Replication.mp4
03. Disk Best Practices.mp4
04. Demo Deleting VHDs.mp4
05. SQL FileGroups.mp4
06. Demo SQLFileGroups.mp4

03. Connections
01. Connecting.mp4
02. Demo of ACLs.mp4
03. Administration.mp4
04. Demo of VNETs.mp4
05. Summary.mp4

04. Virtual Machine Management
01. Introduction.mp4
02. Demo Availability Sets.mp4
03. Load Balanced Endpoints.mp4
04. Demo Load Balanced Endpoints.mp4
05. Summary.mp4

05. High Availability Architecture
01. High Availability Architecture.mp4
02. Demo SQL AlwaysOn Availability Groups.mp4
03. Summary.mp4

06. SQL Server AlwaysOn Availability Listeners
01. Availability Listeners.mp4
02. Setup Availability Groups Listeners.mp4
03. Demo AlwaysOn Availability Group Listeners in Azure.mp4
04. Summary.mp4

07. Bringing it All Together
01. High Level Deployment.mp4
02. Demo Brewmaster.mp4
03. Demo Data Synchronization.mp4
04. Demo Failover.mp4
05. Summary.mp4

08. Summary
01. Summary.mp4

http://pluralsight.com/

Download File Size:251.07 MB

---