Popular SQL Server Database Encryption Choices

International Journal of Computer Trends and Technology (IJCTT)          
© 2018 by IJCTT Journal
Volume-66 Number-1
Year of Publication : 2018
Authors : Sourav Mukherjee


MLA Style: Sourav Mukherjee "Popular SQL Server Database Encryption Choices" International Journal of Engineering Trends and Technology 66.1 (2018): 14-19.

APA Style: Sourav Mukherjee (2018). Popular SQL Server Database Encryption Choices. International Journal of Engineering Trends and Technology, 66(1), 14-19.

This article gives the overview of different data-base encryption choices in SQL Server. Which one works best in which situation. In today’s world Data is more crucial than the expensive hardware cost. No one wants their personal data to be comprised. Same for business houses as well and they also do not want their data to be inappropriately handled to go out of the business. To help protect the public rights and safety, recently this year, the European Union had come up with strict rules and regulation of GDPR (General Data Protection Regulation).

[1] Microsoft TechNet blog post, Always Encrypted (Database Engine) - SQL Server | Microsoft Docs [https://social.technet.microsoft.com/wiki/contents/articles/37979.working-with-the-always-encrypted-feature-in-sql-server-2016.aspx]
[2] Microsoft MSDN Document Library article, Transparent Data Encryption (TDE) [https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-2017]

Always Encrypted, Transparent Data Encryption (TDE), Cell Level Encryption (CLE), Dy-namic Data Masking (DDM), Vormetric Transparent Encryption (VTE), Encryption, Data Recovery.