This event has ended

SQL Server Immersion: Internals, Performance, and Availability with Kimberly L. Tripp and Paul S. Randal

Data Education

Monday, March 29, 2010 at 9:00 AM - Friday, April 2, 2010 at 5:00 PM (EDT)

Cambridge, MA

SQL Server Immersion: Internals, Performance, and...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Attendee: SQL Server Immersion: March 29-April 2, 2010 Ended $3,100.00 $0.00

Share SQL Server Immersion: Internals, Performance, and Availability with Kimberly L. Tripp and Paul S. Randal

Event Details

Day 1: SQL Server Internals

·         On-disk structures: how the data is stored

o    Records, pages, allocation bitmaps

·         Index internals: how the data is organized

·         Logging and recovery: how the data is protected

o    What is logging?

o    How recovery works

o    How the transaction log is structured

o    Recovery models

Day 2: Designing for Performance

·         Choosing the RIGHT Data Type

o    Understanding data types

o    Character data, overflow and LOB

o    LOB considerations

o    Date and time data types

o    Heterogeneous data types

o    Sparse columns

o    Application inconsistencies in types

·         Designing for Performance
Table & Index Partitioning Strategies

o    Concepts/motivating factors in Partitioning

o    SQL Server 2000+ Partitioned Views

o    SQL Server 2005+ Partitioned Tables

o    Partitioning Design Techniques Combined

o    Partitioned and non-partitioned Indexes

o    Implementing the Sliding Window Scenario

Day 3: Indexing for Performance

·         Data Access

o    Data Access Patterns

o    Covering

o    Using INCLUDE (SQL Server 2005+)

o    Using Filters (SQL Server 2008+)

·         Indexing Strategies

o    Indexing for AND

o    Indexing for OR

o    Indexing for Joins

o    Indexing for Aggregates

o    Indexed Views (Overview – detailed if time permits)

Day 4: Essential Database Maintenance

·         Data and log file provisioning and management

o    Database layout considerations

o    Growing and shrinking

o    Instant initialization

·         Tempdb

·         Index and statistics maintenance

o    Fragmentation and its causes

o    Detecting and removing

·         Using backup and restore

o    Types of backups

o    Backup strategy

o    How restore works

o    Restore options

Day 5: Essential Database Maintenance

·         Consistency checking and disaster recovery

o    Page protection options

o    IO errors and monitoring

o    DBCC CHECKDB

§  Best practices

§  Interpreting output

o    Recovering from corruption

Have questions about SQL Server Immersion: Internals, Performance, and Availability with Kimberly L. Tripp and Paul S. Randal? Contact Data Education

When & Where


Le Meridien: Cambridge-MIT
20 Sidney Street
Cambridge, MA

Monday, March 29, 2010 at 9:00 AM - Friday, April 2, 2010 at 5:00 PM (EDT)


  Add to my calendar

Organizer

Data Education

Data Education is a full-service training company, specializing in courses targeting DBAs, developers, and business intelligence professionals. Data Education brings the experts in the database field to its students, from bestselling SQL Server authors to the nation’s premier business intelligence consultants.

  Contact the Organizer
Terms and Conditions: If Boston SQL Training cancels the course, you will receive a 100% refund. Registration is fully transferable. If you cancel your registration with more than 30 days notice, Boston SQL Training will refund the fee minus $250 for processing. If you cancel your registration with between 16 and 30 days notice, Boston SQL Training will refund 75% of the fee. If you cancel your registration with between 7 and 15 days notice, Boston SQL Training will refund 50% of the fee. Cancellations will not be allowed as of 6 days before the beginning of the course.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.