SQL Server 2022 is here!
Downloads
- Download SQL Server 2022
Docker containers: Ubuntu | RHEL
Management Studio 19
Blog posts and other resources
My favorite T-SQL enhancements in SQL Server 2022
I wrote about the new functions GREATEST/LEAST, DATE_BUCKET, and GENERATE_SERIES, as well as a change to STRING_SPLIT.
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.
Announcing JSON Enhancements in Azure SQL Database and SQL Server 2022
Read the "What's New" documentation