Quite a few of the SQL folks have written a whitepaper on using CLR integration in SQL Server 2005. Check it out on MSDN.