Advanced Internals and Troubleshooting Workshop for SQL Server

6th December 2011 - 7th December 2011

Who is it for?

This is an advanced workshop designed for IT Professionals who design, administer or maintain critical platforms based on SQL Server 2005, 2008 or R2. Participants should be spending or planning to spend most of their time working with SQL Server.

What you will learn

This two day workshop provides participants with the opportunity to learn about advanced SQL Server support topics in a very approachable way. Low-level SQL Server components are illustrated by following the “life of a query”. This helps to consolidate understanding of the architecture and provides a context from which to delve further. An iterative methodology is presented to help structure advanced concepts including:

Memory grants and cache usage
I/O considerations and diagnosing problems
SQL Server waits and wait types
Troubleshooting latch waits
Query plan optimisation and execution

The following tools are demonstrated throughout the workshop that are key to fast analysis and resolution:

PSSDiag and Perfstats for data collection
SQLNexus for data analysis

Full instruction is given in how to configure and run these tools in your own environment.

Key benefits

This workshop provides attendees with a comprehensive understanding of key SQL Server troubleshooting tools and methods. Attendees will benefit from:

Reduced time to resolution for production SQL Server problems
Reduced occurrences of issues through proactive troubleshooting
Established troubleshooting methodology

Cost: £990 +VAT

Trainer

Christian Bolton is the Technical Director for Coeo, a leading provider of SQL Server Managed Support and Consulting in the UK and Europe. He is a Microsoft Certified Architect, MCM and MVP for SQL Server, and lead author of Professional SQL Server 2008 Internals and Troubleshooting.

Location

LMG Training and Development
15 Risborough Street
Southwark
SE1 0HG

legal disclaimer

Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee. No refunds will be given to registrants who cancel less than 1 week before the beginning of the course or who fail to attend. Substitutions for paid registrants may be made at any time. However, written notice is required and for complete accuracy must include all pertinent changes for the substituting attendee.

In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

Chris Webb's Introduction to MDX course was well-run, informative and good value. It gave me a good understanding of the key principles and ideas and how to apply them to real world situations. It was great environment to learn in, with Chris giving excellent practical exercises and having the depth of knowledge to answer to any group questions.

Calvin Ferns

Consultant, Adatis

Chris has an incredible ability to explain even the most complex logic of Analysis Services and MDX in an easy and funny way. He is one of the best Microsoft Business Intelligence trainers I've ever met.