Introduction to Execution Plans with Kathi Kellenberger

Jul 30, 2018 · Maryland Heights, United States of America

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

Event organizers
  • St. Louis .NET User Group

    St. Louis' largest user group meeting since 2001. Covering topics focused on the software development lifecycle. We usually meet on the last Monday night of the month at a convenient location near you. The presentation usually starts at 6:00 pm but we have a social time beginning at 5:30 pm. If you have a venue where we could meet, or if you have topic ideas, feel free to send us a message!

    Recent Events
    More

Are you organizing Introduction to Execution Plans with Kathi Kellenberger?

Claim the event and start manage its content.

I am the organizer
Social
Rating

based on 0 reviews