Tip : SQL Server 2016 Row Level Security Introduction

Tip : Understand the Limitations of SQL Server Dynamic Data Masking

I follow up on Always Encrypted posts from T-SQL Tuesday with improved code and more information on performance and space usage.

Tip : Identify Candidate Tables for Stretch Databases

I investigate the observable overhead involved with using a new SQL Server 2016 security feature, Always Encrypted.

For this T-SQL Tuesday, I talk about a few of the limitations of Always Encrypted.

I discuss a couple of potential problems that can occur when you are inconsistent about case sensitivity.