SQL Server 2005 Webcasts
The SQL Server team will be hosting a week of webcasts, giving you insight into what SQL Server 2005 can do. Level 100 and 200.
http://msdn.microsoft.com/SQL/2005Webcasts/
There are some good hands on labs also available http://msdn.microsoft.com/SQL/Labs/default.aspx
What if you don't have a copy of SQL 2005? Get a beta of SQL Server 2005 Express Edition http://lab.msdn.microsoft.com/express/sql/
Written your first SQL Server 2005 CLR Managed Code procedure yet? If not, get on to the band-wagon!