Welcome to this Microsoft solutions workshop on Azure SQL.
In this one day, hands-on, scenario-driven workshop, you'll learn how to translate your existing SQL Server expertise to Azure SQL including Azure SQL Database and Azure SQL managed instance. At the end of the day, you should have a foundational knowledge of what to use when, as well as how to configure, monitor, and troubleshoot the “meat and potatoes” of SQL Server in Azure: security, performance, and availability. You will learn about not only the “what”, but also the “how” and the “why”. You’ll also walk away with resources and tools so you can go as deep as your scenario requires.
This README.MD file explains how the workshop is laid out, what you will learn, and the technologies you will use in this solution.
(You can view all of the source files for this workshop on this github site, along with other workshops as well. Open this link in a new tab to find out more.)
After this workshop, you should be able to:
- Determine which Azure SQL deployment option (virtual machines, single databases, serverless databases, elastic pools of databases, hyperscale databases, and managed instances) and service tier should be used for scenarios that meet the needs of your application.
- Deploy, configure, monitor, and troubleshoot security, performance, and availability scenarios in Azure SQL using both familiar and new tools and techniques.
- Harness the “power of the cloud” including automation and intelligent capabilities of Azure SQL.
- Translate your existing SQL Server expertise to Azure SQL expertise.
The goal of this workshop is to train experienced SQL Server professionals.
Many organizations are faced with an aging or under-engineered data platform strategy. There's been a big trend of moving existing systems to the cloud, building new applications quickly with the cloud, and off-loading some of the on-premises costs. You need a plan for how to move some workloads to the cloud, and you need to understand how to set your organization up for success. You also need to understand how the role of a DBA or Data professional stays the same, and what changes you'll have to make. This workshop will prepare you to be successful in Azure.
The solution includes the following technologies - although you are not limited to these, they form the basis of the workshop. At the end of the workshop you will learn how to extrapolate these components into other solutions. You will also be provided with references to much deeper training provided.
| Technology | Description |
|---|---|
| Azure SQL virtual machines | Use full versions of SQL Server in the cloud without having to manage any on-premises hardware |
| Azure SQL Database | Managed SQL database service (includes single databases and elastic pools) |
| Azure SQL managed instance | Managed SQL Server service (includes single instance and instance pools) |
| SQL Server Management Studio (SSMS) | Graphical User Interface Management and Query Tool |
| Azure Data Studio (ADS) | Graphical User Interface to execute T-SQL queries, notebooks, and manage Azure Data services |
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 have a Microsoft Azure account with the ability to create assets.
This workshop expects that you understand and are experienced in working with, maintaining, and developing with SQL Server. Having some familiarity with the general structure of Azure will be helpful, but not required, before attending the workshop.
If you are new to these, here are a few references you may want to review prior to class:
- Pro SQL Server on Linux, Bob Ward: this book (available online) introduces SQL Server on Linux, but in the process walks through fundamental SQL Server topics
- SQL Server 2019 Workshop: this workshop will help you get up to speed on the latest innovations available in SQL Server 2019. You'll be able to directly apply much of that knowledge in this workshop
- Azure fundamentals learning path: this free, hands-on learning path will help you understand the fundamentals of Azure at a general level (not data focused)
A full prerequisites document is located here. These instructions should be completed before the workshop starts, since you will not have time to cover these in class. 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 workshop uses Azure SQL and the Azure platform, with a focus on Azure SQL Database and managed instance.
| Primary Audience: | SQL Server professionals tasked with translating their SQL Server skills to the cloud |
| Secondary Audience: | Data professionals, Architects, Developers, IT Pros, Data Engineers |
| Level: | 200-300 |
| Type: | Self-Paced or Instructor Led |
| Length: | 8 hours |
This is a modular workshop, and in each section, you'll learn concepts, technologies and processes to help you complete the solution.
| Module | Topics |
| 01 - Introduction to Azure SQL | Starting with a brief history of why and how we built Azure SQL, you’ll then learn about the various deployment options and service tiers, including what to use when. This includes Azure SQL Database and Azure SQL managed instance. Understanding what Platform as a Service (PaaS) encompasses and how it compares to the SQL Server “box” will help level-set what you get (and don’t get) when you move to the cloud. |
| 02 - Deploy and Configure | We’ll cover deployment, configuration, and other getting started related tasks for Azure SQL. You'll learn how you should plan for deployment, deploy, and verify your deployment, and how it compares to SQL Server. Then, you'll learn how deploying and configuring databases compares, plus some insights on loading data. |
| 03 - Security | Ensuring security and compliance of your data is always a top priority. You’ll learn how to use Azure SQL to secure your data, how to configure logins and users, how to use tools and techniques for monitoring security, how to ensure your data meets industry and regulatory compliance standards, and how to leverage the extra benefits and intelligence that is only available in Azure. We’ll also cover some of the networking considerations for securing SQL. |
| 04 - Performance | You’ve been responsible for getting your SQL fast, keeping it fast, and making it fast again when something is wrong. We’ll show you how to leverage your existing performance skills, processes, and tools and apply them to Azure SQL, including taking advantage of the intelligence in Azure to keep your database tuned. |
| 05 - Availability | Depending on the SLA your business requires, Azure SQL has the options you need including built-in capabilities. You will learn how to translate your knowledge of backup/restore, Always on failover cluster instances, and Always On availability groups with the options for business continuity in Azure SQL. |
| 06 - Putting it all together | In this module, we’ll validate your Azure SQL expertise with a challenging problem-solution exercise. We’ll then broaden your horizons to the many other opportunities and resources for personal and corporate growth that Azure offer. |
| 07 - Special Edition on Performance Troubleshooting | In this special edition module, you will learn how to detect and resolve common performance problems with Azure SQL. |
Next Steps
Next, Continue to Prerequisites