SQL Server for Developers

SQT01 A Database Designers Favorite Security and Privacy Features in SQL Server/Azure DB

11/14/2023

9:15am - 10:30am

Level: Intermediate

Karen Lopez

Data Evangelist, Space Enthusiast, & NASA Datanaut

SQL Server includes multiple features that focus on data security, privacy, and developer productivity. In this session, we will review the best features from a database designer's and developer's point of view.

  • Always Encrypted
  • Dynamic Data Masking
  • Row Level Security
  • Data Classification
  • Assessments
  • Defender for SQL Server
  • Ledger Tables
  • ...and more

We'll look at new and older features, why you should consider them, where they work, where they don't, who needs to be involved in using them, and what changes, if any, need to be made to applications or tools that you use with SQL Server.

You will learn:

  • The pros and cons of implementing each feature
  • How implementing these new features may impact existing applications
  • 10 tips for enhancing SQL Server security and privacy protections