SQL Server Data Encryption

Home/Administration, SQL Server/SQL Server Data Encryption

SQL Server Data Encryption

$15.00 $4.00

In SQL Server 2000 and earlier, SQL Server did not provide any means of encrypting data at the database level. The encryption, if required were implemented at the application level. In SQL server 2005, column-level (also called cell-level) encryption was introduced. This provided the capability to encrypt the data at the column level in the database.
SQL Server 2008 introduced a new form of database encryption: Transparent Data Encryption (TDE). The purpose of TDE is to prevent scenarios in which the physical media (such as database files or backups) containing sensitive data are stolen and then read by attaching the database files or restoring the backups.
This lab comprises of three exercises. In the first exercise, we will learn about column level encryption. In the second exercise, we will learn to implement Transparent Data Encryption(TDE). In the third and final exercise, we will learn to restore the database encrypted using Transparent Data Encryption(TDE).

Exercise 1: Column Level Encryption using different pairs of functions
Exercise 2: Implementing Transparent Data Encryption (TDE)
Exercise 3: Restore a Transparent Data Encryption(TDE) enabled database

Categories: ,

Description

In SQL Server 2000 and earlier, SQL Server did not provide any means of encrypting data at the database level. The encryption, if required were implemented at the application level. In SQL server 2005, column-level (also called cell-level) encryption was introduced. This provided the capability to encrypt the data at the column level in the database.
SQL Server 2008 introduced a new form of database encryption: Transparent Data Encryption (TDE). The purpose of TDE is to prevent scenarios in which the physical media (such as database files or backups) containing sensitive data are stolen and then read by attaching the database files or restoring the backups.
This lab comprises of three exercises. In the first exercise, we will learn about column level encryption. In the second exercise, we will learn to implement Transparent Data Encryption(TDE). In the third and final exercise, we will learn to restore the database encrypted using Transparent Data Encryption(TDE).

Exercise 1: Column Level Encryption using different pairs of functions
Exercise 2: Implementing Transparent Data Encryption (TDE)
Exercise 3: Restore a Transparent Data Encryption(TDE) enabled database

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.