Commit f735ade

<p style="border-bottom: 1px solid lightgrey;"></p>

<h2><img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/textbubble.png?raw=true"><b> About this Workshop</b></h2>

Welcome to this Microsoft solutions workshop on *The Cloud Workshop for the SQL Professional*.

**THIS WORKSHOP IS NOT READY FOR USE. PLEASE CHECK BACK SOON FOR UPDATES.**

In this course you will learn how to solve modern data challenges with Azure SQL 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](https://github.com/microsoft/cloudworkshop/tree/master/cloudworkshop/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.

<p style="border-bottom: 1px solid lightgrey;"></p>

<h2><img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/checkmark.png?raw=true"><b> Learning Objectives</b></h2>

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.

<p style="border-bottom: 1px solid lightgrey;"></p>

<h2>

<img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/building1.png?raw=true"><b> Business Applications of this Workshop</b></h2>

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

<p style="border-bottom: 1px solid lightgrey;"></p>

<h2><img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/listcheck.png?raw=true"><b> Technologies used in this Workshop</b></h2>

<table style="tr:nth-child(even) {background-color: #f2f2f2;}; text-align: left; display: table; border-collapse: collapse; border-spacing: 2px; border-color: gray;">

<tr><th style="background-color: #1b20a1; color: white;">Technology</th> <th style="background-color: #1b20a1; color: white;">Description</th></tr>

<tr><td><i>SQL Server</i></td><td>Database Platform released and sold by Microsoft</td></tr>

<tr><td><i>SQL Server 2022</i></td><td>The lastest major version of SQL Server</td></tr>

<tr><td><i>Intelligent Query Processing</i></td><td>Automated query processing enhancements in SQL Server 2022</td></tr>

<tr><td><i>Microsoft Azure</i></td><td>Microsoft's cloud platform for computing, data, and applications.</td></tr>

<tr><td><i>Query Store</i></td><td>Built-in query performance execution statistics stored in a user database</td></tr>

<tr><td><i>Ledger for SQL Server</i></td><td>Built-in tamper evident data integrity using blockchain technologies</td></tr>

<tr><td><i>Polybase</i></td><td>Data Virtualization for data stored outside of SQL Server</td></tr>

<tr><td><i>SQL Server Management Studio (SSMS)</i></td><td>Graphical User Interface Management and Query Tool</td></tr>

<tr><td><i>Azure Data Studio<i></td><td>Graphical User Interface to execute T-SQL queries, notebooks, and manage SQL Server</td></tr>

</table>

<p style="border-bottom: 1px solid lightgrey;"></p>

<h2><img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/owl.png?raw=true"><b> Before Taking this Workshop</b></h2>

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.

<h3><img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/bulletlist.png?raw=true">

<b> Setup</b></h3>

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

- **NOTE for Linux or container users:** You will be able to go through many of the exercises using Linux as your client and SQL Server on Linux or as a container. 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.

- 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 (or you set your Azure VM with the following process: <https://learn.microsoft.com/azure/azure-arc/servers/plan-evaluate-on-azure-virtual-machine>)

- **SQL Server 2022 Evaluation Edition or Developer Edition General Availability** from (https://aka.ms/getsqlserver2022) with the Database Engine feature installed. If you use the Developer Edition you must enable the TCP protocol.

- Exercises in Module 5 require the PolyBase Query Service for External Data Feature (using all defaults). If you have installed SQL Server from an Azure Virtual Machine marketplace image, you will need to add the Polybase feature after deployment. **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 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.

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

- **Module 3** requires you to restore backups to go through different exercises. Download the backups for these from the following locations. Each exercise has instructions on how and when to restore these backups:

- 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](https://aka.ms/wwidw_mgf). If you have issues restoring this backup because it contains memory optimized tables there is a version of this backup that does not include memory optimized tables available at <https://github.com/microsoft/sqlworkshops-sql2022workshop/releases/download/v1.0/wwidw_mgf_std.bak>.

- 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](https://aka.ms/wwi_pspopt). If you have issues restoring this backup because it contains memory optimized tables there is a version of this backup that does not include memory optimized tables available at <https://github.com/microsoft/sqlworkshops-sql2022workshop/releases/download/v1.0/wwi_pspopt_std.bak>.

- 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](https://aka.ms/wwi_dop).If you have issues restoring this backup because it contains memory optimized tables there is a version of this backup that does not include memory optimized tables available at <https://github.com/microsoft/sqlworkshops-sql2022workshop/releases/download/v1.0/wwi_dop_std.bak>.

- Download **ostress.exe** by downloading RML utilities from https://aka.ms/ostress. Install using the RMLSetup.msi file that is downloaded. Use all defaults. ostress relies on SQLNCLI11. We have seen some situations where this may not be installed. If not, please install SQLNCLI11 from <https://www.microsoft.com/en-us/download/details.aspx?id=50402>.

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.

<p style="border-bottom: 1px solid lightgrey;"></p>

<h2><img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/education1.png?raw=true"><b> Workshop Details</b></h2>

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.

<table style="tr:nth-child(even) {background-color: #f2f2f2;}; text-align: left; display: table; border-collapse: collapse; border-spacing: 5px; border-color: gray;">

<tr><td style="background-color: Cornsilk; color: black; padding: 5px 5px;">Primary Audience:</td><td style="background-color: Cornsilk; color: black; padding: 5px 5px;">Data professionals looking to understand and use new capabilities of SQL Server 2022</td></tr>

<tr><td>Secondary Audience:</td><td>Developers, Architects, IT Pros, Data Scientists, and Data Engineers</td></tr>

<tr><td style="background-color: Cornsilk; color: black; padding: 5px 5px;">Level: </td><td style="background-color: Cornsilk; color: black; padding: 5px 5px0;">300</td></tr>

<tr><td>Type:</td><td>Self-Paced or Instructor Led</td></tr>

<tr><td style="background-color: Cornsilk; color: black; padding: 5px 5px;">Length: </td><td style="background-color: Cornsilk; color: black; padding: 5px 5px;">Full Day</td></tr>

</table>

<p style="border-bottom: 1px solid lightgrey;"></p>

<h2><img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/pinmap.png?raw=true"><b> Related Workshops</b></h2>

<p style="border-bottom: 1px solid lightgrey;"></p>

<h2><img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/bookpencil.png?raw=true"><b> Workshop Modules</b></h2>

<p style="border-bottom: 1px solid lightgrey;"></p>

<h2><img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/geopin.png?raw=true"><b> Next Steps</b></h2>

Next, Continue to <a href="./sql2022workshop/01_Introduction.md" target="_blank"><i>Introduction to SQL Server 2022</i></a>