Video description
Master SQL Server’s Always Encrypted feature to provide column-level encryption of sensitive data such that only authorized application users can see that data. This video explains how the Always Encrypted feature works and shows how to implement column encryption using best practices. System and database administrators who might otherwise have access to view any data in the database are not able to view data protected through Always Encrypted’s feature set.
This video begins with an introduction to column encryption as implemented through the Always Encrypted feature, and the use cases for applying that encryption. Then follows an explanation of how exactly the technology works and is implemented in SQL Server. The video then walks you through implementing Always Encrypted column encryption on a new database and again on an existing database. Finally, the video covers how to configure an application to access the encrypted data in a manner that is transparent and convenient for end users of your database applications.
What You Will Learn
Recognize use cases for the Always Encrypted feature
Understand how the feature works technically
Generate an encrypted column for a new table
Insert data into an encrypted database column
Encrypt existing data within a table
Identify the relevant encryption certificates
Modify an application to access encrypted data
Who This Book Is For
Database administrators, application developers, and system architects who need to encrypt and protect data in a SQL Server instance. Especially helpful when it must be ensured that database administrators and system administrators do not in any way have access to encrypted data.
Table of Contents
Overview
00:02:43
Encryption Hierarchy
00:05:32
Encryption Types
00:07:04
Technical Description
00:05:50
Creating a New Table
00:06:40
Encrypting an Existing Table
00:06:42
Interacting with Encrypted Columns
00:07:36
Application Support
00:05:28
Key Rotation
00:08:06
Summary
00:02:35