SQL Server 2008/2012 Architecture, Internals and Tuning

The following is a list of available SQL Server 2008/2012 Architecture, Internals and Tuning classes at ISInc. If you do not see the course you are interested in, please contact us. We can setup dedicated, online and onsite classes too! Minimum students required: 4, Maximum students: 15


The selected course is not currently active. Please contact an ISInc representative if you are interested in more information about this course.

Course Number: ISI-1079B

Description

This is an advanced 5-day instructor-led 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, as well as SQL Server 2012.

Topics to be covered include the following: 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 Level Versioning; Query Tips and Techniques; Troubleshooting Tools

This course includes extensive demonstrations that illustrate the details of SQL Server internals as well as performance tuning techniques. A reference CD including all of the demonstration scripts, as well as dozens of whitepapers and useful tools will be distributed at the end of the week.

This 5-day intensive seminar was developed by one of the world's leading experts in SQL Server internals, Kalen Delaney, author of the best selling book Inside SQL Server 2008 Internals, Inside SQL Server 2005:The Storage Engine and Inside SQL Server 2005: Query Tuning and Optimization. Kalen has been a columnist at SQL Server Magazine since the first issue, as well as writing for MSDN and TechNet Magazines. Kalen's courses and seminars on SQL Server Internals have successfully delivered at internal Microsoft training events and as on-site courses for premier Microsoft partners around the world.

Prerequisites

Before attending this course, students should have a good understanding and practical experience of SQL Server programming and administration. This is an advanced seminar designed for advanced SQL Server professionals.

List Price

$3995.00