What The Hack - SQL Modernization and Migration

Introduction

SQL Server has come a long way! From OLTP to OLAP, on-premises to cloud, big data clusters to hyperscale – SQL Server has evolved in many ways. With that evolution comes complexity as organizations seek to take advantage of new features and cloud efficiency. This hack puts you (and your team) in the role of a SI (Systems Integrator), working with many clients to modernize their environments and applications.

Learning Objectives

In this hack, database administrators, developers who work extensively with SQL Server, and architects will migrate solutions to Azure. Several different scenarios are presented that are based on real-world scenarios, and in most cases, there are multiple ways to solve the problem given the requirements of each challenge. This hack also prepares participants for the DP-300 exam. While some challenges will touch on topics such as ETL/SSIS and modernizing data deployment (i.e., data ops), there are What The Hacks that focus extensively on these topics; see related hacks below.

Challenges

Challenge 0: Setup
Challenge 1: Migration
Challenge 2: Advanced Migration at Scale
Challenge 3: Performance & Tuning
Challenge 4: Security & Auditing
Challenge 5: High Availability & Disaster Recovery
Challenge 6: Data Governance

Technologies

Azure SQL Database / Managed Instance
Azure Database Migration service
Azure Data Studio
Azure Purview

Prerequisites

Your own Azure subscription with Owner access
See the setup challenge for information on setting up your environment.

Repository Contents

../Coach/
- Coach’s Guide for challenges
- Solution files for challenges
../Student
- Student’s Challenge Guide

For more in-depth work with Azure Synapse Analytics and Data Ops, see these hacks:

Learning Path Content

Contributors

Brian Hitney
Lalit Patel
Linda Zhang
Roberto Cavalcanti
Taygan Rifat

Thank you to the SQL Engineering team for many labs and samples that were leveraged in many of the challenges!