SQL Immersion: Dublin 2010

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.

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 – This event is 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

See below for information on the course and its content

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. Save 15% when you register before April 30th, 2010.

Option 1: (€1,999)
Full SQL Server Immersion (4 days)June 28th - July 1st 2010
Option 2: (€1,499)
Developer Track (3 days) June 28th - June 30th 2010
Option 3: (€1,299)
DBA Track (2 Days) June 28th & July 1st 2010

Click here to register. For further information contact: Sandra@prodata.ie or call 01 2933883

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; authored the Indexing chapter for SQL Server 2008 Internals; and tackles real-world problems helping customers around the world.