Tip : SQL Server 2016 Row Level Security Introduction
Monthly Archive: August 2015
Tip : Understand the Limitations of SQL Server Dynamic Data Masking
Microsoft has released Cumulative Update #9 for SQL Server 2014. See this blog post for more information. KB Article: KB #3075949 30 fixes listed publicly at time of publication (31 total) Build number is...
Microsoft has released Cumulative Update #2 for SQL Server 2014 Service Pack 1. See this blog post for more information. KB Article: KB #3075950 46 fixes listed publicly at time of publication (51 total)...
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 SQL Server 2016 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.