This course aims to teach learners strategies for designing a more secure SQL Server database, starting with simple design decisions for tables, views, stored procedures, and database roles. It covers built-in SQL Server security technologies such as Always Encrypted, Row-Level Security, Dynamic Data Masking, Transparent Data Encryption, and SQL Server Audit. The teaching method includes discussing tactics and technologies for database security and providing tips on retrofitting security features onto existing databases. The course is intended for developers, database administrators, and anyone involved in designing or maintaining SQL Server databases.
Overview
Syllabus
Intro
About Dan
Session Evaluations
Disclaimer
Agenda
Data Breach Statistics
What Data Do We Need to Secure
Data Objects
Tables
Code
Stored Procedures
Secure All Objects
Use Roles
Group Permissions
Builtin Features
Always Encrypted
Row Level Security
Data Masking
Data Masking Demo
Transparent Data Encryption
SQL Server Audit
Enable Transparent Data Encryption
Taught by
PASS Data Community Summit
