For UK: Itzik Ben Gan, SQL Server MVP Tue, July 6th 2004, Reading Â£199 (ex VAT), discounts are available More information and full agenda:http://www.sqlserverfaq.com?eid=43 The Advanced T-SQL Seminar covers advanced querying techniques and T-SQL enhancements in SQL Server 2000 and SQL Server 2005. You will be introduced with many different techniques to solve common problems that you face daily as a T-SQL programmer. The following is a detailed list of the topics that will be covered in this seminar: Querying Multiple Tables Joins Types of Joins Self Joins Non-equi Joins Multi-Table Joins Semi Joins Subqueries Plain Correlated Misbehaving Subqueries Derived Tables Missing Values Analytical Ranking Functions Purpose and Examples Determinism Partitioning Yukon and Pre-Yukon Set-Based Solutions Performance Comparisons CTEs and Recursive Queries Non-Recursive CTEs Purpose and Uses Syntax Recursive CTEs Purpose and Uses of Recursive CTEs Elements of a Recursive CTE Usage Scenarios Single-Parent Hierarchies (Trees) Multi-Parent Hierarchies (Graphs) Advanced Issues with Recursive CTEs Cycles Sorting Aggregating Data Running Aggregations Cumulative Sliding Custom Aggregations Histograms Identifying Groups PIVOT/UNPIVOT PIVOT/UNPIVOT Described Pivoting Attributes â€“ Open Schema Groups with Collective Member Criteria (Relational Division) String Concatenation Aggregating Data UNPIVOT Other DML Enhancements TOP Enhancements Comparing TOP Support in SQL Server 2005 and in Earlier Versions TOP Syntax Using an Expression as an Argument for TOP Using the TOP option with Modifications CROSS/OUTER APPLY CROSS APPLY OUTER APPLY Table UDFs in Subqueries DML with Results Purpose and Syntax of New OUTPUT Clause DELETE Example UPDATE Example SQL SERVER 2005 (YUKON) DBA ENHANCEMENTS Itzik Ben Gan, SQL Server MVP Wed, July 7th 2004, Reading Â£199 (ex VAT), discounts are available More information and full agenda:http://www.sqlserverfaq.com?eid=44 SQL Server 2005 introduces an arsenal of new features and enhancements for the DBA in charge of database implementation. This seminar will cover some of the important DBA related enhancements. The focus will be both on database implementation enhancements related to schema and development, and also enhancements related to database maintenance, performance and high availability. The following is a detailed list of the topics that will be covered in this seminar: Database Implementation (Schema, Development) 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 Datatypes and Data Integrity MAX Option for Variable Length Data Types XML Data Type BULK Rowset Provider Referential Integrity Enhancements Trigger Enhancements DDL Triggers DDL and System Event Notifications Snapshot Isolation Exception Handling Exception Handling prior to SQL Server 2005 Exception Handling in SQL Server 2005 TRY/CATCH New Functions Trapping Errors in Transactions Database Maintenance, Performance and HA 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 Offline Files/Filegroups Moving Files ATTACH_REBUILD_LOG Moving data from a clustered index to a filegroup or partition scheme (DROP INDEX) Backup & Restore Online Restores Early Restore Access Single Page Restore Backup and Restore Media Checks Backup and Restore Error Reporting Mirrored Backup Media Index Enhancements Online Index Operations INCLUDE Non-Key Columns Other Index Enhancements Tools SQL Computer Manager SQL Server Management Studio DTS Wizards and UI Enhancements Profiler Enhancements Database Tuning Advisor (DTA) SQLCMD Dedicated Administrative Connection Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.