Encrypt Columns in Sql Server

This is newly feature comes after SQL Server 2016 version. By using Encrypt Columns we can convert columns into Coded format.  the coded columns are the combinations of alphanumeric values. Converting Columns into Encrypt format, its hard to understand columns records. let’s see the steps to convert columns into Encrypt format—

1.  select the Database, Right click on ” Tasks ”  next select  ” Encrypt Columns ”  .

pic 1

2.            Introduction of Encrypt Columns : Always Encrypted is designed to protect sensitive information – such as credit card numbers – stored in SQL Server databases. It enables clients to encrypt data inside client applications and never reveal the encryption keys to SQL Server.

pic 2

3.  Column Selection :  we have 3 columns ID , NAME , LOC.  we can select  Encryption Type Deterministic or Randomized.

pic 3

4 .  To genrate a new column encryption key , a column master key must be selected. we can select  ” Windows certificate store ” or ” Azure key Vault ” . if you select “Azure Key Vault ” , you must have Microsoft account for azure.

pic 4

5.  Run setting :  if encryption / decryption in progress dont do write operations. it might loss data. select  radio button ” Proceed to finish now “.

pic 5

6 . Summary : here you can check ” Source database settings ” , “master key”, “encryption key ” , ” column ID ” , column NAME , columns Loc.

pic 6
input
output

Happy Query. Thanks .

Post Author: adama

1 thought on “Encrypt Columns in Sql Server

    Wilfredo Blessett

    (11/29/2019 - 11:45 am)

    This is a topic that is near to my heart… Cheers! Exactly where are your contact details though?|

Leave a Reply

Your e-mail address will not be published. Required fields are marked *