How Secure is TDE?
When we consider how secure a form of encryption is there are two things we want to consider. Let’s discuss each of these in turn. What are We Protected...
2023-01-13 (first published: 2023-01-03)
379 reads
When we consider how secure a form of encryption is there are two things we want to consider. Let’s discuss each of these in turn. What are We Protected...
2023-01-13 (first published: 2023-01-03)
379 reads
When you first look at the encryption hierarchy for TDE in SQL Server it can be a bit daunting. There seem to be a lot of objects involved and...
2023-01-04 (first published: 2022-12-21)
322 reads
TDE is referred to as a “transparent” form of encryption. What that means is that the process of encrypting and decrypting data is fully performed in the background. The...
2022-12-19
71 reads
We looked earlier at the various places our data lives – on disk, in memory, in-transit across the network. A good strategy will protect all of these locations –...
2022-12-28 (first published: 2022-12-14)
534 reads
SQL Server has had the native ability to encrypt data since SQL Server 2005. This included functionality that could be used to encrypt individual items and columns of data...
2022-12-12
118 reads
One of the reasons you may be considering encryption is due to the relevant data protection regulation: either because the regulation specifies that data should be encrypted or because...
2022-12-07
18 reads
On the face of it, this is a very obvious question with a very obvious answer. We want to prevent data from falling into the wrong hands. In practice,...
2022-12-05
15 reads
Another neat little feature in SQL Server 2022 is Query Store Hints. This is the ability to apply a query hint through Query Store rather than having to modify...
2022-11-30
55 reads
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...
2022-12-14 (first published: 2022-11-30)
367 reads
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...
2022-12-05 (first published: 2022-11-23)
228 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers