SQL Server 2005 Practical Guide to Availability and Recovery
This fast-paced, full-day workshop targets DBAs, IT Implementors, Architects and Developers who want to get a grasp of how to build a resilient system.
What gains will you get and into which pitfalls might you fall? Which impact performance, which impact recovery, what changes do you need to make to the database and/or the server to implement?
In this workshop, we will dive into some of the more important availability features including: Database Mirroring, Piecemeal Restore/Recovery, Online Partial Restore, Instant Initialization, Database Snapshots, Table and Index Partitioning, and Snapshot Isolation.
If you're a developer wanting to know what's possible or a DBA who needs to know what's critical and how to implement it, this is the place to be!
High Availability Configurations
• Recovering from Site Failure, Server Failure or Severe Database Failure
• Remote Mirroring
• Failover Clustering
• Database Mirroring
• Log Shipping
• Recovering from Isolated Hardware or other Isolated Database Failure/Corruption
• RAID
• Partial Database Availability
• Piecemeal/Partial/Online Database Restores
• Database Snapshots
Table Partitioning
• Concepts in Partitioning
• Shared resources
• Availability
• Access Patterns
• Partitioning Strategies
• Vertical
• Horizontal
• Implementation
• SQL Server 2005 Partitioned Tables
• Requirements
• Implementation
• The Sliding Window Scenario
• Partitioning and Recovery
• Partial Database Availability
• Piecemeal Online Restore
Understanding Isolation
SQL Server 2005 Snapshot Isolation
• Availability, What About Locking?
• ACID Properties
• Understanding Isolation Levels
• Controlling Isolation Levels
• Read Committed Using Statement-level Snapshot
• Transaction-level Snapshot Isolation
• Upgrade impact
• Potential Conflicts
M8: Database Mirroring
• Understanding Mirroring
• Concepts/Key Features
• Comparisons with Failover Clustering
• Configuring Mirroring
• Synchronous v. Asynchronous
• Using a Witness to Achieve High Availability
• Understanding Quorum
• Failover Configurations
• Best Practices
• Transparent Client Redirect
• High Availability Features with Mirroring
M9: Database Snapshots
• Understanding Database Snapshots
• Concepts/Key Features
• Uses
• Point In Time Analysis
• Recovering Data
• Combining with Database Mirroring
• How Database Snapshots Work
Agenda
======
Registration 9.00 Danishes
Seminar Start 9.30
Break 1 11.00 - 11.20 Muffins
Lunch 12.45 - 13.30 Sandwiches and Sausage rolls
Break 2 14.45 - 15.05 Cake
Q & A 16.45
Seminar End 17.00
To book a place fill out our registration form or call Tony Rogerson on 01582 768450 or email him at tonyrogerson@torver.net. There are discounts for block bookings.