A set of webcasts and virtual lab learning material about SQL Server 2005. A very good resource to keep tabs on:
SQL Server 2005 Labs and WebCasts
Stored Procedure Object Interface Layer (SPOIL) is an innovative new piece of code that provides an object-oriented access to stored procedures inside of SQL Server. The technique used here is to model classes that resemble SPs and then work through them while the SPOIL layer takes care of communicating with the database. It is very similar to (but not as comprehensive as) ORM tools like Hibernate.
Good read and code too.