SQL Server Encryption

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » SQL Server Encryption

SQL Server Encryption

Rate Topic

Display Mode

Topic Options

Author

Message

Kansai

Posted Saturday, December 05, 2009 1:22 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, December 05, 2009 1:08 PM
Points: 1, Visits: 0

This is the problem I'm facing:
The database (SQL Server 2005) holds more than 5 million customer records. These records contain sensitive credit-card information that must be encrypted. Implementing an application-side encryption solution involves VB6 and .Net technologies. How to achieve a server-side encryption solution that would have minimal impact on performance and business processes?

Applying Encryption to Database
Finding and Decrypting a Record

I would like to know your opinion and advice.

Thanks in advance.

Post #829440

Steve Jones - SSC Editor

Posted Saturday, December 05, 2009 7:12 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 9:03 PM
Points: 31,406, Visits: 13,723

Encrypt only the credit card column, or better yet, encrypt it as a hash only. Don't store this stuff if you don't need to do it. If you do, then you ought to comply with PCI requirements of the credit card companies, not come up with something yourself.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #829479

« Prev Topic | Next Topic »

Permissions