SQL Immersion: Dublin 2010

Location: Microsoft Auditorium, EPDC2, Sandyford
Dates: June 28th – July 1st 2010

Cost:
DBA Track, 2 days (June 28th and July 1st) €1,299
Developer Track, 3 days (June 28th – June 30th) €1,499
Total Immersion, 4 days (June 28th – July 1st) €1,999

The rumours are true! SQL gurus Paul Randal & Kimberly Tripp return to Dublin this June to deliver their highly acclaimed 4 day SQL Immersion Course. They delivered this event to an Irish audience for the first time last Autumn and the feedback was exceptional. For those who attended last years course, they are offering new material in the form of two two-day deep-dives Performance Optimisation and Disaster Recovery.

This level 300 course provides a unique opportunity for Developers and DBAs who wish to focus on achieving excellence in SQL Server to learn directly from renowned world experts, Paul S Randal and Kimberly L Tripp. Delegates who attend will acquire essential knowledge that can quickly be applied in production to improve performance, reliability, availability and scalability.

Immersion Events are unique and individually planned seminars and workshops, with content specifically created by database-related industry experts. The training materials are customized to provide deep coverage enabling attendees to master the content. These RARE, small and intense events are the place to be for high quality SQL Server training.

The goal of an Immersion Event is to provide you with many ways of learning. In the course of an intense and focused week, we’ll ensure that nothing gets in your way. Our goal is to challenge you and offer you many different possible opportunities to explore and reinforce what you are learning – these are not limited solely to the classroom. We strive to enhance your learning experience through networking and mixed training formats:

Classroom lectures with printed course materials
Detailed and realistic demos
Free-form individual troubleshooting

No Ordinary Training Here – Our events are intense, technical and focused. Plan on finally having the time to focus on the areas of SQL Server that you have always wanted to explore, and bringing back detailed knowledge to enhance your company’s deployment – make it more reliable, more secure, more scalable and easier to support. Our SQL Server content is always current and relevant for the latest version, right to the latest Service Pack

Agenda:

Day 1 – SQL Server Internals

On-disk structures: how the data is stored
Records, pages, allocation bitmaps
Index internals: how the data is organised
Logging & recovery: how the data is protected
What is logging?
How Recovery works
How the transaction log is structured
Recovery Models

Day 2 – Designing for Performance

Choosing the RIGHT Data Type
Understanding data types
Character data, overflow & LOB
LOB considerations
Date and time data types
Heterogeneous data types
Sparse columns
Application inconsistencies in types
Table & Index Partitioning Strategies
Concepts / motivating factors in partitioning
SQL Server 2000+ Partitioned Views
SQL Server 2005+ Partitioned Tables
Partitioning Design Techniques Combined
Partitioned & Non-Partitioned Indexes
Implementing the Sliding Window Scenario

Day 3 – Indexing for Performance

Data Access
Data Access Patterns
Covering
Using INCLUDE (SQL Server 2005 +)
Using Filters (SQL Server 2008+)
Indexing Strategies
Indexing for AND
Indexing for OR
Indexing for JOINS
Indexing for Aggregates
Indexed Views (Overview)

Day 4 – Essential Database Maintenance

Data & Log file provisioning & management
Database layout considerations
Growing & shrinking
Instant initialization
Tembdb
Index & statistics maintenance
Using backup and restore
Consistency checking

The event offers a three track option to delegates – full immersion; Developer; and DBA – to facilitate a more tailored programme.

Option 1: (€1,999)
Full SQL Server Immersion (Entire 4 day programme)
Option 2: (€1,499)
Developer Track (First 3 days)
Option 3: (€1,299)
DBA Track (2 days – 1, 4)

Speakers

Paul S. Randal

In 2007, after 8.5 years on the SQL Server team, Paul left Microsoft to join his wife, Kimberly Tripp, running SQLskills.com and pursuing his passion for presenting and consulting.
Kimberly L. Tripp

Kimberly is a writer/editor for SQL Server Magazine; was a founding writer for T-SQL Solutions magazine; was a technical contributor for the SQL Server 2000 Resource Kit.