Topic

Understanding SQL Server Execution Plans

Abstract

“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.

When

Thursday, 8/23/2018, 6:00 – 8:00pm

Where

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.

Google Map of 2500 Corporate Exchange Dr, Columbus, OH 43231

Information Control Company
2500 Corporate Exchange Drive
Columbus, OH 43231

Networking / Geek Dinner

O’Charley’s Restaurant & Bar
6285 Cleveland Ave
Columbus, OH 43231

Meeting Sponsor

ICC