Skip to content

Instantly share code, notes, and snippets.

@LitKnd

LitKnd/simple certificate and symmetric key.sql

Created February 24, 2020 20:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save LitKnd/ec127d4c7304998d94872e4b20510391 to your computer and use it in GitHub Desktop.
Save LitKnd/ec127d4c7304998d94872e4b20510391 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
simple certificate and symmetric key.sql
CREATE DATABASE QuickTest
GO
USE QuickTest;
GO
CREATE CERTIFICATE SelfSignedCertificate
ENCRYPTION BY PASSWORD = 'helloiamapassword123'
WITH SUBJECT = 'Self Signed Cert Test',
EXPIRY_DATE = '20900101';
GO
CREATE SYMMETRIC KEY SymmetricKeyHiHi
WITH ALGORITHM = AES_256
ENCRYPTION BY CERTIFICATE SelfSignedCertificate;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment