PreCon Workshops

Welcome to the SQL Server 2022 Workshop, a complete hands-on interactive experience to learn all aspects of SQL Server 2022.
Prerequisites – Before you attend the workshop, download all the scripts and files for hands-on exercises with one of the following methods:

• 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.
• 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.

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 and is not required for attendees and is optional. You can use your computer, local virtual machine, or virtual machine in Azure. NOTE for Linux users: You will be able to go through many of the exercises using Linux as your client and SQL Server. However, some exercises require ostress.exe which is a Windows only program. You can also connect with a Windows client to SQL Server on Linux or a SQL Linux container.

+ You will not need an Azure subscription. Module 2 will be done through demonstrations only. Attendees can go through exercises in Module 2 after the workshop.

• SQL Server 2022 Evaluation Edition from https://aka.ms/getsqlserver2022 or Developer Edition (TCP protocol enabled) with the Database Engine feature installed. o Exercises in Module 5 require the PolyBase Query Service for External Data Feature (using all defaults). IMPORTANT: If you have an instance from a previous version of SQL Server 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.
  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.

• Install SQL Server Management Studio (SSMS) latest 18 or 19 build from https://aka.ms/ssms18 or https://aka.ms/ssms19. You may have a better experience in some modules with the new features of SSMS 19.
• Install Azure Data Studio (ADS) from https://aka.ms/azuredatastudio. T-SQL notebooks are used in this course.
• Download the following sample backup files. DO NOT restore these backups. You will do this as part of the exercises in the workshop.

  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.

 
More information
Keep up with the latest information on the workshop at https://aka.ms/sql2022workshop. Please send any questions about the workshop at bobward@microsoft.com or mamathews@microsoft.com.