If you are on an older release of SQL Server, cell level encryption is your option for encrypting table data. Learn about how to implement it in this video.
- [Instructor] When it comes to encrypting your data,…within your database table,…you have a few different options.…Just alone in SQL Server,…you have cell-level encryption and Always Encrypted.…Just for a point of reference,…if you're using SQL Server 2016, or 2017, or higher,…or you're using Azure SQL Database,…you should be using Always Encrypted.…It is the best, most secure way to encrypt your data.…But if you're using an older version,…this is something you have to think about.…Additionally, cell-level encryptions…are main option prior to that.…One other thing you'll notice,…you'll hear about Transparent Data Encryption.…
Transparent Data Encryption does nothing…to actually encrypt your data in tables.…It simply encrypts your files and your backups…on the file system.…So, it is a security mechanism.…But it does nothing to obscure your data.…If somebody gets into your database,…and they have permissions, they will see all the data.…So this is where you need to use…another encryption technique.…You have a couple of options if you want to do this…
- Designing row-level security
- Using views to implement row-level security in SQL Server pre-2016
- Data encryption
- Configuring Always Encrypted
- Dynamic data masking
Skill Level Beginner
SQL Server 2017: Linux, Docker, and macOSwith Adam Wilbert1h 44m Intermediate
SQL Server Performance for Developerswith Joey D'Antoni3h 44m Intermediate
Course software1m 3s
1. Row-Level Security (RLS)
2. Encryption in SQL Server
3. Data Masking in SQL Server
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.