Learn how to build more secure applications using the advanced security features in SQL Server 2017: row-level security, data encryption, and data masking.
Overview
Syllabus
Introduction
- Reduce coding pains by optimizing security features in SQL 2017
- Course software
- Get started with row-level security
- Design a row-level security model
- Demo: Row-level security
- Implement row-level security
- Use views to implement RLS pre-2016
- Demo: RLS with views
- Other options for multi-tenant databases
- Introduction to encryption in SQL Server
- What data should I encrypt?
- Cell-level encryption
- Demo: Cell-level encryption
- Always Encrypted
- Demo: Implement Always Encrypted
- Demo: Azure Key Vault with Always Encrypted
- Manage Always Encrypted keys
- Data masking and SQL Server
- Demo: Dynamic data masking
- Demo: Build a masked set of data for testing
- Limits of dynamic masking
- Next steps
Taught by
Joey D'Antoni
