January 2009
Intermediate to advanced
792 pages
23h 8m
English
Content preview from Mastering SQL Server® 2008Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...