There are many options on how to build a multi-tenant data architecture.
- [Instructor] One of the main reasons why developers…tend to implement row-level security in applications…is for multi-tenant databases.…This is probably the most common one.…There are other use cases, limiting access…of data by departments, that take precedent,…but multi-tenant applications are by far…the most common one that I see.…And the reason why I wanted to talk about this…is developing those applications in some other…design patterns and where you might choose…to use each of those design patterns.…Row-level security tends to be…difficult and expensive to run.…So, I wanted to talk through a few different ways…of building these types of applications.…
One of the most common model, and this leads to you…using row-level security, is to stick all of your…customers in one large database.…You would obviously have a customer ID flag,…probably an index column, and you can use row-level…security so that each customer can only see…the rows that that they're entitled to see.…They're not gonna see any other customers' rows.…
- 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.