SQL Server Internals — Advanced Training

Page

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. The course 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 2012 and covers features specific to that version, but much of the information is relevant to SQL Server 2008 and SQL Server 2005 as well.

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
  • Query Tips and Techniques Troubleshooting Tools

Curriculum includes extensive demonstrations that illustrate the details of SQL Server internals as well as performance tuning techniques.

You can see the full course outline here.

Customized classes and shorter seminars are also available.

7 thoughts on “SQL Server Internals — Advanced Training

    • Hi Eamon… there’s a link to my schedule on the left… it’s the first link! Public classes are organized through my training partners and my schedule page has a link to the partner for registration info, etc. Thanks!

      • Hi Kalen . Thank you for the reply , apologies for the delay in acknowledging but I am head deep in your 2008 and 2012 books! Once I am done with these I will look to book a course nearest to NEW YORK. kind regards Eamon

  1. Hi Eamon… there’s a link to my schedule on the left… it’s the first link! Public classes are organized through my training partners and my schedule page has a link to the partner for registration info, etc. Thanks!

  2. Can I get access in c# to the XSN that is created by Snapshot Isolation to use for another purpose? I want to use it for Optomistic Concurrency Control across a user interaction. The alternative would be to create my own RowVersion column, but that seems redundate.

    Thanks. BTW I just ordered your 2012 internals book.

    • Hi Jim
      There is metadata that shows XSN numbers. It is called transaction_id in most cases. Look for DMVs in the sys.dm_tran_% family.
      Whether you can actually make use of it yourself, I really don’t know. I’ve never tried.

      ~Kalen

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s