From the course: Microsoft SQL Server 2016 Essential Training

Unlock the full course today

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

Encrypt data

Encrypt data - SQL Server Tutorial

From the course: Microsoft SQL Server 2016 Essential Training

Start my 1-month free trial

Encrypt data

“

- [Instructor] In this section, we're going to talk about encryption in SQL Server 2016. This feature has changed a little from previous versions of SQL Server. In previous versions of SQL Server, the encryption keys were stored in the database, and that could be a bit of a security weakness. It allowed certain database administrators to see the keys. Now, in SQL Server 2016, the encryption keys are stored outside of the database, which should increase our security. This feature is currently only available in the Enterprise edition of SQL Server. So first we'll need to create some data to encrypt. I've staged some code for you to do that in your exercise files. I'll copy all of that into a new query window. And what this is going to do basically is create a table, the table will be called CreditCards, it'll have two fields, one of them will be CreditCardNumber, that we will eventually encrypt. But first we're going to insert three rows of data into it, and just some random numbers in…

Contents