/sqlworkshops-sql2022workshop

A workshop to learn about SQL Server 2022

Primary LanguageJupyter NotebookMIT LicenseMIT

Workshop: The SQL Server 2022 Workshop

A Microsoft Course from the SQL Server team

About this Workshop

Welcome to this Microsoft solutions workshop on SQL Server 2022 Workshop.

In this course you will learn how to solve modern data challenges with SQL Server 2022 using a hands-on lab approach.

This course is intended to be taken as a self-paced or instructor-led workshop. A supplement slide deck is 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 how SQL Server 2022 is the most cloud connected version ever.
  • Learn how built-in query intelligence allows your queries to run faster with no code changes
  • Learn how SQL Server 2022 has an industry proven database engine with new innovations in security, scalability, and availability.
  • See new data virtualization capabilities using REST APIs with data sources like s3 compatible providers and see how to backup and restore SQL databases with S3.
  • Learn how to enable new application scenarios using enhancements to the T-SQL language.

Business Applications of this Workshop

  • Enabling hybrid scenarios for disaster recovery, analytics, and security.
  • Ensure your application perform consistently and faster with no code changes.
  • Protect your data integrity with Ledger for SQL Server using blockchain technologies.
  • Save costs for maintenance of tempdb with new scalability improvements.
  • Reduce time for management of high availability with Contained Availability Groups.
  • Access information in data lakes without moving the data.
  • Use new S3 object storage providers for disaster recovery.
  • Maintain your skills for the T-SQL query language with new innovations.

Technologies used in this Workshop

Technology Description
SQL ServerDatabase Platform released and sold by Microsoft
SQL Server 2022The lastest major version of SQL Server
Intelligent Query ProcessingAutomated query processing enhancements in SQL Server 2022
Microsoft AzureMicrosoft's cloud platform for computing, data, and applications.
Query StoreBuilt-in query performance execution statistics stored in a user database
Ledger for SQL ServerBuilt-in tamper evident data integrity using blockchain technologies
PolybaseData Virtualization for data stored outside of SQL Server
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:

  • Before you attend the workshop, download all the scripts and files for hands-on exercises with one of the following methods:
  1. Clone the workshop repo with git clone https://github.com/microsoft/sqlworkshops-sql2022workshop.git. Using this method, the scripts will be under folders by module inside sqlworkshops-sql2022workshop\sql2022workshop. You can download git for windows from https://gitforwindows.org.
  2. Or download a zip file of the scripts from https://github.com/microsoft/sqlworkshops-sql2022workshop/archive/refs/heads/main.zip. You will need to expand the zip file after downloading. Using this method the scripts will be under folders by module inside \sqlworkshops-sql2022workshop-main\sql2022workshop.
  • Setup a machine or VM and install the software and supporting files 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 set of exercises. The Modules are designed in a sequence but you can use each of them one at a time at your own pace.

Setup

In order to complete the exercises in this workshop you will need the following:

  • A virtual machine or computer running Windows 10, Windows 11, Windows Server 2019, or Windows 2022 with at least 4 CPUs and 8Gb RAM. You will need Administrator rights on the virtual machine or computer. Exercise 3.2 is an advanced exercise in Module 3 that requires 8 CPUs and 24Gb RAM. It may be an optional exercise in some workshop delivery. Check with your instructor..
  • An Azure subscription is required for Module 2. Check the instructions in each exercise for specific permission requirements. Your instructor will indicate whether you will do Module 2 exercises. Exercises 2.2 and 2.3 in this module cannot be completed using an Azure Virtual Machine.
  • SQL Server 2022 Evaluation Edition General Availability from (https://aka.ms/getsqlserver2022) with the Database Engine feature installed.
    • Exercises in Module 5 require the PolyBase Query Service for External Data Feature (using all defaults). IMPORTANT: If you have an instance already on your computer or VM that has the Polybase feature enabled you will have to remove that feature from that instance or uninstall that instance. If this is not possible Module 5 does have T-SQL notebooks for you to view the experience.
    • You must configure SQL Server for mixed mode authentication. Read more how to do this at https://learn.microsoft.com/sql/relational-databases/security/choose-an-authentication-mode.
    • Named instances are supported but you may need to make some edits to some scripts in some modules where the exercise have you connect to SQL Server.
    • SQL Server on Linux or containers are not currently officially supported. However, many of the exercises use T-SQL so you still can go through many of the exercises using Linux or containers.
  • Install SQL Server Management Studio (SSMS) latest 18 or 19 build from https://aka.ms/ssms18 or https://aka.ms/ssms19. Several of the modules require features built only into SSMS. You may have a better experience in some modules with new features of SSMS 19.
  • Install Azure Data Studio (ADS) from https://aka.ms/azuredatastudio. T-SQL notebooks are used in this course.
  • For Exercise 3.0 in Module 3 you will need to download a customized version of the WideWorldImportersDW sample database from https://aka.ms/wwidw_mgf.
  • For Exercise 3.1 in Module 3 you will need to download a customized version of the WideWorldImporters sample database from https://aka.ms/wwi_pspopt.
  • For Exercise 3.2 in Module 3 you will need to download a customized version of the WideWorldImporters sample database from https://aka.ms/wwi_dop.
  • Download ostress.exe by downloading RML utilities from https://aka.ms/ostress. Install using the RMLSetup.msi file that is downloaded. Use all defaults.

Microsoft and any contributors grant you a license to the Microsoft documentation and other content in this repository under the Creative Commons Attribution 4.0 International Public License, see the LICENSE file, and grant you a license to any code in the repository under the MIT License, see the LICENSE-CODE file. All license files are found in the LICENSE directory.

Workshop Details

This workshop uses SQL Server 2022, SQL Server Management Studio, Azure Data Studio, Azure SQL Managed Instance, Azure Synapse Analytics, Azure Active Directory (AAD), and Microsoft Purview you to learn how you can solve new challenges with SQL Server 2022.

Primary Audience:Data professionals looking to understand and use new capabilities of SQL Server 2022
Secondary Audience:Developers, Architects, IT Pros, Data Scientists, and Data Engineers
Level: 300
Type:Self-Paced or Instructor Led
Length: Full Day

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.

ModuleTopics
01 - Introduction to SQL Server 2022 Learn how SQL Server 2022 solves challenges for the data professional
02 - Connect SQL Server 2022 to Azure Learn the how SQL Server is a hybrid data platform connecting to Azure services
03 - Accelerate performance with built-in query intelligence Learn how to get faster with no code changes
04 - Power your database with security, scalability, and availabilityLearn the new capabilities of the industry proven SQL Server engine
05 - Access new sources with data virtualization and object storage Learn the new data virtualization and object storage capabilities
06 - Enhance your application with new T-SQL capabilitiesLearn the new T-SQL enhancements for new application scenarios

Next Steps

Next, Continue to Introduction to SQL Server 2022

Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.

When you submit a pull request, a CLA bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.

Trademarks

This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.