Introduction to Execution Plans with Kathi Kellenberger

Agenda...

5:30pm - Social and Food sponsored by Deck Commerce

6:00pm - Announcements and Lightning Talk with Scott Spradlin on Why developers need to know about SQL Server Data Tools

Wouldn’t it be nice if all that SQL Server stuff was just source code you could stick into source control and easily track change history? And what about deploying it to multiple databases? What if the database isn’t even your responsibility but it’s like the wild west? A five minute into to SSDT and how we use it every day at work.

6:30pm - Introduction to Execution Plans with Kathi Kellenberger

Have you ever wondered why a T-SQL query that usually runs quickly suddenly slows down to a miserable crawl? Maybe there has been a change to the query, but maybe not. Unlike procedural code – where you tell the computer what to do – querying a database is different. You tell the database engine what you want, and the optimizer must figure out how to do it. Luckily, SQL Server provides a tool called the graphical execution plan to help you see what is going on under the covers. Does your query scan a billion row table to find one row? Does it take advantage of an index but then make thousands of trips to the actual table to grab one column? Attend this session to learn how to use graphical execution plans to understand how to make your queries more efficient.

Kathi Kellenberger is a Microsoft Data Platform MVP with 20 years of experience with SQL Server as a database administrator, developer, and consultant. She is the editor of Simple-Talk, Redgate’s online technical journal, and a volunteer with LaunchCode. Kathi has written several SQL Server books and created four Pluralsight courses. In her spare time, she loves spending time with family and friends, singing, cycling, and climbing the stairs of tall buildings.

7:30pm - Closing and head to West Port -- either Train Wreck or Fuzzy's