Fox Valley Microsoft Data Platform

Next Meeting: Wed, Apr 05 2017

FoxPASS April 2017 Meeting

Language: English
Event Type: In-Person & Online
Online Meeting URL: https://meet.lync.com/sqlpass365-sqlpass/fox/RBA1M9D5
RSVPURL: None

Have you ever wondered, "How can I tune my workload without access to production hardware or data?" Derik Hammer is going to tell you how! 

When

iCal
UTC : Wed, Apr 05 2017 22:30 - 00:30
Event Time : Wed, Apr 05 2017 17:30 - 19:30 Central Daylight Time
Your Local Time: Wed, Apr 05 2017 22:30 - 00:30

Where

100 W Lawrence St, Suite 100 Appleton Center
Appleton, Wisconsin

Direction: None

Featured Presentation

Query Tuning without Production Data

Speaker: Derik Hammer, Senior Database Administrator Subway (Franchise World Headquarters, LLC)

Summary: The DBA is constantly ringing your phone complaining about why you did not include an index to support your new stored procedure. They have full access to production and do not understand how hard it is to tune a query with an underpowered development machine and a database which is less than 1/10th the size of the production equivalent. This session will cover query tuning techniques which will stop those phone calls and can be exercised on the worse of development environments. I will focus on query execution plan anti-patterns and faking out the optimizer.

About Derik: I am currently working as a Database Operations Team Lead with Subway World Headquarters. Server configuration, architecture, disaster recovery, high-availability, performance tuning, and maintenance automation form the bulk of my responsibilities. Almost all of my previous experience has resided firmly in the traditional / production DBA realm. I also spend as much time as I can spare attending SQL Server community functions. Currently chapter leader for FairfieldPASS.

Attachments

Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 

 

Brent Ozar Unlimited

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids