Chapter 18

SQL Server and the Common Language Runtime

Beginning with SQL Server 2005, Microsoft added integration with the .NET Common Language Runtime (CLR) as one of its features. Including the CLR in SQL Server has provided both a bane and a benefit to the SQL developer and administrator. It provides an incredible source of power and potential to your server applications, but it also comes with costs that include resource consumption and additional security complications. This feature is not intended for every application and not every kind of server application can benefit from this capability. Those that can, however, have a new tool at the ready.

This chapter addresses the concepts behind the CLR and its essential architecture, particularly ...

Get Mastering SQL Server® 2008 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.