Data Encryption

Last Post 04 Feb 2008 03:53 AM by SwePeso. 4 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
PaulMcKibben
New Member
New Member

--
15 Jan 2008 12:32 PM
I am trying to encrypt data in a column. What is the preferred method? (A certificate, the ENCYPT "keyword")

Thank you
SQLUSA
New Member
New Member

--
15 Jan 2008 08:52 PM
Paul,

What data are you cyphering? Do you have to do filter selects on the cyphered data like find "alpha1234" whereever it is (table scan)?

Did you think about storing the actual secret keys somehow? Who knows them beside the DBA?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/order2005higperformance/ The Best SQL Server 2005 Training in the World!
PaulMcKibben
New Member
New Member

--
16 Jan 2008 02:00 PM
Kalman,

I have developer loaded on my machine at home and wanted to develop an app with an credit card number to test encryption.

I have done a little research and found the ENCRYPT "keyword" and certificates used to encrypt sensitive data in a table.

I was looking for a recommendation for the best practice and a document that would walk me through the process.

Regards,
Paul
SQLUSA
New Member
New Member

--
16 Jan 2008 11:05 PM
You can use 3DES (TRIPLE_DES) encryption for credit card data encryption. That is the same as used by banks when you do an ATM transaction.

Link: http://www.sqlservercentral.com/For...x#bm319225









Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/order2005higperformance/ The Best SQL Server 2005 Training in the World!
SwePeso
New Member
New Member

--
04 Feb 2008 03:53 AM
I don't know if RC4 is sufficient enough for your needs, but try this
http://www.sqlteam.com/forums/topic...C_ID=76258
You are not authorized to post a reply.

Acceptable Use Policy