I've made a few changes to the layout of the blog site - hopefully this is much easier to navigate.  Anyway, whilst recently browsing on Tim Sneath's blog http://blogs.msdn.com/tims I came accross a reference to SQL Server Nuggets.  This is a cool resource if you're looking for a gentle introduction to some of the CLR features in SQL Server 2005.  The short webcasts are also downnloadable (see links below)

SQL Server 2005

• Managing .NET assemblies in the database (streaming, download)
• Writing stored procedures in .NET managed code (streaming, download)
• Writing user defined functions in .NET managed code (streaming, download)