DeepSQL: How To Discover SQL Server Internals

If you've wondered how SQL Server does what it does, how it works on the inside, and how to figure out where to look for these things, this session will open the door to finding all the treasure under the SQL!
This session will cover SQL Server internals and demonstrate how to explore them for yourself. Get to know the inner workings of DMVs, system databases and objects.

Using regular SQL statements, in addition to other tools, this session will demonstrate how to plumb the depths of the entire SQL Server environment, including undocumented features, and how different components work together. If you've even wondered what's underneath sp_help and sys.objects, this session will show you.

Exploring SQL Server is not that difficult and can be very rewarding and fun! Find out about hidden DBCC commands and parameters! See how to find all references between system objects! Learn how underdocumented features can help you answer big questions or solve vexing problems.