SQL Server 2022 - New and improved features for better queries

SQL Server 2022 brings multiple enhancements to Transact-SQL language.

Some extensions in the T-SQL are implementing new features at the SQL Server engine behind the scenes (like AUTO_DROP statistics). Other enhancements provide options to store and analyze data that changes over time, using time-windowing, aggregation, and filtering capabilities (like DATE_BUCKET, GENERATE_SERIES, FIRST_VALUE and LAST_VALUE).

In addition SQL Server 2022 presents new and improve JSON functions, a new window function clause and new functions like GREATEST, LEAST and STRING_SPLIT.

In this session we will dive into the Transact-SQL enhancements in SQL Server 2022 and we'll present some tricks and tips on how to improved our queries in SQL Server 2022 and how to implement the same solutions in older versions.

This session is 100% practical demonstration!

Ronen Ariely

Senior consultant and architect, data platform and application development.

Tel Aviv, Israel

Links

View Speaker Profile

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.