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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.