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: SQLServerCentral.com | Category: clr
Rating: (not yet rated) |  Discuss |   Briefcase | 701 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: SQLServerCentral.com | Category: clr
Rating: |  Discuss |   Briefcase | 4,466 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: SQLServerCentral.com | Category: aes-256
Rating: |  Discuss |   Briefcase | 3,306 reads
   Items 1 to 3 of 3   
 
Tags
.net (1)    
aes-256 (1)    
blob storage (1)    
file conversion (1)    
integration services (ssis) (1)    
md5 (1)    
sql server integration services (1)