Chapter 7. SQLCLR: Architecture and Design Considerations

When Microsoft first announced that SQL Server would host the .NET Common Language Runtime (CLR) back in SQL Server 2005, it created a lot of excitement in the database world. Some of that excitement was enthusiastic support voiced by developers who envisaged lots of database scenarios that could potentially benefit from the methods provided by the .NET Base Class Library. However, there was also considerable nervousness and resistance from DBAs concerned about the threats posed by the new technology and the rumors that rogue developers would be able to create vast worlds of DBA-impenetrable, compiled in-process data access code.

When it came to it, SQLCLR integration turned out to be neither ...

Get Expert SQL Server 2008 Development 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.