No discussion of the new CLR features would be complete without a description of the security issues associated with using .NET assemblies and the SQL Server CLR:
http://m.makesdatawork.net/ShowArticle.aspx?ID=145