ASP.NET 2.0 how-to videos - definitely worth watching!
Dave Bost points to a series of ASP.NET videos. If you don't watch any of the others, at least see this one to check out the SQL 2K5 "broker" service where clients can get notified of updates to their queries.
ASP.NET HOW DO I Video Series: Caching (Part 1)
This video is part one of a two-part series introducing the new caching features of ASP.NET 2.0. Start with a demonstration of Page Output Caching followed by an overview of the new ASP.NET 2.0 Database Caching support for SQL Server 2000 and SQL Server 2005. Topics include using the aspnet_regsql.exe utility to add SQL caching support to a SQL Server database, creating a SQL cache dependency to eliminate unnecessary connections to the database, enabling table-level caching, and enabling enhanced caching support using SQL Server 2005 Change Notifications.