SQL Server has a lot of options for encryption. This video provides an overview of all of the options for encrypting your data.
- [Instructor] Encryption's always a hot topic with…databases because we wanna always…encrypt our sensitive data and SQL injection…and tags remain popular so databases…are always a big vulnerability.…And one of the ways we can achieve protection from this…is by encrypting some of our data.…Encryption always comes with a trade-off…'cause there are CPU costs associated…with decrypting and encrypting data.…And especially in terms of the SQL query language…we tend to lose some functionality,…depending on which type of encryption technology…you're using it becomes harder to compare…and harder to aggregate values.…
So that in and of itself becomes a challenge.…But in this chapter we'll talk a lot about…all the different technologies…that are available in SQL server…and Azure SQL Database for encrypting your data,…and what they protect.…There's three main areas where we can…encrypt data in SQL server.…And the first is encryption at rest,…and this just simply means that…your data files and backups are unable…to be mounted to another database engine…
- 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.