SQL Server Features Components

SQT05 Fast Focus: A Database Designer's Favorite New SQL Server Features

11/16/2021

2:00pm - 2:20pm

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
  • Temporal Tables
  • Graph Data & Processing
  • ...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