Skip to content
Branch: master
Find file History
rgward Update
A few minor updates to Module 5 readme
Latest commit 42be432 Aug 12, 2019

Lab: SQL Server 2019 (CTP 3.2)

A Microsoft Course from the SQL Server team

About this Workshop

Welcome to this Microsoft solutions workshop on SQL Server 2019 Lab.

SQL Server 2019 is a modern data platform designed to tackle the challenges of today's data professional. SQL Server 2019 is not just an upgrade option from previous releases of SQL Server. Consider today's modern data challenges for a company called WideWorldImporters

Modern Data Challenges

SQL Server 2019 includes new capabilities that can solve these challenges. Consider the following infographic

SQL Server 2019 Solves Modern Data Challenges

SQL Server 2019 provides many new capabilities including:

  • Data Virtualization with Polybase and Big Data Clusters to reduce the need for data movement
  • Intelligent Performance to boost query performance with no application changes
  • Security enhancements such as Always Encrypted and Data Classification
  • Mission Critical Availability including Availability Groups on Kubernetes and Accelerated Database Recovery
  • Modern Development capabilities including Machine Learning Services and Extensibility with Java and the language of your choice
  • SQL Server on the platform of your choice with compatibility including Windows, Linux, Docker, Kubernetes, and Arm64 (Azure SQL Database Edge)

In this course you will learn some of the concepts and how to solve modern data challenges using a hands-on lab approach.

This course is intended to be taken as a self-paced lab in 1 to 2 hours but can be instructor-led to broaden the discussion or go deeper into specific subjects. Supplement slide decks are available for this course in the slides folder.

This course is designed for data professionals who have a basic working knowledge of SQL Server and the T-SQL language.

This README.MD file explains how the workshop is structured, what you will learn, and the technologies you will use in this solution.

Learning Objectives

When you complete this course, you will be able to:

  • Understand and use Intelligent Performance features to boost query performance with application changes
  • Understand and use Data Classification and Auditing to meet the needs of compliance and regulation standards.
  • Understand and use Accelerated Database Recovery to increase database availability.
  • Understand and use Polybase to connect and query other data sources with no data movement.
  • Understand and use Docker containers to deploy SQL Server Replication on Linux.

As part of taking this lab you are also learning about new capabilities in Azure SQL Database.

The following features in this lab also exist in Azure SQL Database:

  • Intelligent Query Processing
  • Data Classification and Auditing
  • Accelerated Database Recovery

In addition, SQL Server Polybase allows you to connect to Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB.

Business Applications of this Workshop

  • Boosting Database Performance with no application changes
  • Classifying data for industry or regulatory compliance
  • Ensuring data is highly available
  • Reducing costs of expensive data movement applications
  • Choosing different platforms for SQL Server and taking advantage of containerized applications.

Technologies used in this Workshop

Technology Description
SQL ServerDatabase Platform produced by Microsoft
SQL Server 2019Most current release of SQL Server currently in preview
Intelligent Query ProcessingAutomated query processing enhancements in SQL Server 2019
Query StoreBuilt-in query performance execution statistics stored in a user database
Data ClassificationBuilt-in data information classification with SQL Server with auditing
Accelerated Database RecoveryConstant Time Recovery, fast rollback, and aggressive transaction log truncation
PolybaseData Virtualization through external tables
LinuxOperating system used in Containers and Container Orchestration
DockerEngine for running and manage containers
SQL Server Management Studio (SSMS)Graphical User Interface Management and Query Tool
Azure Data StudioGraphical User Interface to execute T-SQL queries, notebooks, and manage SQL Server

Before Taking this Workshop

To complete this workshop you will need the following:

  • Clone the workshop using git from All the scripts and files in the labs are found in the sql2019 folder.

  • On Windows systems, you should use the following git syntax

    git clone --config core.autocrlf=false

  • Install the software as listed in the Setup section below

Each module of this workshop can be studied and used independently of each other or taken all as a single lab. The Modules are designed in a sequence but you can use each of them one at a time at your own pace.


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

This workshop was built and designed for a server or VM to run SQL Server with at least 8Gb RAM and 4 CPUs. You may be able to run this lab with less compute resources.

NOTE: If you run this lab from a virtual machine in Azure running Windows, and you want to use Module 5, you will need to enable nested virtualization. Read more at

Workshop Details

This workshop uses SQL Server 2019, SQL Server Management Studio, Azure Data Studio, Docker containers, and Azure SQL Database for you to learn how you can solve modern data challenges with SQL Server 2019.

Primary Audience:Data professionals looking to understand and use new capabilities of SQL Server 2019
Secondary Audience: Developers, Architects, and IT Pros
Level: 300
Type:Self-Paced or Instructor Led
Length: 1-2 hours (self-paced) 4 hours (Instructor Led)

Related Workshops

Workshop Modules

This is a modular workshop, and in each section, you'll learn concepts, technologies, and processes to help you complete the solution. This table is provided for you to see the list of modules in the workshop. You can use any module in any order you like but the preferred method is to proceed to Next Steps below to start the workshop.

01 - Intelligent Performance Learn the how SQL Server can boost your performance with no application changes
02 - Security Learn new security features of SQL Server 2019 such as Data Classification and Auditing
03 - Availability Learn new capabilities to make your SQL Server more available such as Accelerated Database Recovery
04 - Data Virtualization Learn how to use SQL Server as a data hub and reduce data movement using Polybase++
04 - Linux and ContainersLearn how to use Docker containers to deploy SQL Server Replication on Linux.

Next Steps

Next, Continue to Intelligent Performance

You can’t perform that action at this time.