Posts Tagged ‘70-462’

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. CREATE 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 CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = […]

TSQL: Partitioned table exercise for 70-462

Here’s some TSQL for the WingTipToys2012 table partitioning exercise in the 70-462 training materials. CREATE DATABASE WingTipToys2012 USE WingTipToys2012; GO CREATE PARTITION FUNCTION WTPartFunction(INTEGER) AS RANGE LEFT FOR VALUES (30, 60) CREATE PARTITION SCHEME WTPartScheme AS PARTITION WTPartFunction TO (fgOne, fgTwo, fgThree); CREATE TABLE toys ( column1 INTEGER NOT NULL PRIMARY KEY CLUSTERED, column2 CHAR(30) […]