In Database We Trust

Exporting CLR Assemblies from SQL Server back to .dll files

You have imported an assembly into a SQL Server database to use the CLR functions and stored procedures it contains. However later, you lost the original .dll file and you would like to create the .dll file again from what's in the database. In this tip, we look at how you can recreate the .dll file.

How to implement SHA-2 in SQL Server 2005 or 2008 with a CLR assembly

SQL Server 2012 supports SHA-256 and SHA-512 through the HASHBYTES() function, but earlier versions of SQL Server do not. SHA-256, SHA-384 and SHA-512 can, however, be implemented in SQL Server 2005 or SQL Server 2008 with the CLR assembly described in this article.

Deploying CLR Assemblies with T-SQL

Learn how to simplify deployment and maintenance of SQL CLR assemblies by using T-SQL instead of Visual Studio.

How to save results of a procedure with more than one result set

Sometimes a procedure returns more than 1 result set. The article describes how to save all result sets into new database tables

An Implementation of the FNV1a Hash Algorithm for SQL Server

Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing

CLR Performance Testing

Are Common Language Runtime routines in SQL Server faster or slower than the equivalent T-SQL code? How would you go about testing the relative performance objectively? Solomon Rutzky creates a test framework to try to answer the question and comes up with some surprising results that you can check for yourself.

How to create a CLR assembly on a remote server with limited permissions

How to create external_access CLR assembly on remote MS SQL server, when trustworthy option is forbidden, and only SQL login is available

URI Parser: A set of 20 CLR functions for URI parsing

A set of 20 functions for URI and URL parsing, using .NET's native System.Uri parser

JSON.SQL: A CLR-resident JSON serializer/deserializer for SQL Server

One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.