Discover six essential strategies to enhance SQL Server application security in this comprehensive conference talk. Learn how to adopt crucial mindsets for creating a more secure database development environment, with actionable tactics and examples for each approach. Explore the differences between privacy and security, and delve into topics such as building with privacy in mind, implementing flexible security measures, and utilizing various encryption techniques. Gain insights on protecting encryption keys, managing sensitive data, implementing proper validation, and establishing effective data governance practices. By the end of this session, acquire practical ideas to advance security and privacy initiatives within your organization, ultimately improving your SQL Server application's overall security posture.
Overview
Syllabus
Introduction
Overview
Disclaimer
Privacy vs Security
Build with Privacy
Be flexible
Encryption
Types of Encryption
Always Encrypted
SQL Server Encryption
SQL Server Connections
Tokenization
Protect Your Keys
Encryption Key Management
Developers
Sensitive Data
Validation
Data Governance
Data Discovery and Classification
Eliminate Sensitive Data
Taught by
PASS Data Community Summit
