SQL Server: Security, Encryption, and Masking

Learn how to build more secure applications using the advanced security features in SQL Server 2017: row-level security, data encryption, and data masking.

Introduction

• Reduce coding pains by optimizing security features in SQL 2017
• Course software

1. Row-Level Security (RLS)

• 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

2. Encryption in SQL Server

• 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

3. Data Masking in SQL Server

• Data masking and SQL Server
• Demo: Dynamic data masking
• Demo: Build a masked set of data for testing
• Limits of dynamic masking

Conclusion

• Next steps