I show how GENERATE_SERIES makes for easier set building, and decent alternatives while you're still stuck on older versions.
SQL Server 2022
I talk about ways to use wrapper functions to work around tedious syntax required by the new function, GENERATE_SERIES.
I continue looking at some of the changes in SQL Server 2022 that aren't on the marketing slides.
I warn about a cumbersome change to setup, where something is checked by default when it shouldn't be.
The first public preview of SQL Server 2022 is here! Read about my favorite T-SQL enhancements.
I take a look at some of the underlying changes in SQL Server 2022, as reflected in system metadata.