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 there.…Make sure you're running this against one of the…