Encrypt and Decrypt Column Value In SQL Server 2012 Table

/* First Create table */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Password]( [ID] [int] IDENTITY(1,1) NOT NULL, [Password] [varbinary](100) NOT NULL, [Application] [varchar](100) NULL, [CreateDate] [datetime2](7) NOT NULL, CONSTRAINT [PK_Password] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = […]

Read More »

Encrypting SQL Server 2012: Transparent Data Encryption (TDE)

Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the ‘data at rest’. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted data files can be read by restoring the files […]

Read More »