This event has ended

Query Performance Tuning in SQL Server by Grant Fritchey

SQL Saturday Louisville

Friday, June 20, 2014 from 9:00 AM to 4:00 PM (EDT)

Louisville, KY

Query Performance Tuning in SQL Server by Grant Fritchey

Ticket Information

Ticket Type Sales End Price Fee Quantity
Ticket   more info Ended $120.00 $0.00

Who's Going

Loading your connections...

Share Query Performance Tuning in SQL Server by Grant Fritchey

Event Details

Sometimes, just buying bigger and better hardware isn’t possible and you still have problems with database performance you have to deal with. Now what do you do? Since about 80% of the time, the problem lies in the T-SQL code, you could try tuning your queries. This all day session takes you through everything you need in order to tune your queries. We’ll start with establishing an understanding of how the optimizer works, move through methods for capturing query performance metrics and then step through methods of fixing common problems. We’ll take advantage of the tools offered by Microsoft such as the Dynamic Management Objects, Query Execution Plans and Extended Events. You’ll leave with a better understanding of how to identify and fix poorly performing queries that you can apply immediately on your own systems.

Logistics:

This day long workshop can be helpful to developers and DBAs using TSQL to write queries and help with performance tuning and troubleshooting.

  • It will cover versions 2005-2012, and briefly touch upon 2014.
  • Laptops are welcome but not necessary.
  • Course material will be provided in the form of soft copies which will be emailed/available for download.
  • Course fee covers snacks for breakfast and a boxed lunch. Parking in school parking lot is free.
  • This course needs a minimum of 10 people enrolled failing which it will be cancelled with full refund. Given paypal policies the refund will have to be as check if you pay for it 3 months ahead, and via paypal if after. We are unable to accept any other forms of payment other than via paypal.
  • No cancellations/refunds are allowed at this point.
  • Contact sqlsaturday286@sqlsaturday.com for any questions.

 

About the teacher:

Grant Fritchey works for Red Gate Software as a Product Evangelist. He writes articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard.
He has published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” Since 2009 he has been awarded as a Microsoft SQL Server MVP, and is one of the founding officers of the Southern New England SQL Server Users Group.
He is a top rated speaker at SQL Server conference at PASS and also works on part-time, short-term, off-site consulting contracts.



Have questions about Query Performance Tuning in SQL Server by Grant Fritchey? Contact SQL Saturday Louisville

When & Where



Indiana Weslyn University
1500 Alliant Avenue
Louisville, KY 40277

Friday, June 20, 2014 from 9:00 AM to 4:00 PM (EDT)


  Add to my calendar

Organizer

SQL Saturday Louisville

http://www.sqlsaturday.com/286/eventhome.aspx

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.