SQL Server 2016 Row Level Security Introduction
Tip : SQL Server 2016 Row Level Security Introduction
Monthly Archive: August 2015
Understand the Limitations of SQL Server Dynamic Data Masking
Tip : Understand the Limitations of SQL Server Dynamic Data Masking
SQL Server 2014 RTM Cumulative Update #9 is available!
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...
SQL Server 2014 Service Pack 1 Cumulative Update #2 is available!
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)...
Always Encrypted Performance : A Follow-Up
I follow up on Always Encrypted posts from T-SQL Tuesday with improved code and more information on performance and space usage.
Identify Candidate Tables for SQL Server 2016 Stretch Databases
Tip : Identify Candidate Tables for SQL Server 2016 Stretch Databases
SQL Server 2016 : Performance Impact of Always Encrypted
I investigate the observable overhead involved with using a new SQL Server 2016 security feature, Always Encrypted.
T-SQL Tuesday #69 : Always Encrypted Limitations
For this T-SQL Tuesday, I talk about a few of the limitations of Always Encrypted.
Bad Habits : Being CarELesS about cAsE
I discuss a couple of potential problems that can occur when you are inconsistent about case sensitivity.