Understanding SQL Server Execution Plans
“My SQL query is slow. Why?” Let’s take a look at the process of running queries against a SQL Server database. You’ll see what a query execution plan looks like, how to read them, and what a query operator is. More importantly, we’ll visit some problematic behavior, how to identify it via the query plan, and what you can do to speed up your code. Whether you run your SQL Servers in the cloud or are still grounded with local instances.
Speaker - Drew Furgiuele
Drew is a Senior Database Administrator at IGS, and has been working with the Microsoft Data Platform for over 15 years. When he’s not accidentally dropping tables in production, he enjoys helping developers and analysts write faster and more efficient queries, using PowerShell to automate himself, and messing around creating IoT devices, including trying to send SQL Server to the edge of space for the High Altitude SQL Server Project (HASSP).
Drew’s presented on topics for Brent Ozar’s online conference and training sessions, and he’s even a major contributor to the awesome open source PowerShell toolkit for DBAs: dbatools (https://dbatools.io/). Outside of work, he enjoys blogging, traveling, speaking, CrossFit, and hearing people try to pronounce his last name. He loves his dog more than he loves anything or anyone else, and isn’t ashamed of his Spotify playlist.
Thursday, 8/23/2018, 6:00 – 8:00pm
Please come join us at the ICC office which you can find just off the Cleveland Ave exit of 270 on the northeast side of town.
Information Control Company
2500 Corporate Exchange Drive
Columbus, OH 43231