Author
Joey D'Antoni
Released
9/19/2018- 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
Duration
Views
- [Joey] SQL Server 2016 introduced major security enhancements that have continued to evolve into SQL Server 2017. Some of these features include better encryption using Always Encrypted technology, row level security to prevent users from seeing data that they shouldn't see and dynamic data masking to hide things like credit card numbers, and all of these things work together to help you build better and more secure applications. You will also learn in this course how to weave these features into your existing applications and how to take advantage of them for new applications. My name is Joey D-Antoni, and I'm a Microsoft Data Platform Most Valuable Professional and I've been working with SQL Server for over 20 years.
Welcome to my course on advanced security in SQL Server 2017.
-
Introduction
-
Course software1m 3s
-
1. Row-Level Security (RLS)
-
Demo: Row-level security2m 37s
-
Implement row-level security2m 16s
-
Demo: RLS with views3m 7s
-
2. Encryption in SQL Server
-
What data should I encrypt?3m 34s
-
Cell-level encryption3m 12s
-
Demo: Cell-level encryption3m 30s
-
Always Encrypted3m 58s
-
Manage Always Encrypted keys3m 36s
-
3. Data Masking in SQL Server
-
Data masking and SQL Server2m 45s
-
Demo: Dynamic data masking2m 37s
-
Limits of dynamic masking2m 30s
-
-
Conclusion
-
Next steps17s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Reduce coding pains by optimizing security features in SQL 2017