Removing TDE from a Database: Level 4 of the Stairway to TDE
Learn how to remove TDE from a database and return it to a normal state.
2020-08-26
2,765 reads
Learn how to remove TDE from a database and return it to a normal state.
2020-08-26
2,765 reads
Read a One-Slide Summary of the Differences Between TDE and Always Encrypted from Brent Ozar.
2020-08-19
Recently a customer asked me for help with setting up a test of an Azure SQL Database in the single database tier with Geo-Replication to work with Transparent Data Encryption (TDE) with a customer-managed key, also known as Bring Your Own Key (BYOK). It is very simple to do it when you use service-managed keys, […]
2020-07-21
1,640 reads
In this third level of the Stairway, we examine how to store your encryption certificate in the Azure Key Vault.
2020-06-24
1,589 reads
In the second level of the stairway to TDE, we examine how you can restore your databases on another instance after moving the encryption certificate.
2020-05-20
2,239 reads
The first level of the Stairway to TDE will explain how the feature works and how to set this up on one of your instances and databases.
2020-04-29
2,948 reads
In this article Filip Holub looks at how to configure and enable transparent data encryption for a SQL Server database using PowerShell.
2020-02-25
Security is often something people think about only after they have had a problem. Given that the average cost of a data breach is $3.92 million (SecurityIntelligence 2019) and ransomware attacks have increased 97% over the past 2 years (PhishMe 2019), the "if it's not broke, don't fix it" approach can clearly be catastrophic. Here […]
2019-10-07
6,332 reads
Learn how you can secure your TDE environment by separating your key from the server using Extensible Key Management.
2019-09-30
5,261 reads
Transparent Data Encryption (TDE) has been around for a long time. It first appeared in SQL Server 2008, and after a rocky start with some bugs, it has become a regularly used feature for many organizations. While not perfect, it does provide some protection and auditors like to see physical protection features being used. It's […]
2019-08-29
6,586 reads
By Steve Jones
It’s actually my month to host T-SQL Tuesday, and I came up with the...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...
Hello where can I find to apply latest CU thank you
for installation sql server standard edition for instance id should I put server name?...
Hi all! I want to create a stored procedure that returns a result based...