Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag CLR Rss

   Items 1 to 3 of 3   

HashBytes Nvarchar(MAX)

SQL SERVER Includes a Hashbytes function, however it's limited to VARCHAR(8000). This can cause a problem when trying to build hashes over wide datasets. Solution Expose the C# Hashbytes function using CLR  Read more...
By Simon Hundleby 2015/12/01 | Source: | Category: clr
Rating: |  Discuss |   Briefcase | 729 reads

Retrieving a Binary File from Your Database

In this second article I provide the means to restore a binary file to its original state.   Read more...
By Eric Notheisen 2015/05/28 | Source: | Category: clr
Rating: |  Discuss |   Briefcase | 4,501 reads

Encrypt a file from SSIS using the Advanced Encryption Standard (AES)

This article demonstrates how to create a CLR assembly that can encrypt or decrypt a file with AES-256 cryptography, how to reference the CLR assembly from an SSIS script task, and how to generate an MD5 checksum file so that its recipient can confirm the integrity of the encrypted file.  Read more...
By Stan Kulp 2014/05/13 | Source: | Category: aes-256
Rating: |  Discuss |   Briefcase | 3,319 reads
   Items 1 to 3 of 3   
.net (1)    
aes-256 (1)    
blob storage (1)    
file conversion (1)    
integration services (ssis) (1)    
md5 (1)    
sql server integration services (1)