Database data encryption in SQL Server for web application

Question

I am trying to saved the data in database table in encrypted format to hide the data store in the database table to be read by the user

Any advice how I can do this with out much effort on application level with less overhead on my application side?

AlexK · Accepted Answer · 2015-09-14 07:53:29Z

1

Read this MS SQL Server Encryption Hierarchy

Ex:

-- Open the symmetric key with which to encrypt the data.
OPEN SYMMETRIC KEY SSN_Key_01
   DECRYPTION BY CERTIFICATE HumanResources037;

-- Encrypt the value in column NationalIDNumber with symmetric key
-- SSN_Key_01. Save the result in column EncryptedNationalIDNumber.
UPDATE HumanResources.Employee
SET EncryptedNationalIDNumber
    = EncryptByKey(Key_GUID('SSN_Key_01'), NationalIDNumber);

MSDN EcryptionByKey syntax

answered Sep 14, 2015 at 7:53

AlexK

10.1k2 gold badges25 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Database data encryption in SQL Server for web application

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related