USE master; CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'vERYsTRONGpASSWORD159'; CREATE CERTIFICATE DBcert WITH SUBJECT = 'DBCERT'; USE tpcc; CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE DBcert; ALTER DATABASE tpcc SET ENCRYPTION ON;
USE master;
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'vERYsTRONGpASSWORD159';
CREATE CERTIFICATE DBcert WITH SUBJECT = 'DBCERT';
USE tpcc;
CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_256
ENCRYPTION BY SERVER CERTIFICATE DBcert;
ALTER DATABASE tpcc SET ENCRYPTION ON;