SQL Server 2022 Resources
SQL Server 2022 Resources
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
More obscure changes
Pre-release announcements
By: Aaron Bertrand
I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a husband, a father of two, a huge hockey and football fan, and my pronouns are he/him.