how to use, encrypt and decrypt data with MSSQL server

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.....