Microsoft SQL Server 2014 - Designing Solutions: High Availability

Overview/Description
In addition to Windows Azure SQL Database, Windows Azure enables you to configure and manage a VM dedicated to running an instance of SQL Server. High availability is the ability of a service to continue after a failure, and SQL Server 2014 has a number of options for implementing high availability. This course covers VMs on Windows Azure, and how to install, configure and manage SQL on a VM, and high availability in SQL 2014 including Windows Server Failover Clusters, AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups. This course is part of a series of Skillsoft courses that covers the objectives for exam 70-465. This exam is required for the certification MCSE: Data Platform.

Target Audience
Database professionals who design and build database solutions, create plans and designs for database structure, storage, objects and servers, and plan the environment in which the database solutions run

Prerequisites
None

Expected Duration (hours)
1.5

Lesson Objectives

Microsoft SQL Server 2014 - Designing Solutions: High Availability

• start the course
• recognize the function and features of Windows Azure virtual machines
• recognize how virtual disks are configured and stored on Windows Azure
• create a VM on Windows Azure
• connect to a VM that you have created on Windows Azure
• configure security for a VM on Windows Azure
• create a TCP endpoint on Windows Azure
• configure a VM with SQL Server on Windows Azure
• connect to a configured VM with SQL Server on Windows Azure
• recognize the options for SQL Server 2014 high availability and when each is appropriate
• recognize the characteristics of AlwaysOn Failover Cluster Instances (FCI) in SQL Server 2014
• recognize the characteristics of AlwaysOn Availability Groups in SQL Server 2014
• recognize log shipping features and functionality in SQL Server 2014
• configure log shipping using SQL Server Management Studio on SQL Server 2014
• configure log shipping using T-SQL on SQL Server 2014
• test a log shipping configuration that you have created in SQL Server 2014
• test a log shipping failover on a log shipping configuration that you have created in SQL Server 2014
• Configure high availability