MS-40510: SQL Server Hybrid Cloud


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 database sizes in check.



This workshop is intended for Cloud Architects and IT professionals who have architectural expertise of infrastructure and solutions design in cloud technologies and want to learn more about Azure and Azure services as described in the ‘About this Course’ and ‘At Course Completion’ areas.  Those attending this workshop should also be experienced in other non-Microsoft cloud technologies, meet the course prerequisites, and want to cross-train on Azure


Workshop content presumes 300-level of architectural expertise of infrastructure and solutions design.

Skills Gained

  • Design a SQL Server scale-out solution
  • Protect database backups from local failures
  • Archive cold data from an on-premises SQL Server
  • Perform end-to-end encryption on sensitive application data

Course outline

Module 1: Whiteboard Design – SQL Server Hybrid Cloud
• Review the customer case study
• Design a proof-of-concept solution
• Present the solution
• Prerequisites

Module 2: Hands-on Lab – SQL Server hybrid cloud
• 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


Click on the following link to see the current Course Schedule
Our minimum class-size is 3 for this course.
If there are no scheduled dates for this course, it can be customized to suit the time and skill needs of clients and it can be held online, at a rented location or at your premises.
Click on the following link below to arrange for a custom course: Enquire about a course date

Product Information

A hybrid cloud built with SQL server lets you move workloads from your datacenter to a hosting service provider’s datacenter (such as Windows Azure), without disrupting current operations and allowing you to maintain complete visibility into network infrastructure.

Additional Information

CANCELLATION POLICY – There is never a fee for cancelling seven business days before a class for any reason. Data Vision Systems reserves the right to cancel any course due to insufficient registration or other extenuating circumstances. Participants will be advised prior to doing so.