SQL Server Internals: It’s What’s For Dinner!
Presenter: Christina E. Leo
Ever wondered what happens behind the scenes when you query your SQL Server database? Well, believe it or not, it’s somewhat like asking for a special meal for dinner. During this session, I will use a chef’s analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the sometimes intimidating concepts of SQL Internals to a familiar idea, you will gain a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation. By the end of this session you will have a clear overview of what occurs behind the scenes when a query is presented to your database.
About the Speaker
Christina Leo has been working in the Information Technology industry for a little over thirteen years. She began her career in the IT world as a VB developer and has been working almost exclusively with SQL Server for the past two years. A puzzle solver by nature, her favorite part of database work is performance tuning. She is currently part of the leadership team for the Nashville SQL Server User Group, holds her MCITP in Database Development and Administration for SQL Server 2005, tweets frequently, and hopes to blog more consistently in 2011.