-
Encrypting Your SQL Data Should be Your Default Option
Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we hear news of large companies that have had data stolen with both financial and reputational repercussions. It should be clear that access controls aren’t sufficient to fully protect us from attacks and we need a second line of defence – which Read more
-
My SQL Server Encryption book has just been published!
It’s been a long journey, but I got the email from Apress yesterday to say that my book “Pro Encryption is SQL Server 2022” has now been published. You can buy a copy at a massively reduced introductory price (nearly 80% off) through the following link: http://www.dpbolvw.net/click-100730415-12898971?url=https%3A%2F%2Flink.springer.com%2Fbook%2F10.1007%2F978-1-4842-8664-7 If I’ve acheived my aims then this is Read more
-
Optimized Plan Forcing in SQL Server 2022
I’ve been reading Bob Ward’s book “SQL Server 2022 Revealed” and one of the new features in Intelligent Query Processing (IQP) jumped out at me. Not because it’s going to rock my world but rather it reminded me of an idea I had when I first started playing with Query Store when it came out. Read more
-
SQL Server 2022 is Coming
We still don’t have an exact release date for SQL Server 2022 but at this stage we can have strong confidence that it will be with us before the end of the year – rather than slipping and becoming SQL Server 2023. My first intimation that this was so, was earlier this year. I’ve been Read more
-
Setting up Transparent Data Encryption (TDE)
Transparent Data Encryption (TDE) is one of the easiest ways of encrypting your data at rest. In my prevous post we looked at what TDE is and how it works: What is Transparent Data Encryption? In this post we go through the steps of setting it up. You can set up TDE when you first Read more
-
What is Transparent Data Encryption?
In this post we look at Transparent Data Encryption (TDE) in SQL Server. What it is – and how it works. Read more
