Hidden Gems of SQL Server from 2008 to 2022

2022

TL; DR

Small features - Huge benefit. This is what this training session all about. What features? Where and how to use them? How they can help us in queries tuning, troubleshooting, and other situations.

Session Details

SQL Server is a great product that is full of features. Each major version of SQL Server brought us new, more exciting features and kept doing this. And in each release, we had some "Killer" features like Parameter sensitive plan optimization, Intelligent Database, AlwaysOn, Linux Support, Windowing Functions, Columnstore Indexes, Transparent Data Encryption, In-Memory OLTP, etc. These features usually have a lot of attention, frequent discussions, and there are a lot of materials about them online. And at the same time, there are a lot of features introduced in each SQL Server release that have much less attention but are fascinating and valuable. I call them: "Hidden Features." And this will be the topic of this full-day training session. We will look at many hidden features of SQL Server introduced in each SQL Server release from SQL Server 2008 to SQL Server 2022 and check why and when they can be helpful for us.

3 things you'll get out of this session

Denis Reznik's other proposed sessions for 2026

Deadlocks in SQL Server: Understanding and Troubleshooting - 2026

True SQL Server Detective - 2026

Denis Reznik's previous sessions

What SQL Server database can tell us about application issues?

This session will be about database load patterns that show the application design issues and solutions to those issues.

Hidden Gems of SQL Server 2019

SQL Server 2019 is full of new features. Some of them are very interesting and useful, but unfortunately not well-known. So far.

Query Execution: Expectation-Reality

Sometimes this happens. What you expect not always what you received. In this session, we will look at a bunch of such situations.