Posts Tagged ‘TDE’

TSQL: Transparent Data Encryption exercise for 70-462

Here’s some TSQL for the WingTipToys2012 Transparent Data Encryption (TDE) exercise in the 70-462 training materials. ?View Code TSQLCREATE DATABASE WingTipToys2012; GO   USE WingTipToys2012; GO   USE [master]; GO   CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘SecretPa$$w0rd’; GO   CREATE CERTIFICATE server_cert WITH SUBJECT = ‘My DEK Certificate’; GO   USE WingTipToys2012; GO […]