data protection

Question

I want to protect using enc ryption  in tables and de crypt it at reporting end.  As I have not done this before,. can you please guide me, from where to start, is there any POC already done pls share the link. If I have to encrypt some of the column what steps I have to follow and how to de crypt this data

---

Neil

Answer 1

Transparent Data Encryption (TDE) can be used to encrypt the data / columns in SQL Server Database. The encryption uses a database encryption key (DEK), which is stored in the database boot record for availability during recovery. The DEK is a symmetric key secured by using a certificate stored in the master database of the server or an asymmetric key protected by an EKM module. TDE protects data "at rest", meaning the data and log files.

For more details, please refer to the documentation.

https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-2017

-------------------------

If this resolve your issue, please mark it as answered.

Answer 2

Hi Neilcse,

Thanks for posting here.

Per your post, I couldn't catch some special requirement about SQL Server Encryption. Although I suggest one option, it may let you go wrong direction.

Firstly, please read this article to understand the way of encrypting data, Then try to choose one of them to achieve your goal.

SQL Server Encryption

Best Regards,

Will

 

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 3

Any simple one table couple of column example to begin with, will be helpful. 

Thanks!

---

Neil

Answer 4

Any simple one table couple of column example to begin with, will be helpful. 

Thanks!

---

Neil

Ok, please refer to these articles. I think you would know how to achieve SQL Server Encryption.

Reference

Implement Column Level Encryption/Decryption In SQL Server 2016

Getting Started with Always Encrypted using PowerShell

Parameterization for Always Encrypted – Using SSMS to Insert into, Update and Filter by Encrypted Columns

SQL Server Always Encrypted feature explained

Tag: Always Encrypted

SQL Server Encryption: Always Encrypted

Best Regards,

Will

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].