Row-level security is made up a combination of a policy and a function. Learn how this might work for your application.
- [Instructor] In this video, we're gonna talk about…the specifics of how to design a row-level security model.…We'll talk about some business examples, of course,…and then we'll talk about how to technically implement this,…and we'll take a look at the code,…and walk through how you implement this…within the SQL Server.…But I just wanted to talk about one scenario I implemented…when developing a new application,…that's kind of a unique use of row-level security.…One of the points of contention in SQL Server…is frequently inserts into tempdb.…Most of tempdb tends to live in memory,…at least the parts that are actively written to,…so it's not so much that, when you have contention,…and with tempdb it's happening at the disk layer,…or the physical IO layer.…
It's happening with getting latches on the pages in memory.…One of the ways we've worked around this to avoid it,…is by combining row-level security…with the in-memory table functionality,…formerly known as Hekaton, in SQL Server 2014 and up,…but obviously you need 2016 for row-level security.…
- 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.