Visual Studio Magazine

A CLR Alternative to the SQL Server ISNUMERIC function

Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...
eWeek

SQL Server 2005s Incredibly Cool CLR Integration

eSpeaks’ Corey Noles talks with Rob Israch, President of Tipalti, about what it means to lead with Global-First Finance and how companies can build scalable, compliant operations in an increasingly ...
GitHub

clr-table-valued-functions.md

CLR Table-Valued Functions [!INCLUDE SQL Server] A table-valued function is a user-defined function that returns a table. Beginning with [!INCLUDE ssVersion2005], [!INCLUDE ssNoVersion] extends the ...
GitHub

SQL Server CLR function for running REST methods over HTTP.

Addition of a proper PreDeployment script which takes care of CLR assembly signing without requiring the TRUSTWORTHY database setting. Added UTF8 encoding support instead of ASCII. Added support for ...
Ars Technica

SQL Server 2005: CLR and UDT to compress binary data automagically

A CLR UDT has a limit of 8000 bytes - I doubt thats big enough to pack a file into. I guess you could use custom serialization and store the compressed file in a different table using the ...