-
Working with Data in Always Encrypted
In this post we’re going to create some encrypted columns in a table in a test database and look at some of the practicalities and limitations of working with Always Encrypted (AE). There are actually a fair few limitations, but not because there anything wrong with the technology, rather they naturally fall out of logic… Read more
-
Statistics Parser
Using Statistics Parser to easily read output from STATISTICS IO and STATISTICS TIME Read more
-
Understanding Keys and Certificates with Always Encrypted
This post attempts to explain in simple terms what keys are involved in Always Encrypted, how they get used, and the implications of those facts. Read more
-
Tuning Parallelism on SQL Server
Thoughts on how to think about parallelism in SQL Server – and how to tune it. Read more
-
Measuring SQL Query Performance
Using STATISTICS IO and STATISTICS TIME to measure query overhead. Read more
-
SQL Server 2016 SP1 – A significant change to licencing
A lot has been written about the change of licencing in SQL 2016 SP1. Here’s my two-pence worth. Read more
