English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1 Hour | 129 MB
Learn how to build more secure applications using the advanced security features in SQL Server 2017. Instructor Joey D’Antoni takes a deep dive into SQL Server row-level security, which allows you to restrict access to specific table data, and shows how to encrypt data using the built-in features in SQL Server, such as Always Encrypted, which protects sensitive client data without revealing encryption keys. Plus, discover how to perform data masking to prevent low-privileged users from seeing confidential information.
Topics include:
- Designing row-level security
- Using views to implement row-level security in SQL Server pre-2016
- Data encryption
- Configuring Always Encrypted
- Dynamic data masking
Table of Contents
Introduction
1 Reduce coding pains by optimizing security features in SQL 2017
2 Course software
Row-Level Security RLS
3 Get started with row-level security
4 Design a row-level security model
5 Demo – Row-level security
6 Implement row-level security
7 Use views to implement RLS pre-2016
8 Demo – RLS with views
9 Other options for multi-tenant databases
Encryption in SQL Server
10 Introduction to encryption in SQL Server
11 What data should I encrypt
12 Cell-level encryption
13 Demo – Cell-level encryption
14 Always Encrypted
15 Demo – Implement Always Encrypted
16 Demo – Azure Key Vault with Always Encrypted
17 Manage Always Encrypted keys
Data Masking in SQL Server
18 Data masking and SQL Server
19 Demo – Dynamic data masking
20 Demo – Build a masked set of data for testing
21 Limits of dynamic masking
Conclusion
22 Next steps
Resolve the captcha to access the links!