SUMMARY:   Students attending this class will learn about the newest features of Microsoft SQL Server 2005. AUDIENCE:   The course is recommended for application developers, database administrators, systems programmers, database designers, system analysts, and any personnel interested in Microsoft SQL Server 2005 performance and tuning facilities and those who are interested in learning about the newest features of Microsoft SQL Server 2005. PREREQUISITES:   It is recommended that people attending this class have a working knowledge of Microsoft SQL Server 2000 and have worked with Microsoft SQL Server 2000 for a period of at least three months. DURATION:   The class is presented as two days of lecture material. OBJECTIVES:   Upon successful completion of this course, students will be able to describe the newest features in Microsoft SQL Server 2005, including the enhancements to: Database Architecture Security processing Database Tools System Availability Transact SQL programming facilities Notification services SQL Server Service Broker XML changes Reporting Services Data transformation facilities Analysis services Data Mining COURSE CONTENT:   Database Architecture 64 bit support Multiple instance support New datatypes Database Snapshots Mirroring Event and DDL Triggers Data Partitioning Enhancements to Indexes Multiple active results sets Bulk Loading Full Text search Query processor enhancements Security Changes Database Tools SQL Server Management Studio Business Intelligence Development Studio Database tuning advisor Server Availability Failover clustering Early Restore Access Online Index commands Partial restore Page checksums Concurrent database and log backups SQL Coding PIVOT and UNPIVOT Waitfor Transaction abort Enhancements to Notification Services SQL Server Service Broker Overview Usage XML Integration XQuery XML indexes XML enhancements Reporting services Report server and manager Authoring a report Data Transformation Pipeline and Runtime Analysis Services OLAP storage types Data Mining Enhancements MT/07