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

Unlock the full course today

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

Encryption overview

Encryption overview - SQL Server Tutorial

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

Start my 1-month free trial

Encryption overview

- [Instructor] We all have sensitive information that, on occasion, will need to be shared with third parties. Whether it's a credit-card number used to make a purchase at an online store, or personal health data shared with a hospital or insurance company, this information travels around between trusted users and clients. If you're building a system that will receive such information, then you'll need to be aware of the options available within SQL Server to encrypt that data. The process of data encryption makes legible information, called clear text, illegible by passing it through an algorithm that scrambles the contents and stores them as binary values. When the time comes to read back that information, the binary values are passed back through the algorithm, and the data gets unscrambled. These algorithms are called keys, and controlling who has access to the keys will determine who can encrypt and decrypt the information. There are two different kinds of keys that can be used…

Contents