Learn how to build more secure applications using the advanced security features in SQL Server 2017: row-level security, data encryption, and data masking.
- [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.
- Designing row-level security
- Using views to implement row-level security in SQL Server pre-2016
- Data encryption
- Configuring Always Encrypted
- Dynamic data masking