August 2018 - Understanding SQL Server Execution Plans

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

[Read More]

July 2018 - Lightning Talks

Our July 26th, 2018 meeting will be an all Lightning Talk meeting and you can be one of the presenters! What are Lightning Talks? A Lightning Talk is a short 10 to 15 minute presentation on a single topic or idea. All you need to do is pick a topic... [Read More]

May 2018 - What's new in Visual Studio and C# 7

Topic What’s new in Visual Studio and C# 7 Abstract Visual Studio is a consistently great tool for developing applications on the Windows platform. In this talk we will discuss the productivity improvements added to Visual Studio 2017 that make it even better. Along with the improvements to Visual Studio,... [Read More]

April 2018 - Chasing the Top Performers in DevOps

Topic Chasing the Top Performers in DevOps Abstract DevOps is such an abused word. It’s even worse than the all-too-common “We do Agile.” So what does DevOps really mean, and what does a company look like that truly embraces DevOps? You know several of them: Amazon, Netflix, Target, Walmart, Nordstrom,... [Read More]

Subscribe to our mailing list