On Thursday, Peter did his SQL Server 2005 HOL for members of the SQL Server User Group Austria:

His workshop encompassed a tour of the new Studio management tool and for example TSQL enhancements (CTE's shown on the following photo):

Aside from just watching, I did the workshop part for SQLCLR features - writing functions, stored procedures, UDTs (user-defined datatypes), aggregates and triggers in .NET code. One cool sample is a function for email verification - try to do this in TSQL!
