From the course: SQL Server 2016: Administer a Database Infrastructure

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Implement Always Encrypted

Implement Always Encrypted - SQL Server Tutorial

From the course: SQL Server 2016: Administer a Database Infrastructure

Start my 1-month free trial

Implement Always Encrypted

“

- [Instructor] Always Encrypted is a new feature for SQL Server 2016 that differs from Cell-Level or Column Encryption in one major way. Always Encrypted protects data in transit not just at rest. Encryption and Decryption occurs on the client's machine, not on the server, and the keys are not revealed to the server itself. This creates a situation where only the users of the Database could view data within and the system administrators can be kept out. In order to demonstrate how this works we're going to create a new Database called AlwaysEncryptDB and then switch our context into it. Then, I'm going to create a simple Table that'll include three Columns: CustomerID, CustomerName, and PhoneNumber. We'll call the name of the Table, Customers and we'll populate it with values coming out of the WideWorldImporters.Sales.Customers Table. Let's go ahead and run line seven through 10 to populate the data. That'll bring in 663 rows of data and we can see all of it by selecting everything…

Contents