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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s