SQL Server Administration and Maintenance

SQH05 A Database Designer's Favorite SQL Server Security & Privacy Features


9:30am - 10:45am

Level: Intermediate

Karen Lopez

Data Evangelist


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

  • TDE
  • Endpoint Encryption
  • Always Encrypted
  • Database Scope Level Credentials
  • Dynamic Data Masking
  • ...and more

We'll look at the new 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