Welcome to a set of Microsoft solutions labs on using the Microsoft Azure SQL Platform. Using these labs, you'll gain a deep understanding on options for the latest SQL Server engine in Microsoft Azure and how you can use it to solve real-world challenges.
This README.MD file explains how the labs are laid out, what you will learn, and the technologies you will use to get hands-on experience.
(You can view all of the source files for this and other labs and workshops on this GitHub site. Open this link in a new tab to find out more.)
The information covered in these labs include the following technologies and topics - although you are not limited to these, they form the basis of the labs. At the end of the workshop you will learn how to extrapolate these components into other solutions. You will cover these at an overview level, with references to much deeper training provided.
| Technology/Concept | Description |
|---|---|
| Azure SQL Database | Covers the tools, processes and procedures for Azure SQL Database (Managed Instance, Singleton, and Elastic Pools) |
| Migrating SQL Server installations to Microsoft Azure | Explains the tools and processes to migrate on-premises SQL Server installations to the Microsoft Azure platform |
| Technology Selection Options | Teaches a set of criteria, tools and processes you can use to determine the best architecture for a given customer scenario on the Microsoft Azure platform |
You'll need a local system that you are able to install software on. The workshop demonstrations use Microsoft Windows as an operating system and all examples use Windows for the workshop. Optionally, you can use a Microsoft Azure Virtual Machine (VM) to install the software on and work with the solution.
You must also have a Microsoft Azure account with the ability to create assets.
These labs expect that you understand data structures and working with SQL Server and computer networks. Knowledge of SQL Server, Azure Data and AI services, is recommended. Solution templates are implemented using Azure services, development tools, and SDKs. You should have experience working with the Microsoft Azure Platform.
If you are new to these, here are a few references you can complete prior to class:
In addition, some of these labs are part of a bigger module on Azure SQL. If you're interested in the supplementary context, you can optionally review the documents and slides available.
A full prerequisites document is located here. These instructions should be completed before the labs start, since you will not have time to cover these in class if you are taking them in person. Remember to turn off any Virtual Machines from the Azure Portal and delete resources when the labs are finished when not taking the class so that you do incur charges (shutting down the machine in the VM itself is not sufficient).
The following roles will find this workshop useful. Others may also attend, as described in the Secondary Audience section.
| Primary Audience: | Solution Architects and Data Professionals tasked with implementing modern Data Systems, Big Data, Machine Learning and AI solutions |
| Secondary Audience: | Security Architects, Developers, and Data Scientists |
| Level: | 300 |
| Type: | In-Person |
| Length: | 2 hours for all labs |
A full prerequisites document is located here. These instructions should be completed before you start the Labs, since you will not have time to cover these in class if you are taking them in-person. Remember to turn off any Virtual Machines from the Azure Portal when not taking the class so that you do incur charges (shutting down the machine in the VM itself is not sufficient).
This is a modular set of labs, and in each section, you'll learn concepts, technologies and processes to help you complete the solution. The times shown below are for an instructor-led lab, although you may also take the modules in a self-paced fashion.
| Module | Time | Topics |
| Lab: Database Discovery and Assessment for Migrating to the Microsoft Azure SQL Platform | 30 minutes | In this hands-on lab, you will set up your environment with SQL Server 2008 R2 and Azure SQL, and perform assessments to reveal any feature parity and compatibility issues between the on-premises SQL Server 2008 R2 database and the managed database offerings in Azure. At the end of this lab, you will be better able to implement a cloud migration solution for business-critical applications and databases. |
| Lab: Migrating to Microsoft Azure SQL Managed Instance | 1.5 hours | In this hands-on lab, you will use the Azure Database Migration Service (DMS) to migrate the TailspinToys database from an on-premises SQL 2008 R2 database to SQL MI. At the end of the lab, you'll also explore some of the security and performance features available. |
