SQL Server Internals Training

Explore the internal architecture of SQL Server

Kalen Delaney teaches the most advanced SQL Server courses in the world. Kalen has been working with SQL Server since 1987 and has since written many award-winning books. Her course “SQL Server Internals and Tuning” is designed for advanced SQL Server professionals who want to know how SQL Server really works, in order to take maximum advantage of its potential.

The SQL Server Internals training includes extensive demonstrations that illustrate the details of SQL Server internals, as well as tuning techniques. SQL Server Internals and Tuning is currently presented on SQL Server 2017 and covers features specific to that version, but much of the information is relevant to SQL Server 2014/2012/2008 as well.

Training Agenda

Three to five-day workshops on SQL Server Internals by Kalen Delaney. By knowing how the SQL Server engine executes queries, your team can write better queries and make better implementation decisions with SQL Server.

Pricing for the three-day workshop starts at $20,000 for the online version of the course. On-site training is available. As part of the training, we’ll use our DBMSys platform to perform our health check module to identify any potential issues against the server of your choice.

Topics covered include:

SQL Server Architecture and Metadata
Physical Storage Structures
Index Design and Tuning
Query Processing and Query Plans

Optimization and Recompilation
Concurrency Control: Locking, Blocking and Row Versioning
In-memory OLTP
Index and Query Tuning

Learn more

Blog posts

For a preview of the SQL Server Internals training, check out the past webinars presented by Kalen Delaney.

Webinar #1.1 SQL Server Metadata Overview Follow-up

22 September 2017 Kalen Delaney

The link to watch Webinar #1.1: Metadata Overview can be found here: Webinar #1 - SQL Server Metadata Overview Once you complete the registration information, you will get an email wit...

Webinar #1.2 SQL Server DMVs Follow-up

26 September 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 1.2 -- SQLServer DMVs files If you missed the session, or would like to watch the recorded version,...

Webinar #1.3 Metadata Internals Follow-up

3 October 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 1.3 — Metadata Internals If you missed the session, and/or would like to watch the recorded versi...

Webinar #2.1 Follow-up (Episode 4)

18 October 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides, demo and homework files here: Webinar 2.1 — Tables, pages and rows If you missed the session, and/or would like to watch th...

Webinar #2.2 Follow-up (Episode 5)

24 October 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.2 — Allocation Information If you missed the session, or would like to watch the recorded versi...

Webinar #2.3 Follow-up (Episode 6)

7 November 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.3 — Large Datatype Storage And here is the link to the video. Don’t miss the next webinar on ...

Webinar 2.4 Followup (Episode 7 - Clustered Indexes)

14 November 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.4 — Clustered Indexes If you missed the session, or would like to watch the recorded version, ...

Webinar 2.5 Followup (Episode 8 - Nonclustered Indexes)

21 November 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.5 — Nonclustered Indexes Because this week is a holiday week in the US, there is NO HOMEWORK! I...

Webinar 2.6 Followup (Episode 9 – Fragmentation)

28 November 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.6 - Fragmentation If you missed the session, or would like to watch the recorded session, the rec...

Webinar 2.7 Followup (Episode 10 – Partitioning)

5 December 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.7 - Partitioning If you missed the session, or would like to watch the recorded ses...

Webinar 2.8 Followup (Episode 11 – Compression)

12 December 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.8 - Data Compression If you missed the session, or would like to watch the recorded...

Webinar 2.9 Followup (Episode 12 - Columnstore Indexes)

19 December 2017 Kalen Delaney

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.9 - Columnstore Indexes If you missed the session, or would like to watch the recorded session, t...

Request a quote