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.
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
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
Webinar #1.2 SQL Server DMVs Follow-up
Webinar #1.3 Metadata Internals Follow-up
Webinar #2.1 Follow-up (Episode 4)
Webinar #2.2 Follow-up (Episode 5)
Webinar #2.3 Follow-up (Episode 6)
Webinar 2.4 Followup (Episode 7 - Clustered Indexes)
Webinar 2.5 Followup (Episode 8 - Nonclustered Indexes)
Webinar 2.6 Followup (Episode 9 – Fragmentation)
Webinar 2.7 Followup (Episode 10 – Partitioning)
Webinar 2.8 Followup (Episode 11 – Compression)
Webinar 2.9 Followup (Episode 12 - Columnstore Indexes)