The following is a list of publications and links to related sites.

Writing Managed Stored Procedures with CLR code
Publisher: SSWUG
Link: http://www.sswug.org/seeauthor.asp?aid=17763
With the integration of Common Language Runtime and SQL Server 2005 now its possible to manage stored procedures, trigges and user defined functions using .Net compliant language.

Resource Governor – Administrator’s Choice
Publisher: Innovation-HUT
Link: http://www.innovation-hut.com/Articles/Sql/resourcegovernor.aspx
Resource Governor or RG is SQL Server 2008's new feature through which one can easily manage system resources like CPU, I/O. With RG you can define resource limits, priorities and enable consistent performance.

C# Help
http://www.csharphelp.com/archives2/archive309.html