Friday, 22 September 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Full day seminar: What’s New for the DBA in SQL Server 2005
Author: Greg Linwood Date Posted: 7/05/2005 10:25:22 AM
This full day seminar with Solid Quality Learning's Itzik Ben-Gan will cover the arsenal of new features available to the DBA in SQL Server 2005. The seminar focuses on the database implementation and maintenance parts of the DBAs world, covering subjects such as high availability, database maintenance, schema management, performance, concurrency, T-SQL Enhancements and more.

To register, visit the Solid Quality Learning website at:
http://www.solidqualitylearning.com.au/course.aspx?coursecode=FDS0002IBG

Cost: AUS$300
SQL Server User Group members: AUS$250

Agenda:

Partitioning
.Partitioning in SQL Server 2000
.Partitioning in SQL Server 2005

Datatypes and Data Integrity
.MAX Option for Variable Length Data Types
.XML Data Type
.BULK Rowset Provider
.Referential Integrity Enhancements

DDL Triggers

Snapshot Isolation

Database Mirroring
.Database Mirroring – Described
.Roles
.Synchronous Database Mirroring
.Asynchronous Database Mirroring
.Auto Failover
.Implementing Database Mirroring
.Monitoring

Database Snapshots
.Database Snapshots, Described
.Uses of Database Snapshots
.Creating a Snapshot
.Reverting Database to a Snapshot

Files and Filegroups Enhancements
.Instant File Initialization

Backup & Restore

Index Enhancements
.Online Index Operations
.INCLUDE Non-Key Columns
.Other Index Enhancements

Tools

An Overview of T-SQL Enhancements

Venue: Dimension Data - 10th Floor ActewAGL Building, 221 London Circuit, Canberra City (next door to the Waldorf Hotel) | Duration 8:30am arrival & coffee. 9:00am start. 4:30pm finish | On: Tuesday, 17 May 2005