Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019
Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019
Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019
Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019

Practical Real-World SQL Server Performance for Everyone

Written and Presented by Pinal Dave

Full Day Session  |  £350.00 (+VAT)


Speaker Profile

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4500 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands on experience he holds a Masters of Science degree and a number of database certifications.

In most organizations, accidental DBAs are the individuals who are often responsible for SQL Server Performance. In the real world when we face any performance problems, we do not have the luxury to open PowerPoint and study theory. What helps us during the time of crisis are handy scripts which help us fix our performance problems. In this quick paced, demonstration-oriented learning session, we will see how we can immediately help our application with performance if we just know what exactly to do.

This demo-oriented real-world storytelling session will answer the questions which DBA and Developers often wonder about Performance Tuning and Query Optimization. There are some problems which have straightforward answers, but there are some problems which are often invisible or needs attention without even a problem statement. Our 1-days long session will be divided into the following two major components.

Section 1: Server and Database Tuning and Optimization

In this section, we will primarily focus on all the basics to advanced concepts which are related to SQL Server and Database. There are quite many tips and tricks which are extremely easy to implement but not commonly known. We will discuss each of them in great details with examples.

We will be discussing many different topics along with the following important concepts:

  • Server Configurations
  • Database Configurations
  • Index Analysis and Optimizations
  • SQL Server Resource Wait Stats Analysis
  • SQL Server Best Practices
  • SQL Server upgrade Path
  • What's in Version Next?


Section 2: Query Tuning and Optimization

In this section, we will primarily focus on how to write efficient queries. Everybody knows how to read the basics of the execution plans but not everyone knows how to interpret them as an expert and how to get maximum out from them. We will learn how to write efficient and optimal queries with the help of execution plans.

We will be discussing many different topics along with the following important concepts:

  • Query Life Cycle
  • Joins and Queries
  • Functions and Queries
  • Multi CPU Queries
  • Data Types and Performance Impact
  • Advanced Execution Plans


End of Day Quiz and Bring Your Own Questions




Would you like to discuss your training requirements with me?
I'm always happy to help so, whatever your question, simply give me a call or send me a message and I'll get back to you as quickly as possible.
Copyright © 2018 London SQL Server Training Courses @ SQL Training | Website Design From Scott Heron