TDE, or Transparent Data Encryption, is used by Microsoft and Oracle to encrypt database content.
Questions tagged [tde]
141 questions
1
vote
1 answer
AlwaysOn with TDE and Downtime
I'm fairly new to using TDE encryption with AlwaysOn Availability Groups. I have a few questions regarding application of the TDE certificate on a live database instance:
What kind of downtime have you experienced for enabling encryption on
a SQL…

Steve Hold
- 25
- 4
1
vote
2 answers
Possibilities of sql-injection in the following query
I have applied a table level encryption using TDE to my database,and am accessing the database from my windows application, through proper authentication:
my query may looks like the following(opens a wide entry for injection).
VB
Dim…

sujith karivelil
- 28,671
- 6
- 55
- 88
1
vote
1 answer
Can I dump memory to get decrypted data that encrypted with TDE in SQL Server?
I want to know how much data is secured in SQL Server that enabled TDE. I read some articles about TDE in SQL Server like https://msdn.microsoft.com/en-us/library/bb934049.aspx
Note that this part:
Encryption of the database file is performed at…

Mehdi Yeganeh
- 2,019
- 2
- 24
- 42
1
vote
2 answers
Handling Confidential Data in web application
I want to handle some confidential data in one of my web application. So that the data shouldn't able to read by the Developer or Database administrator.
We can easily hide the data from DB administrator by implementing some encryption technique.…

Rameez
- 601
- 1
- 8
- 22
1
vote
1 answer
Encrypting data in oracle database
What are the ways in which data can be encrypted? Say for example salary column, even the admin should not be able to see the encrypted columns if possible, data should be visible only through application to users who have access which is defined in…

locale011
- 35
- 4
1
vote
1 answer
SQL Server : Transparent Data Encryption (TDE) and physical access to the PC
Just a model case. Provided the SQL Server 2008 R2 Enterprise database is encrypted with the TDE. Someone starts the machine from Linux live CD, resets the local user/admin password and boot into Windows 8.1. Will this allow them to access the…

HonzaCZE
- 70
- 6
1
vote
0 answers
Build Always On with TDE encryption using EKM Asymmetric Key
We are trying to create HA Group using the always on feature .
Our database is encrypted with TDE using an EKM (External cryptographic provider- HSM) .
When trying to build availability group through the Wizard you can not choose databases with…

TheRunningDBA
- 109
- 1
- 7
1
vote
0 answers
Oracle/SQL Server Cross Platform Encryption Solution
I am looking to implement a secure method for encrypting some data on our systems that will be accessed by many different code bases from many different sources.
Essentially, we have a system of .NET applications (WPF, ASP.NET and WinForms) that…

SpaceCowboy74
- 1,367
- 1
- 23
- 46
1
vote
2 answers
Adding encryption *at rest* to a CloudPageBlob? (not transport encryption)
How can I add transparent encryption/decryption to my CloudPageBlob reads and writes when the data is at rest? HTTPS just encrypts in transport...
Assume that I'm running the code on my desktop and am simply using HTTP to access the blob store.

makerofthings7
- 60,103
- 53
- 215
- 448
0
votes
1 answer
Is there any feature like TDE for column level encryption on SQL Server 2008 that works transparently?
I want to know that, is there any feature in SQL Server 2008 for column level data encryption like TDE?

masoud ramezani
- 22,228
- 29
- 98
- 151
0
votes
1 answer
Table variable performance on SQL 2008 R2 server with TDE enabled
I have the following situation:
I have a SQL 2008 R2 Enterprise edition where I have enabled TDE encryption in one of the databases. One of the stored procedures from the encrypted database is using a table variable (@t1), table that gets populated…
0
votes
0 answers
Error creating TDE certificate from external file-Msg 15208, Level 16, State 10
I am trying to use an external certificate file to create a certificate for TDE encryption on a SQL Server 2019 instance. As this is for a government client, the certificate has to be issued by a trusted government authority. I cannot use makecert,…

Will M
- 1
- 2
0
votes
0 answers
Does SQL Server TDE require changes in code or is it transparent like it says
If I start using SQL Server Transparent Data Encryption (TDE), will I need to modify the code of my ASP.Net application in C#? Or is it completely transparent just like we encrypt connection string in web.config using aspnet_regiis
What if I am…

Frank Martin
- 3,147
- 16
- 52
- 73
0
votes
1 answer
Resolve azure policy sql server should use customer managed keys to encrypt for bicep script
The following bicep script should create a SQL Server. However, due to Azure policy violation it fails, and requires that I use customer-managed keys to encrypt data. See Error:
Here's the code block to encrypt protection for SQL Server. Still…

Chaka
- 1,709
- 11
- 33
- 58
0
votes
0 answers
Where to store TDE password, not at server
I have a linux server with a modified PostgreSQL DB which encrypt files at rest, using this guide.
I have installed this modified PostgreSQL on server which its DB files are encrypted at rest. and need the password to decrypt them when db process…

Roko
- 1,233
- 1
- 11
- 22