Both my five-day class and my three-day class are available for private delivery for your organization anywhere in the world. If you have 6 or more people needing SQL Server Internals training, it is usually more cost-effective to have an on-site class. In addition, I offer almost a dozen different one-day seminars that you could can combine to create your own custom class.Read More
Kalen Delaney teaches the most advanced SQL Server courses in the world. Her 5-day 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.Read More
SQL Server Internals for Query Tuning provides the internal details you need to know to make sure you can get the best performance from your SQL Server queries.
This is an advanced course designed for advanced SQL Server professionals. The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as tuning techniques. This course will be presented on SQL Server 2017 and cover features specific to that version, but most of the information is relevant to SQL Server 2016 and SQL Server 2014, and some is relevant to earlier versions.Read More
If you don’t have enough people, or can’t take enough time away from your work day for a full class, but there are specific issues with SQL Server Internals or Query Tuning that on which you need focused information, you can sign up for a mentoring package. A minimum of 15 hours is required, and the schedule is up to you, based on my availability. Most of the mentoring will be done remotely, but an onsite initial visit is possible, if desired.Read More
In addition, I offer almost a dozen different one-day seminars that you can combine to create your own custom class.
For more information about scheduling a private delivery, please contact me.
— SQL Server Concurrency Control: Locking, Blocking and Row Versioning
— Care and Feeding of the Transaction Log
— SQL Server Data Storage Formats: Internals, Performance and Best Practices
— SQL Server Query Plans: Reuse or Recompile
— SQL Server Query Tuning
— SQL Server Query Plans: Tuning and Management
— SQL Server Indexes: Internals and Tuning
— SQL Server HEKATON: In Memory OLTP, Internals and Best Practices
— Index Magic: Rowstore, Columnstore and Nostore