SQL Server Encryption Library (RC4 Free)

Last Post 20 Aug 2006 02:36 AM by SQLUSA. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
m.savorani
New Member
New Member

--
10 May 2006 12:04 PM
http://www.sqlcrypto.com

SQLcrypto is a suite of cryptographic extended procedures written in C/C++ language. It provides an affordable and effective security solution for your database server. It currently supports industrially recognizable symmetric ciphers and hash algorithms.

Ciphers include AES, Blowfish, CAST5, Triple DES, DESX, IDEA, RC4, and RC5. Message digestion algorithms include MD5, SHA-1, and RIPEMD-160.

They are based on OpenSSL Crypto engine for most of the cryptographic operations. It is high performance, highly reliable, highly compatible and highly secure.

Whenever administrators and developers need to perform cryptographic operations on database data, it is only a matter of mouse clicks to insert encryption/decryption and hash functions into existing store procedures and queries without the necessity of recompiling the whole application.

SQLcrypto provides a complete data privacy solution for database management including a variety of strong encryption algorithms and templates to build your own cryptographic procedures. In Microsoft SQL Server, Transact-SQL developers can access to a rich set of cryptographic functions as well as hash functions in their native SQL language without undergoing any additional training. Applications are empowered with the ability to extend the current SQLcrypto features as well as to design entirely independent solutions.
SQLUSA
New Member
New Member

--
20 Aug 2006 02:36 AM
With SQL Server 2005, encryption is built-in.

What is your strategy for SQL 2005?


Kalman Toth, Database, Data Warehouse and BI Architect
http://www.sqlusa.com/order2005/
The Best SQL Server 2005 Training in the World
SwePeso
New Member
New Member

--
08 Apr 2007 06:13 AM
Here is a free RC4 encryption/decryption algorithm made entirely in T-SQL!

http://www.sqlteam.com/forums/topic...C_ID=76258
SQLUSA
New Member
New Member

--
11 Apr 2007 01:15 AM
Nice job Peter.

But for production, one needs something fast. Unless you are encrypting a few items only.

Kalman Toth, SQL Server 2005 Architect
SQL Server Training - http://www.sqlusa.com/ordermcdba

SwePeso
New Member
New Member

--
11 Apr 2007 01:34 AM
Doesn't that depend on how and when you encrypt the values?
If you use same key for all records, prestore the table variable holding the 256 numbers.

I did some test and the algorithm encrypts over 1000 records per second, which might be enough for one-time operations.


Acceptable Use Policy
---