SQL Server on Windows Azure IaaS - Optimizations & High Availability (2014)

MP4 | AVC 235kbps | English | 1024x768 | 15fps | 2h 01mins | AAC stereo 128kbps | 261 MB

Genre: Video Training

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.

│ sql-server-windows-azure-iaas-optimize.zip

│

├───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