High Availability

SQL Server 2014    |    Expert
  • 16 videos | 1h 32m 8s
  • Includes Assessment
  • Earns a Badge
Rating 4.3 of 6 users Rating 4.3 of 6 users (6)
Windows Azure lets you configure and manage a dedicated VM to run an instance of SQL Server. Discover VMs on Windows Azure; how to install, configure and manage SQL Sever on a VM; and high availability options in SQL Server 2014.

WHAT YOU WILL LEARN

  • Recognize the function and features of windows azure virtual machines
    Recognize how virtual disks are condifured 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

IN THIS COURSE

  • 7m 32s
    After completing this video, you will be able to recognize the function and features of Windows Azure Virtual Machines. FREE ACCESS
  • 4m 32s
    After completing this video, you will be able to recognize how virtual disks are configured and stored on Windows Azure. FREE ACCESS
  • Locked
    3.  Windows Azure Creating a VM
    8m 28s
    In this video, you will learn how to create a VM on Windows Azure. FREE ACCESS
  • Locked
    4.  Connecting to an Azure VM
    6m 59s
    In this video, learn how to connect to a VM that you have created on Windows Azure. FREE ACCESS
  • Locked
    5.  Windows Azure VM Security
    5m 13s
    Learn how to configure security for a VM on Windows Azure. FREE ACCESS
  • Locked
    6.  Create an Azure TCP Endpoint
    2m 57s
    Learn how to create a TCP endpoint on Windows Azure. FREE ACCESS
  • Locked
    7.  SQL Server on Azure VM
    7m 58s
    In this video, learn how to configure a VM with SQL Server on Windows Azure. FREE ACCESS
  • Locked
    8.  Connect to SQL on Azure VM
    3m 55s
    In this video, find out how to connect to a VM with SQL Server that is configured on Windows Azure. FREE ACCESS
  • Locked
    9.  High Availability Options
    7m 55s
    Upon completion of this video, you will be able to recognize the options for high availability in SQL Server 2014 and when each is appropriate. FREE ACCESS
  • Locked
    10.  AlwaysOn FCI
    6m 40s
    After completing this video, you will be able to recognize the characteristics of AlwaysOn Failover Cluster Instances in SQL Server 2014. FREE ACCESS
  • Locked
    11.  AlwaysOn AG
    3m 7s
    Upon completion of this video, you will be able to recognize the characteristics of AlwaysOn Availability Groups in SQL Server 2014. FREE ACCESS
  • Locked
    12.  Log Shipping Overview
    3m 40s
    After completing this video, you will be able to recognize the log shipping features and functionality in SQL Server 2014. FREE ACCESS
  • Locked
    13.  Log Shipping in SQL Studio
    8m 12s
    During this video, you will learn how to configure log shipping using SQL Server Management Studio on SQL Server 2014. FREE ACCESS
  • Locked
    14.  Log Shipping Using T-SQL
    3m 35s
    During this video, you will learn how to configure log shipping using T-SQL on SQL Server 2014. FREE ACCESS
  • Locked
    15.  Test Log Shipping
    4m 39s
    In this video, learn how to test a log shipping configuration that you have created in SQL Server 2014. FREE ACCESS
  • Locked
    16.  Test Log Shipping Failover
    6m 45s
    In this video, you will test a log shipping failover on a log shipping configuration that you have created in SQL Server 2014. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.6 of 244 users Rating 4.6 of 244 users (244)
Rating 4.6 of 351 users Rating 4.6 of 351 users (351)
Rating 4.6 of 212 users Rating 4.6 of 212 users (212)