What’s New for the DBA in SQL Server 2005
SQL Server 2005 introduces an arsenal of new features and enhancements for the DBA. This seminar focuses on the database implementation and maintenance aspects of the DBAs world, covering subjects such as high availability, database maintenance, schema management, performance, concurrency, T-SQL Enhancements and more...
Agenda:
o Partitioning
§ Partitioning in SQL Server 2000
· Motivation
· Implementation
· Limitations
§ Partitioning in SQL Server 2005
· Motivation
· Advantages
· Steps in Implementing Partitioning Tables/Indexes
· Index Alignment
· Adding/Removing Partitions
· Querying
· Collocated Joins
o Datatypes and Data Integrity
§ MAX Option for Variable Length Data Types
§ XML Data Type
§ BULK Rowset Provider
§ Referential Integrity Enhancements
o DDL Triggers
o Snapshot Isolation
o Database Mirroring
§ Database Mirroring – Described
§ Roles
§ Synchronous Database Mirroring
§ Asynchronous Database Mirroring
§ Auto Failover
§ Implementing Database Mirroring
§ Monitoring
o Database Snapshots
§ Database Snapshots, Described
§ Uses of Database Snapshots
§ Creating a Snapshot
§ Reverting Database to a Snapshot
o Files and Filegroups Enhancements
§ Instant File Initialization
o Backup & Restore
o Index Enhancements
§ Online Index Operations
§ INCLUDE Non-Key Columns
§ Other Index Enhancements
o Tools
o An Overview of T-SQL Enhancements
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.