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 lab 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:
- XXXXX
- Boost Database Performance with no application changes
- Ensure data is highly available to outages that can disrupt your business.
- Reduce costs of expensive data movement applications
- Learn how to extend the T-SQL language to meet the needs of your application.
- Learn tools and techniques to modernize and migrate to SQL Server 2022.
| 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 |
| Query Store | Built-in query performance execution statistics stored in a user database |
| 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 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:
- SQL Server 2022 Evaluation Edition
- Install SQL Server Management Studio (SSMS) latest 18 or 19 build 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. You may have a better experience in some modules with new features of SSMS 19.
- Install Azure Data Studio from https://docs.microsoft.com/en-us/sql/azure-data-studio/download. T-SQL notebooks are used in this course.
- The WideWorldImporters sample backup from https://aka.ms/WideWorldImporters
This workshop was built and designed for a computer or VM to run SQL Server with at least 8Gb RAM and 4 CPUs.
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.