Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Server Encryption Expand / Collapse
Posted Saturday, December 5, 2009 1:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 5, 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
Posted Saturday, December 5, 2009 7:12 PM



Group: Administrators
Last Login: Today @ 9:45 AM
Points: 34,362, Visits: 18,570
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 »

Add to briefcase

Permissions Expand / Collapse