Encryption comes with a high CPU costs, and it is important to only encrypt the data that you need. This video helps you identify which columns of data to encrypt.
- [Instructor] One of the keys ways we protect…data within your database is…to use data based encryption.…However, no one encryption solution is…correct for every database.…The encryption requirements of your application…will dictate which encryption…solution you select.…Additionally the version of SQL server and the…addition of SQL server potentially, even,…will affect this.…The other thing to remember about data based…encryption is that the more data you encrypt and…the stronger the encryption,…the more CPU cycles it's gonna take…in order to encrypt and decrypt that data.…So be sure to balance your encryption…requirements with the increased system load.…
SQL server gives us a number of ways…to encrypt this data.…We can use Always Encrypted,…which is probably the best way.…We'll talk more about that in an upcoming video.…But there are a few other things you…should know about, like cell-level encryption,…which is something you'd probably use if…you're running on a version of SQL server…older than SQL 2016.…Additionally, Microsoft allows application…
- 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.