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!