Posted by Erland Sommarskog on 10/02/38 11:53

Sav (sav.smb@gmail.com) writes:
> I'm developing a software that makes a lot of access to a MS SQL
> Server. All information in the data base is decrypted and encrypt upon
> each read and write access -- this is causing a big overload of CPU in
> my system. I'd like to implement something to make it faster so I
> wondered if there is any MS SQL Server API that would make the
> cryptography transparent for the application.

SQL Server 2005 has considerable additions in the encryption area, so
you can encrypt/decrypt in SQL Server. If you are using SQL 2000, you
should probably look into what SQL 2005 can give you.

But encryption of data, always means that things go slower. Not the least
if you encrypt everything, including the keys.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: quicker way to create indexes
• Prev in forum: Re: Newcomer to the whole milieu
• Thread view: Re: Cryptography API for MS SQL Server

[Reply to this message]