SQL Server Features Components, Full Day HandsOn Labs

SQHOL01 Hands-On Lab: SQL Server Ground to Cloud

11/13/2022

9:00am - 6:00pm

Level: Intermediate

Bradley Ball

Sr. Azure Engineer for the Azure FastTrack CXP PG

Microsoft

Josh Luedeman

Sr. FastTrack Engineer, Azure Engineering – CXP

Microsoft

Buck Woody

Applied Data Scientist, Azure Data Services Team

Microsoft

In this one-day, hands-on workshop, you'll learn how SQL Server 2019 and Azure SQL help you solve real-world challenges. The Modules in this workshop lead you through conceptual and hands-on topics ranging from the newest technical features in SQL Server to its implementation in all the platforms it runs on. You'll learn not only specific technologies, but how to assemble them into a complete solution based on customer needs and requests.

You'll start by learning about the latest improvements in SQL Server 2019 and SQL Server 2022, the ways you can leverage SQL in Microsoft Azure (and how to get there) - all with a focus on how to extrapolate what you have learned to create other solutions for your organization. You'll end the day with a "What to Use When" module explaining how to create your own solutions.

This Workshop contains lecture and hands on lab work, and is particularly useful for Solution Architects, Data Architects, Application Architects, Technical Sellers, and Application Developers. A laptop, Microsoft Azure account, and experience with SQL is considered a prerequisite. There is also a set of computing resources you will need to provision, and an Azure Account (the free subscription is acceptable, if you wait to set it up until just before the class – do not set it up ahead of time, as it has a time limit). More detail will be provided on registration for the pre-requisites.

Attendee Requirements:

You must provide your own laptop computer (Windows or Mac) for this hands-on lab.

The Workshop: SQL Ground-to-Cloud workshop is taught using the following components, which you will install and configure in the sections that follow.

For this workshop, you will use Microsoft Windows as the base workstation, although Apple and Linux operating systems can be used in production. You can download a Windows 10 Workstation Image for VirtualBox, Hyper-V, VMWare, or Parallels for free here to use in the course. You must be able to install software on the system you will use for the course, so a Virtual Machine is often a good choice. This Workshop was built and designed for a server or VM to run SQL Server with at least 8Gb RAM and 4 CPUs.

Note that you will need to be able to run the Docker program on your workstation, so Nested Virtualization must be enabled on the system, or your physical workstation must be able to run Hyper-V images.

Other requirements include:

  • Microsoft Azure: This Workshop uses the Microsoft Azure platform to host various components, and optionally you can deploy a system there to act as a workstation. You can use a free Azure account, an MSDN Account, your own account, or potentially one provided for you, as long as you can create about $100.00 (U.S.) worth of assets.

Note that all work station set-up activities must be completed prior to class - there will not be time to perform these operations during the workshop.