ADVANCED T-SQL PROGRAMMING IN SQL 2000&2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

ADVANCED T-SQL PROGRAMMING IN SQL 2000&2005

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.
*sighs* … and we’ll never see this in Africa… I doubt that I’ll get the beancounters to stretch to sending me to the UK for 2 days worth of courses … *sniff sniff* Enjoy, those who are lucky enough to attend Panic, Chaos, Disorder … my work here is done –unknown
Unfortunately I’m unable to attend this seminar due to project deadlines and I do feel few times that the geographical region of US gets more lead as you can see many of them will be in US only. Other than this I always depend upon the web resources or lately depend upon the transcript. 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.
Here’s hoping a transcript might find it’s way here, then <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br />Panic, Chaos, Disorder … my work here is done –unknown
]]>