Microsoft SQL Server 2022 was released on November 16, 2022. With that in mind, here is my list of Microsoft SQL Server 2022 Resources.
The reason that this is relevant is because it is a good idea to start becoming more familiar with the new features and improvements in SQL Server 2022 so you can decide whether it makes sense for your organization or not. If anyone has any additions that I have missed, I would like to hear about them. Thanks!
Microsoft SQL Server 2022 Resources
I put together this list of official Microsoft resources (so far) about SQL Server 2022. It is mainly focused on the core database engine. I plan to update this as new content is released.
What’s New in SQL Server 2022
Microsoft SQL Server Blog (newest to oldest)
These posts have been coming out on a fairly regular basis, with the latest one on December 1, 2022.
- Cardinality Estimation Feedback in SQL Server 2022 – Microsoft SQL Server Blog
- Memory Grant Feedback: Persistence and Percentile Grant – Microsoft SQL Server Blog
- Intelligent Query Processing: degree of parallelism feedback – Microsoft SQL Server Blog
- Backup and restore to URL for S3-compatible object storage – Microsoft SQL Server Blog
- Intelligent Query Processing: feature family additions – Microsoft SQL Server Blog
- Query Store hints in SQL Server 2022 – Microsoft SQL Server Blog
- Query Store is enabled by default in SQL Server 2022 – Microsoft SQL Server Blog
- Improve scalability with system page latch concurrency enhancements in SQL Server 2022 – Microsoft SQL Server Blog
- Improve scalability with Buffer Pool Parallel Scan in SQL Server 2022 – Microsoft SQL Server Blog
Data Exposed SQL Server 2022 Playlist (newest to oldest)
These are typically 15 to 20-minute videos that dive deeper than you might expect on a new feature. Microsoft was cranking these out pretty quickly for a while, but the last one was released on March 3, 2022.
- System Page Latch Concurrency Enhancements (Ep. 6) | Microsoft Learn
- SQL Server 2022: Introducing Buffer Pool Parallel Scan (Ep. 5) | Microsoft Learn
- SQL Server 2022 Storage Engine Capabilities (Ep. 4) | Microsoft Learn
- Intelligent Query Processing in SQL Server 2022 (Ep.3) | Microsoft Learn
- SQL Server 2022: The cloud-connected database (Ep.2) | Microsoft Learn
- Introduction to SQL Server 2022 (Ep.1) | Microsoft Learn
Nobody has ever come to me and said, “Hey Glenn, would you like to upgrade to the latest version of SQL Server?”. It has always been up to me to build the technical and business case for a version upgrade. Now is the time to start building your case! If you are a DBA managing older versions of SQL Server, your life will be easier on SQL Server 2022.
I wrote a longer post about Upgrading to SQL Server 2022 back in September. Microsoft has been strangely quiet (compared to what they did for past versions) about SQL Server 2022. My guess is that Microsoft marketing is responsible for this. I’m sure they have their own plans about how to generate interest in SQL Server 2022.
If you have any questions about this post, please ask me here in the comments or on Twitter. I am pretty active on Twitter as GlennAlanBerry. Thanks for reading!