SQL Friday #92 - Ed Pollack's Favourite New T-SQL in SQL Server 2022

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? Ever wish you could return the MAX or MIN value from a set of columns? 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!

About Ed Pollack
Ed Pollack has 20+ years of experience in database and systems administration, which has developed his passion for performance optimization, database design, and security. He has spoken at many SQLSaturdays, 24 Hours of PASS, and PASS Summit. This led him to organize SQLSaturday Albany, which has become an annual event for New York’s Capital Region. In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.