Microsoft SQL Server 2014 - Designing Solutions: High Availability

Microsoft SQL Server 2014 - Designing Solutions: High Availability

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

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.8

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

Course Number:
md_ddsa_a04_it_enus

Expertise Level
Intermediate