DeepSQL: How To Discover SQL Server Internals

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.

Attendees should have intermediate to advanced knowledge and experience with SQL Server, and be very curious to learn more about it.

Attendees will learn about:
- SQL Server system databases and objects
- Undocumented features and how to find them
- How to explore internals and use SQL Server features in novel ways