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.
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 engine with new innovations in security, scalability, and availability.
- See new data virtualization capabilities using REST APIs with data sources like s3 and see how to backup and restore SQL databases with S3.
- Learn how to enable developers for new scenarios using enhancements to the T-SQL language.
- 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.
| Technology | Description |
|---|---|
| SQL Server | Database Platform released and sold by Microsoft |
| SQL Server 2022 | Most current release of SQL Server |
| Intelligent Query Processing | Automated query processing enhancements in SQL Server 2022 |
| Microsoft Azure | Microsoft's cloud platform for computing, data, and applications. |
| Query Store | Built-in query performance execution statistics stored in a user database |
| Ledger for SQL Server | Built-in tamper evident data integrity using blockchain technologies |
| Polybase | Data Virtualization through external tables |
| SQL Server Management Studio (SSMS) | Graphical User Interface Management and Query Tool |
| Azure Data Studio | Graphical User Interface to execute T-SQL queries, notebooks, and manage SQL Server |
To complete this workshop you will need the following:
- Clone the workshop using git from https://github.com/microsoft/sqlworkshops-sql2022workshop.git. All the scripts and files in the labs are found in the sql2022workshop folder.
- 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 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.
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 8Gbm RAM. You will need Administrator rights on the virtual machine or computer.
- An Azure subscription is required for Module 2. Check the instructions in each exercise for specific permission requirements.
- SQL Server 2022 Evaluation Edition RC0 or later Preview (https://aka.ms/getsqlserver2022) with the Database Engine feature installed. Exercises in Module 5 require the PolyBase Query Service for External Data Feature. In Module 5 you have the option to review Azure Data Studio notebooks instead of going through the exercises. You must configure SQL Server for mixed mode authentication.
- 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.
- The WideWorldImporters sample backup from https://aka.ms/WideWorldImporters. Many of the exercises have a script which by default restores the WideWorldImporters backup from the c:\sql_sample_databases folder. This sample backup is used throughout several modules
- Download the WideWorldImportersDW database backup from https://github.com/Microsoft/sql-server-samples/releases/download/wide-world-importers-v1.0/WideWorldImportersDW-Full.bak. This database is only used in Module 3.
- 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.
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 |
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.
| Module | Topics |
| 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 availability | Learn 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 capabilities | Learn the new T-SQL enhancements for new application scenarios |
| 07 - Summary | Get more resources and next steps for SQL Server 2022 |
Next, Continue to Introduction to SQL Server 2022
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.
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.