SQLpassion Performance Tuning Training Plan

You are a developer and/or DBA and want to learn in a very compact way the essential things about performance tuning & troubleshooting SQL Server installations? In our free 6 month long SQLpassion Performance Tuning Training Plan we give you week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.

The SQLpassion Performance Tuning Training Plan

As a Thank-You for your signup, you will also receive a coupon code for the SQLpassion Online Academy where you will get 3 online training videos for the price of 2. If you are interested in a high quality face-2-face performance tuning training, please check out our famous SQL Server Performance Tuning & Troubleshooting Workshop, that we are running twice a year around Europe.

Month 1: Database Essentials

In the first month we lay out the foundation of SQL Server, and are talking about basic concepts in SQL Server. In the first 4 weeks we cover:

  • How SQL Server executes a Query
  • Data Pages – the Foundation of SQL Server
  • Extent Management
  • Data Page Restrictions
  • Month 2: Indexing

    Based on the knowledge you have acquired in the first month, the second month is everything about Indexing in SQL Server. With a good indexing strategy you can achieve a huge performance boost of your SQL Server workload. Over the 4 weeks we cover in detail:

  • Heap Tables
  • Clustered Indexes
  • Non-Clustered Indexes
  • Covering Indexes & the Tipping Point
  • Month 3: Execution Plans

    When we submit queries to SQL Server, we only describe through T-SQL statement what we want to get from SQL Server. But internally SQL Server has compile an Execution Plan. The Execution Plan is the access strategy how our requested data is accessed. If you have performance problems, you have to understand how to read and interpret the generated Execution Plan. In the 4 weeks you will learn the following about Execution Plans:

  • Understanding Execution Plans
  • Plan Caching
  • Recompilations
  • Parallel Execution Plans
  • Month 4: Statistics

    Statistics are the most crucial part of your SQL Server database. Statistics are used during the generation of the Execution Plan to determine how many rows are returned from your queries. If your Statistics are out-of-date, you will get sub-optimal Execution Plans from SQL Server. Therefore we dedicate a whole month to Statistics, so that you will know them afterwards very well. We will cover in that month:

  • Why Statistics are so important?
  • The Histogram & the Density Vector
  • Problems with Column Correlations
  • Cardinality Estimation in SQL Server 2014
  • Month 5: Locking, Blocking, Deadlocking

    By now your life as a developer/DBA was fine, because we have only executed with a single user queries against SQL Server. But what happens inside SQL Server if we run multiple users? In that case SQL Server have to acquire locks, and they will ultimately lead to blocking situations. And, if you are out of luck, the blocking situations can lead to deadlocks. To prepare you for these scenarios, we will cover in that month:

  • Transaction Isolation Levels
  • Optimistic Concurrency
  • Lock Escalations
  • Deadlocking
  • Month 6: Performance Monitoring & Troubleshooting

    Wow, you have finally reached the last month of the SQLpassion Performance Tuning Training Plan. You are on your way to be an expert about performance tuning. But you need one additional knowledge: how to monitor and troubleshoot SQL Server installations in the case of performance problems. Therefore we cover in the last month:

  • PAL Tools
  • Wait Statistics
  • TempDb
  • Database Maintenance
  • Take the challenge and signup for the SQLpassion Performance Tuning Training Plan to become an expert in performance tuning! Otherwise you will regret it!