how to use, encrypt and decrypt data with MSSQL server August 21, 2017 First, create your certificate with something like... CREATE CERTIFICATE YourTestKey1 ENCRYPTION BY PASSWORD = 'a secure password WITH SUBJECT = 'My Test Key', EXPIRY_DATE = '20201231'; GO More to follow..... Read more