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.
2024-07-17
896 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.
2024-10-09 (first published: 2020-08-26)
10,687 reads
Read a One-Slide Summary of the Differences Between TDE and Always Encrypted from Brent Ozar.
2020-08-19
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
hi everyone I am not sure how to write the query that will produce...
Comments posted to this topic are about the item Rollback vs. Roll Forward
Comments posted to this topic are about the item Foreign Keys - Foes or...
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers