![](./graphics/microsoftlogo.png)

# Workshop: SQL Server 2022 Workshop

#### <i>A Microsoft workshop from the SQL Server team</i>

<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>     SQL Server 2022 enhancements to T-SQL</b></h2>

SQL Server 2022 enhances the developer experience with the following enhancements to the T-SQL language:

- Enhancements and new T-SQL functions to process JSON data.
- Enhancements and new T-SQL functions for core T-SQL scenarios.
- New T-SQL functions to process time series data.

**Watch this video** on T-SQL enhancements in SQL Server 2022 on Data Exposed:

<a href="http://www.youtube.com/watch?feature=player_embedded&v=5p8dezwwnzQ" target="_blank"><img src="http://img.youtube.com/vi/5p8dezwwnzQ/0.jpg" alt="Data virtualization in SQL Server 2022" width="400" height="300" border="10" /></a>

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

You will cover the following topics in this Module:

<dl>

  <dt><a href="#6-0">6.0 Process JSON data with T-SQL</a></dt>
  <dt><a href="#6-1">6.1 Explore new core T-SQL enhancements</a></dt>
  <dt><a href="#6-2">6.2 Process time series data with T-SQL</a></dt>
  <dt><a href="#6-3">6.3 Using bit manipulation T-SQL functions in SQL Server</a></dt>
  
</dl>

<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/pencil2.png?raw=true"><b><a name="6-0">     6.0 Process JSON data with T-SQL</a></b></h2>

SQL Server 2022 introduces new and enhanced T-SQL functions to work with JSON data including:

ISJSON<br>
JSON_PATH_EXISTS<br>
JSON_OBJECT<br>
JSON_ARRAY<br>

<h2><img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/point1.png?raw=true"><b><a name="activityiqp">     Exercise: Explore enhancements to process JSON data in SQL Server</a></b></h2>

Follow the instructions in the readme.md file in the **[sql2022workshop\06_TSQL\json](https://github.com/microsoft/sqlworkshops-sql2022workshop/tree/main/sql2022workshop/06_TSQL/json)** folder.

<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/pencil2.png?raw=true"><b><a name="6-1">     6.1 Explore new core T-SQL enhancements</a></b></h2>

SQL Server 2022 includes new and enhanced T-SQL functions and statements for core engine scenarios including:

GREATEST<br>
LEAST<br>
STRING_SPLIT<br>
TRIM functions<br>
DATETRUNC<br>
IS [NOT] DISTINCT FROM<br>
WINDOW clause<br>

<h2><img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/point1.png?raw=true"><b><a name="activityquerystore">     Exercise: Explore new core T-SQL enhancements</a></b></h2>

Follow the instructions in the readme.md file in the **[sql2022workshop\06_TSQL\surfacearea](https://github.com/microsoft/sqlworkshops-sql2022workshop/tree/main/sql2022workshop/06_TSQL/surfacearea)** folder.

<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/pencil2.png?raw=true"><b><a name="6-2">     6.2 Process time series data with T-SQL</a></b></h2>

SQL Server 2022 provides new T-SQL functions to process data time series types of data including:

DATE_BUCKET<br>
GENERATE_SERIES<br>
FIRST_VALUE<br>

<h2><img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/point1.png?raw=true"><b><a name="activityquerystore">     Exercise: Learn how to process time series data with SQL Server</a></b></h2>

Follow the instructions in the readme.md file in the **[sql2022workshop\06_TSQL\timeseries](https://github.com/microsoft/sqlworkshops-sql2022workshop/tree/main/sql2022workshop/06_TSQL/timeseries)** folder.

<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/pencil2.png?raw=true"><b><a name="6-3">     6.3 Bit manipulation with T-SQL</a></b></h2>

SQL Server 2022 provides new T-SQL functions to manipulate data at the bit level:

LEFT_SHIFT<br>
RIGHT_SHIFT<br>
BIT_COUNT<br>
GET_BIT<br>
SET_BIT<br>

<h2><img style="float: left; margin: 0px 15px 15px 0px;" src="https://github.com/microsoft/sqlworkshops/blob/master/graphics/point1.png?raw=true"><b><a name="activityquerystore">     Exercise: Learn bit manipulation using T-SQL with SQL Server</a></b></h2>

Follow the instructions in the readme.md file in the **[sql2022workshop\06_TSQL\bit](https://github.com/microsoft/sqlworkshops-sql2022workshop/tree/main/sql2022workshop/06_TSQL/bit)** folder.

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