A customer has a database that is already set up in a SQL Server Availability Group. Since this database hosts sensitive data, there is a need to encrypt the primary and all secondary replicas of the data. In this article, we will walk through how this can be done.
2025-08-13
2024-11-08
369 reads
This next level of the Stairway to TDE shows how to upgrade your EKM cryptographic provider.
2026-04-02 (first published: 2024-07-17)
931 reads
2023-02-06
485 reads
In this article, we look at how to set up Transparent Data Encryption for SQL Server and Oracle along with the differences and similarities.
2022-09-21
2022-09-12
514 reads
2022-06-03
462 reads
2022-05-20
525 reads
Learn how to remove TDE from a database and return it to a normal state.
2026-04-02 (first published: 2020-08-26)
10,741 reads
Read a One-Slide Summary of the Differences Between TDE and Always Encrypted from Brent Ozar.
2020-08-19
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers