By now, all of us probably know that SQL Server Yukon hosts the CLR, and this is what gives use the possibility to write code running in SQL Server using .NET languages.
Being host of the CLR brings on some interesting issues in the case of SQL Server: issues like memory management, thrading etc. If you are interested in the ins and outs of CLR hosting Chris Brumme has a new post on his blog about it. As allhis posts it is definitely worth reading.
Oh and BTW, in our new book we spend a chapter discussing this. The book won't be out in a while yet, so go ahead and read Chris post.
