The SQL Server Performance Tasting Menu
April 23, 2019 6:00pm
You’re a DBA or Developer, and you’ve been using SQL Server for a few years.
You know there are different ways to make queries faster, but you’re not sure when to use them.
I’m Erik Darling, and I’ll be your sommelier for the evening.
Over several courses of delicious demos, I’ll show you the types of performance problems different tuning techniques pair well with, and which ones to avoid.
When we’re done, you’ll understand exactly what patterns to look for when you’re troubleshooting slow queries, and how to approach them.
You’ll have the secret recipe for gourmet queries.
Erik Darling started using SQL Server after a dispute with Excel over a vlookup. Since then he’s had some terribly boring DBA jobs, and been a consultant for Some Guy You’ve Never Heard Of™.
He enjoys public arguments with the optimizer and wine photography.
Important meeting information:
We meet at the offices of Wayfair, upstairs from the Copley Place Mall, at 4 Copley Place, Boston.
Due to building security at our meeting venue, attendees must be registered, and must present a valid photo ID to building security. Directions to the Wayfair offices can be found here.
Typical Meeting Format:
6:00pm – 6:30pm — food / beverages, networking and group discussion
6:30pm – 6:45pm — news, announcements, upcoming training opportunities
6:45pm – 8:15pm — guest speaker presentation