DPS 2020 Training Class - Query Tuning- by Erik Darling

5
Oct

DPS 2020 Training Class – Query Tuning- by Erik Darling

Visit DPS 2020 More Training Classes Book Now

Pre-Con Title

The Beginner’s Guide To Advanced Performance Tuning

Track(s)

Development

Tags

#PerformanceTuning #Index #Query #Plan #T-SQL

Level

Basic

Trainer/Speaker

Erik Darling

Abstract

You’re new to SQL Server, and your job more and more is to fix performance problems, but you don’t know where to start.

You’ve been looking at queries, and query plans, and puzzling over indexes for a year or two, but it’s still not making a lot of sense.

Beyond that, you’re not even sure how to measure if your changes are working or even the right thing to do.

In this full day performance tuning extravaganza, you’ll learn about all the most common anti-patterns in T-SQL querying and indexing, and how to spot them using execution plans. You’ll also leave knowing why they cause the problems that they do, and how you can solve them quickly and painlessly.

If you want to gain the knowledge and confidence to tune queries so they’ll never be slow again, this is the training you need.

Modules/Topics

In this course we’ll be talking about how to read query plans to spot problems, query writing anti-patterns, what makes a good index, how parameterization works, and how to make sure your queries are reliably fast.

Attendee Pre-requisite (if any)

1-2 years working with SQL Server, knows how to write basic queries, the difference between clustered and nonclustered indexes, and how to find query plans.

Is this class being recorded?

Yes. This class will be recorded and the registered attendee will get 12 months streaming access to the recorded class. The recordings will be available within 30 days of class completion.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

DPS 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

Book Now

Leave a Reply