$149

Tune SQL Server Like a Guru!

Event Information

Share this event

Date and Time

Location

Location

UCSD Extension

6256 Greenwich Drive

San Diego, CA 92122

View Map

Refund Policy

Refund Policy

Refunds up to 1 day before event

Eventbrite's fee is nonrefundable.

Event description

Description

In this precon event we will cover a wide array of topics that form the backbone of my SQL Server performance analysis and tuning work. As a LONG-time relational engine consultant I have repeatedly found that the majority of clients I work with get amazing improvements by simply putting to use a fairly small collection of knowledge and tools. We will cover many topics, including:

  • Server, virtualization and database configuration
  • Optimization processes
  • Finding bad code to tune
  • Indexing
  • Understanding query plans
  • Improving design
  • Improving code (LOTS of this!!)
  • Profiler use and analysis (I use this ALL the time :-)
  • Extended events
  • Temp object usage
  • Waits and IO stall analysis
  • Performance enhancements in recent versions of SQL Server


We will look at these things from a variety of angles, while also covering many of the tips, tricks, tools, etc. I have collected in my almost 50,000 hours of working with and studying the SQL Server engine and database applications that run on it. I promise you will come away with lots of immediately-applicable information which you can take back to work and Tune Like A Guru!


Prerequisites: Preferably an intermediate-level knowledge/experience in SQL Server and TSQL and some familiarity with reading execution plans.



FAQs
What is the refund policy?
Once purchased, tickets are refundable up to the day prior of the event. Tickets are transferrable.

What does the ticket include?
The ticket for the event includes the following:

  • Access to Session Material for the Pre-Conference Workshop
  • Continental Breakfast, Lunch and Snacks are included. If you have any dietary restrictions please let us know at sqlsaturday909@sqlsaturday.com

Where on campus is the event located?
Detailed instructions on the exact location of the classroom for your event will be sent closer to the day of the event in addition to information on parking.

Does this register me for the SQL Saturday event the next day?
No. If you are planning on attending the main SQL Saturday event the next day, please be sure to register on the main SQL Saturday site: https://www.sqlsaturday.com/909/register.aspx.

What if I have Questions?
Please email us at sqlsaturday909@sqlsaturday.com.

Share with friends

Date and Time

Location

UCSD Extension

6256 Greenwich Drive

San Diego, CA 92122

View Map

Refund Policy

Refunds up to 1 day before event

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved