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.
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.
- 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
- Azure SQL Database / Managed Instance
- Azure Database Migration service
- Azure Data Studio
- Azure Purview
- Your own Azure subscription with Owner access
- See the setup challenge for information on setting up your environment.
../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:
- This Old Data Warehouse
- Do You Even Synapse?
- Intro To OSS DB Migration to Azure OSS DB
- Modern Data Warehouse - COVID 19
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!