Skip Main Navigation
Page Content
This event has ended

Introduction to Performance Tuning with SQL Server 2012

Pittsburgh SQL Server User Group

Friday, September 13, 2013 from 9:00 AM to 4:00 PM (EDT)

Introduction to Performance Tuning with SQL Server 2012

Ticket Information

Ticket Type Sales End Price Fee Quantity
PreCon Price Ended $120.00 $3.99

Who's Going

Loading your connections...

Share Introduction to Performance Tuning with SQL Server 2012

Event Details

Introduction to Performance Tuning with SQL Server 2012

Have you always wanted to dig into performance tuning but wasn't sure where to start? During this pre-con you will be able to find out which SQL statements are causing your performance problems and you will be able to apply basic concepts to improve your general performance. You will learn how to implement and use a performance baseline to be proactive and keep yourself one step ahead of the game. We will cover bad developer practices that are constantly being repeated and show you how to fix them. We will also show you how to improve the performance of your troublesome queries when you cannot change the code. Finally, we will also cover best practices that can be applied to help performance on the database and instance settings level. 
 
John Sterrett is a database admin senior advisor for Dell, directly responsible for several mission-critical databases. Previously, he was a senior DBA focused primarily on performance tuning at a Remote DBA service company with over 200 SQL Server clients. He has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturday, and local PASS Chapter and Virtual Chapter meetings. He is a PASS Regional Mentor for the South Central US region, co-founded the West Virginia SQL Server User Group, and hosted the first and second SQLSaturday in West Virginia. He is a syndicated blogger at SQLServerPedia and SQLServerCentral.com and you can find his blog at http://johnsterrett.com
Konstantin Melamud is a SQL Server Team Lead for Remote DBA Experts. He works with over 200 customers on solutions within the SQL Server environment and leads code tuning team within Remote DBA experts. He is passionate about educating users on SQL Server by speaking at user groups, conferences, and labs.

Takeaways:
1. Find root cause to slow performance
2. Understand how to apply correct indexes to improve performance without modifying any code.
3. Identify bad T-SQL coding practices and be able to fix them
4. Implement general best practices to improve performance  

OTHER COURSE INFORMATION:

Course Hardware and Software Requirements:

Included with the seminar are a collection of tuning and monitoring scripts and a copy of all presentations.

Food:  Lunch will be provided at the event location.  Please contact the organizer is you require a vegetarian option.

 

Cancellation policy: no cancellations/refunds/exchanges allowed except if event is cancelled for any reason. Full payment of $120 is due at the time of registration.

Have questions about Introduction to Performance Tuning with SQL Server 2012? Contact Pittsburgh SQL Server User Group

When & Where


Microsoft Office
30 Isabella St
Pittsburgh, PA 15212

Friday, September 13, 2013 from 9:00 AM to 4:00 PM (EDT)


  Add to my calendar

Organizer

Pittsburgh SQL Server User Group

 The mission of the Pittsburgh SQL Server User Group is to provide an opportunity that will allow database developers, database administrators and all other IT professionals who work with databases to connect, share and learn for free. While everyone's shop might be unique the majority of the DBA's have similar projects and problems. We will allow all users the opportunity to share their experiences while they can also build their soft skills.

  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.