Understanding the internal workings of SQL Server doesn’t always immediately translate into better performance of your system or your queries, but the more you know about the way things work and the way they’re supposed to work, the better you’ll be able to track the reasons behind poor performance, and find a way to correct them.

In this session, Kalen shares what she means when she talks (and writes) about SQL Server internals, as well as why she thinks it is so important to anyone who wants to take their SQL Server skills to the next level.

You will learn about several different aspects of SQL Server internals, as well explore several sources of internals-related information. You will also learn about some tools that allow you to do your own explorations and answer many of your internals questions on your own.