Using SQL Server Yukon's .NET CLR Features Practically

(Kent Tegels) When I was first introduced to Peanut Butter Chicken, I had many questions: What does it taste like? Why would one want to mix Peanut Butter and Chicken? How do you prepare it? Who thought this up? I was hooked for life with the first bite.

When I first heard that the next version of Microsoft SQL Server, "Yukon," would have the .NET Common Language Runtime (CLR) hosted within it, similar questions arose: Why would you want to do that? How do I take advantage of it? Within a few minutes, I found myself looking at a number of examples that, frankly, did not convince me that there was a good reason to use this feature. What I really needed to see was a meaty business problem where using the CLR was practical. Thankfully, a good business problem was at hand.