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)
378 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)
378 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)
319 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
68 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)
529 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
109 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
17 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
53 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)
364 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)
227 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers