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.
Learning Objectives
Windows Azure VMs
- 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
Creating Databases on VMs
- 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
High Availability in SQL Server 2014
- 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
SQL Server 2014 Log Shipping
- 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
Practice: SQL Server 2014 Log Shipping
- Configure high availability