My Favorite New T-SQL in SQL Server 2022

Edward Pollack

SQL Server 2022 adds a variety of new T-SQL functions, as well as some excellent upgrades to existing functions.

Want to generate a list on the fly without the need for a tally table? Tired of repeating window function syntax over and over? Wonder where GREATEST and LEAST have been all your life? How about more easily generating starting points for date parts?

This is a fast-paced, demo-filled party of new features that will save time, resources, and make for cleaner and happier code!