Live Chat Support

Microsoft Cloud Workshop: SQL Server Hybrid Cloud (40510G)

Microsoft Cloud Workshop: SQL Server Hybrid Cloud (40510G)

Overview

Duration : 1Day

In this workshop, you will work with a media publishing company to design a hybrid cloud disaster recovery solution. You will design the solution to handle large spikes in load and harden the security to include encryption of Payment Card Industry (PCI) data. Additionally, you will implement an archival strategy to keep databases sizes in check.

Objectives

At the end of this workshop, you will be better able to design a hybrid disaster recovery solution between an on-premises VMWare environment and Azure. In addition, you will design a SQL Server scale-out solution, protect database backups from local failures, archive cold data from an on-premises SQL Server, and perform end-to-end encryption on sensitive application data.

Course Outline

 

Module 1: Whiteboard Design Session - SQL Server hybrid cloud

Lessons

  • Review the customer case study
  • Design a proof of concept solution
  • Present the solution


Module 2: Hands-on Lab - SQL Server hybrid cloud

Lessons

  • SQL Backup solution
  • Implement a Data Archive Strategy with SQL Server Stretch Database
  • Build SQL Availability Group for Database Disaster Recovery
  • Configure Azure Site Recovery for Web Tier DR
  • Failing Over to the Disaster Recovery Site
None
Course ID:
40510G


Show Schedule for:

Please provide as much information as possible for us to help you with your enquiry.