for more safer encryption
sql server db shouldn't store full key pair in the tables
so we can use windows cert storage for key pair store
well azure key valut or else equivalent is best, but cloud is require extra cost
(so company will feel not comfortable)
so just implement RSA or else key pair store on windows cert storage, and only public key store on db, and use public key ti encrypt Symmetric key(like AES) is quiet well approach
for more safer encryption
sql server db shouldn't store full key pair in the tables
so we can use windows cert storage for key pair store
well azure key valut or else equivalent is best, but cloud is require extra cost
(so company will feel not comfortable)
so just implement RSA or else key pair store on windows cert storage, and only public key store on db, and use public key ti encrypt Symmetric key(like AES) is quiet well approach