SQL Server 2022 is here!
Blog posts and other resources
My favorite T-SQL enhancements in SQL Server 2022
I wrote about the new functions
GENERATE_SERIES, as well as a change to
Overcome Challenges with GENERATE_SERIES
I showed how to get past a couple of minor nits with this new function.
T-SQL Windowing Improvements in SQL Server 2022
Itzik Ben-Gan talks about the new
WINDOW clause and the windowing
NULL treatment clause.
Additional T-SQL Improvements in SQL Server 2022
Itzik talks about
DISTINCT FROM and approximate percentile functions.