March 15, 2021 at 9:03 pm
Hello,
Please forgive the elementary nature of this post -- I've been tasked with encrypting certain fields in our Azure SQL Server DB -- I have never done this and so far I have done the following:
-Right-clicking on the column I want encrypted, and select 'Encrypt Column'
-After following the prompts, SSMS created a Certificate and placed it in the Windows Certificate Store
-The field in question is now indeed encrypted
As I understand it, said certificate will contain a master key that I can use to decrypt the field with a function such as DECRYPTBYKEY.
Again, I understand this is super basic -- but I just want to confirm, am I correct here in my understanding of this, or am I completely missing something?
Thanks
March 16, 2021 at 3:21 pm
Sorry should have searched this forum thoroughly. This article was very helpful
https://www.sqlservercentral.com/articles/sql-server-2016-always-encrypted
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply