SQL Know How

SQL Server Data Internals and Tuning

Kalen Delaney

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 2008 and cover features specific to that version, but most of the information is relevant to SQL Server 2005 and some is relevant to SQL Server 2000.

Topics to be covered include the following:

  • SQL Server Storage Metadata
  • Tools for exploring storage structures
  • Physical Storage Structures
  • Index Design and Tuning
  • Query Processing and Query Plans
  • Optimization and Recompilation
  • Query Tuning Tips and Techniques

Why should I attend?

This 3 day seminar is going to delve deeply into the structures of SQL Server and enable you as the DBA to optimise those structures. It will also show you, the database professional, how to optimise your querying of the database. This course is not for the faint hearted but if you can hang on for the ride then you will come out the other side with a much better knowledge of what is happening on your SQL Servers.

Course Length & Type

Three day instructor led seminar.

Location

5th - 7th November 2008 Rothamsted Manor, Harpenden

Conveniently located only 4 miles from the M1 and close to Harpenden railway station with good links to London. Rothamsted Manor is part of the larger Rothamsted Research facility, but retains a secluded and tranquil feel ideal for learning.

Events are held in The Great Drawing Room at the manor house itself. For full directions see Rothamsted Manor's How to Find Us guide.

The Great Drawing Room Rothamsted Manor & Conference Centre
Rothamsted Research
Harpenden
AL5 2JQ

Rothamsted Manor web site.

Timetable

09:00Arrive
09:00 - 09:15Welcome tea and coffee
09:15 - 10:45Seminar
10:45 - 11:00Tea and coffee break
10:45 - 12:30Seminar
12:30 - 13:00Lunch break, finger buffet
13:00 - 15:15Seminar
15:15 - 15:30Tea and coffee break
15:30 - 16:45Seminar
16:45Close

Kalen Delaney

Kalen Delaney

Kalen Delaney has worked with SQL Server for over 20 years, starting with employment with the Sybase Corporation in 1987. She worked at Sybase in technical support and training until 1992, when she became an independent trainer and consultant. Kalen now offers the most advanced SQL Server Internals training in the world, and you can read about her and her course on her website http://www.InsideSQLServer.com.

In addition to teaching and consulting, Kalen has been writing for SQL Server Magazine since its first issue, and has written or contributed to several advanced SQL Server books. Inside SQL Server 2005: The Storage Engine was published in October 2006, and her latest book Inside SQL Server 2005: Query Tuning and Optimization was published in September 2007. She is currently working on her next book, covering the internals of SQL Server 2008.

Events

Training Courses

SQL Server Integration Services (SSIS) Deep Dive - 4 Day Training Course