Jason Follas from Perficient demonstrated new T-SQL and SQLCLR functionality in SQL 2005 (formerly code name Yukon). He covered T-SQL topics such as new Large Value functionality, the XML Data Type, PIVOT/UNPIVOT, Ranking Functions, and Recursion using Common Table Expressions. He also coverd SQLCLR topics such as Stored Procedures, Triggers, User-Defined Functions, User-Defined Types, User-Defined Aggregates. The presentation went into overtime where the diehards stuck around to watch Jason demonstrate the power of SQLCLR by running a ZMachine (text adventure game engine) on the SQL Server itself! He then added SQL Endpoints and consumed them using both an ASP.NET and Windows application.