Getting Started: Enabling CLR Integration

Before you can learn how to use SQL CLR features, you need to know how to enable them. As with many new products in the Microsoft Windows Server system family, most advanced features of SQL Server are disabled by default. The reasoning behind this is sound: each additional feature that is enabled provides extra “surface area” for attacks on security or integrity of the product, and the added exposure is simply not justified if the feature goes unused.

The SQL CLR features of SQL Server 2012 are sophisticated and can be very useful, but they are also, technically, nonessential. It is possible to build high-performance databases and server-side programming logic without SQL CLR integration, so it is turned ...

Get Programming Microsoft® SQL Server® 2012 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.