SQL Server Alwayson Revealed

Peter Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011, and it sits alongside his array of MCTS, MCITP, MCSA and MCSE certifications in SQL Server from version 2005 onward. His passion for SQL Server shows through in everything he does, and his goal is that his passion for the technology will inspire others.

Chapter 1: HA and DR ConceptsLearn the concepts and terminology behind high availability and disaster recovery.* Level of Availability * Recovery Point Objective and Recovery Time Objective * Cost of Downtime * Classification of Standby Servers Chapter 2: Understanding HA and DR TechnologiesGain understanding of the various technologies that can be leveraged to obtain high availability and disaster recovery for their data-tier applications.* AlwaysOn Failover Clustering * Database Mirroring * AlwaysOn Availability Groups * Log Shipping * Combining Technologies Chapter 3: Implementing a ClusterImplement and configure a Windows failover cluster using Windows Server 2012 R2. The cluster will form the base to support either an AlwaysOn Failover Clustered Instance or AlwaysOn Availability Groups.* Building the Cluster * Configuring the Cluster Chapter 4: Implementing an AlwaysOn Failover Clustered InstanceLearn the differences between building a stand-alone instance and building an AlwaysOn Failover Clustered Instance. Also learn to add a node to an existing AlwaysOn Failover Clustered Instance.* Building the Instance * Adding a Node Chapter 5: Implementing AlwaysOn Availability GroupsImplement AlwaysOn Availability Groups for the purposes of both high availability and disaster recovery. Gain an insight into the impact synchronous Availability Groups can have on performance.* Implementing High Availability with AlwaysOn Availability Groups * Implementing Disaster Recovery with AlwaysOn Availability Groups Adding AlwaysOn Readable Secondary Replicas Chapter 6: Administering AlwaysOnPerform important administration tasks against AlwaysOn Availability Groups. Fail over to other nodes as needed, and monitoring ongoing operations. Also perform maintenance tasks against clusters, such as applying rolling patch upgrades and removing nodes.* Managing a Cluster * Managing AlwaysOn Availability Groups