A Tour of SQL Server Security Features

Abstract

Protecting data from unauthorized access becomes more important all the time. SQL Server includes a number of features that make data protection and security easier for developers and DBAs with a framework for protecting data. Come learn how Always Encrypted, TDE, Row Level Security, Dynamic Data Masking, and column level encryption can protect your systems.

You will learn:

  • About the different encryption and security features in SQL Server
  • Understand the code changes required for encryption mechanisms
  • Gain a basic understanding of RLS and DDM, which do not require code changes to help protect data

Level: 100

Demos

This talk includes the following demos

  • Always Encrypted setup and data access
  • Row Level Security setup and use
  • Dynamic Data Masking for users
  • Column Level Encryption implementation
  • TDE setup and verification

About way0utwest

Editor, SQLServerCentral
This entry was posted in Presentations and tagged , , , , . Bookmark the permalink.