Workshop: SQL Ground-to-Cloud

A Microsoft Workshop from the SQL Server team

00 Prerequisites

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

NOTE: If you take this Workshop in person, you may be provided with a complete environment, or have different instructions. The invitation where you registered for the Workshop will be followed up with details for that environment, otherwise assume that you need to complete all of the following steps to complete the Workshop. The Labs in this Workshop are optional, all screenshots and Notebooks are provided for you to follow along if you cannot meet these requirements.

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 following activities must be completed prior to class - there will not be time to perform these operations during the workshop.

Activity 1: Set up a Microsoft Azure Account

You have multiple options for setting up Microsoft Azure account to complete this workshop. You can use a free account, a Microsoft Developer Network (MSDN) account, a personal or corporate account, or in some cases a pass may be provided by the instructor. (Note: for most classes, the MSDN account is best)

Unless you are explicitly told you will be provided an account by the instructor in the invitation to this workshop, you must have your Microsoft Azure account set up before you arrive at class.

Option 1 - Free Account

The free account gives you twelve months of time, and a limited amount of resources. Set this up prior to coming to class, and ensure you can access it from the system you will bring to the class.

Open this resource, and click the "Start Free" button you see there

NOTE: You can only use the Free subscription once, and it expires in 12 months. Set up your account per the instructions below, but ensure that you "Stop" any VM's in the Portal to ensure that you do not exceed the cost limits on this account. You will turn it off and on in the classroom per the instructor's directions.

Option 2 - Microsoft Developer Network Account (MSDN) Account

The best way to take this workshop is to use your Microsoft Developer Network (MSDN) benefits if you have a subscription.

Open this resource and click the "Activate your monthly Azure credit" button

Option 3 - Use Your Own Account

You can also use your own account or one provided to you by your organization, but you must be able to create a resource group and create, start, and manage a Virtual Machine and Azure SQL components.

Option 4 - Use an account provided by your instructor

Your workshop invitation may have instructed you that they will provide a Microsoft Azure account for you to use. If so, you will receive instructions that it will be provided.

Unless you received explicit instructions in your workshop invitations, you must create either a free, MSDN or Personal account. You must have an account prior to the workshop.

Activity 2: Set up your environment

In order to complete this workshop you need to install the following software:

Install SQL Server 2019 CTP 3.2 or later with all features, PolyBase Query Service for External Data enabled, and ensure you have 20GB of drive space available.
Install SQL Server Management Studio (SSMS) 18.2 or higher from https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms. Several of the modules require features built only into SSMS.
Install Azure Data Studio June 2019 or higher from https://docs.microsoft.com/en-us/sql/azure-data-studio/download. T-SQL notebooks are used extensively in this course.
Install Docker Desktop for Windows.
Download the WideWorldImporters sample backup from https://github.com/Microsoft/sql-server-samples/releases/download/wide-world-importers-v1.0/WideWorldImporters-Full.bak

Activity 3: Clone the Workshop

To complete this Workshop you will work from local files. You can either use the git program or a ZIP file, which you will save on your workstation.

Getting the Workshop files

You can download the repository holding these files using this link.
If you have git installed, The workshop git repository is: https://github.com/microsoft/sqlworkshops.git
git clone --config core.autocrlf=false https://github.com/microsoft/sqlworkshops.git

Activity 4: Set up your environment for Modules 4 and 5

Important Note! If you are being provided an account by your instructor (see Option 4 in Activity 1), you do not need to complete this activity.

Before arriving at the workshop, if you intend to complete 04-SQLServerOnTheMicrosoftAzurePlatform and/or 05-MigratingToAzureSQL, you must complete the prerequisites outlined here. Note that all screenshots are provided, so you can "audit" this part of the Workshop if you like.

Next Steps

Next, Continue to 01 - Introduction and Workshop Methodology.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!