October 2019
Advanced
58m
English
on-demand course
SQL Server Always Encrypted: Protecting Your Data with Column Encryption
with Eric Blinn
Closed Captioning available in English
Overview
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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.