-
Splitting Strings on SQL Server 2016
Native support for splitting strings on SQL 2016 Read more
-
Tuning Parallelism on SQL Server
Thoughts on how to think about parallelism in SQL Server – and how to tune it. Read more
-
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
-
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
-
SQL Server 2016 – Always Encrypted and the GDPR
Discussing the importance of Always Encrypted with the impending arrival of heightened data protection regulations. Read more
-
SQL 2016 – Clone Database with Query Store
With 2016 you can generate a statistics only copy of a production database – that includes all the Query Store data too. Read more
