DATA Level Security in SQL Server / How to hide the sensitive data

Step1: Create master key
Step2: Create a certificate
Step3: Encrypt data using above certificate

create master key encryption by password ='Admin123$'

create certificate Cert_for_data_security 
with subject='cert for data encryption'

select CERT_ID('Cert_for_data_security')     --258

--How to hide the data
Declare @Password Nvarchar(max)
Set @Password='DBA@12$%'
select 'UNENCRYPTED PASSWORD :' +@Password
Set @Password=ENCRYPTBYCERT(258,@Password)
select 'ENCRYPTED PASSWORD :' +@Password

• Tweet
• Share
• Share
• Share
• Share