To get to the next level of understanding your database, to reach an intimacy with query plans so that you really know what’s going on, to be able to address performance issues with confidence, you need to picture things differently. This workshop will demonstrate database internals without a computer, helping you learn what happens when queries are compiled and executed, helping you see what your plans are actually doing. The entire day will be done using pens rather than a keyboard, using the audience instead of a computer, and using your mind in a way that you may not have seen before.
We’ll get deep into data structures and query plans, into maintenance and troubleshooting. We’ll fix corruption and argue about heaps and clustered indexes. But above all, we’ll get to know SQL in a new and interactive way.