Stack Overflow
Stack Overflow

Questions tagged [tde]

TDE, or Transparent Data Encryption, is used by Microsoft and Oracle to encrypt database content.

TDE Wikipedia page

141 questions
15
votes
4 answers

Database encryption or application level encryption?

When you need to store sensitive data such as CCs or SSNs, do you: 1) Build your own encryption routine within the application, define a secret key somewhere in a config file, and then manually encrypt/decrypt data going to the database. 2) Push all…
Simon at LabSlice-com
  • 3,017
  • 3
  • 24
  • 29
11
votes
1 answer

Encryption status in sys.dm_database_encryption_keys not consistent with sys.databases

If I query sys.dm_database_encryption_keys, it comes back with an encryption_state of 3 (encrypted), percent_complete of 0. If I query sys.databases, the is_encrypted column has a value of 0 (not encrypted). These two seem to counter each other to…
Scott Newman
  • 131
  • 1
  • 1
  • 8
7
votes
1 answer

Does EKM work with CNG key storage providers?

https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/extensible-key-management-ekm says : SQL Server provides data encryption capabilities together with Extensible Key Management (EKM), using the Microsoft Cryptographic API…
prashant
  • 969
  • 3
  • 11
  • 22
7
votes
1 answer

How can I use transparent data encryption with MySQL?

I want to enable Transparent Data encryption (TDE) on MySQL. I don't mind if the entire db is encrypted (as opposed to a few columns or rows or tables). I am using this for a study, so I am looking for something that is open and free. I found…
Rahul
  • 1,495
  • 1
  • 15
  • 25
6
votes
2 answers

What are impacts of TDE enabling on database performance?

If I use Transparent Data Encryption on my database, is there any impact on my db performance? Is it cause any problem for database indexing?
masoud ramezani
  • 22,228
  • 29
  • 98
  • 151
5
votes
1 answer

Oracle Transparent Data Encryption undecrypted access

Can I set up an Oracle Database in a way that all of the following statements are true a) certain columns, potentially all columns are encrypted, so that direct file access to the database file wouldn't allow an attacker to retrieve any records b)…
Jens Schauder
  • 77,657
  • 34
  • 181
  • 348
4
votes
2 answers

MarkLogic TDE Xpath values from JSON string array

I want to build a a tde with a row with an id and each value of an array in the original document. I get a row for each element but the values are null and ignored. Seems if the context is set to anything not an array the ../uri works but never when…
Lee Arnould
  • 123
  • 9
4
votes
1 answer

How to use Cassandra with TDE (Transparent Data Encryption)

I'm trying to figure out how to use Cassandra with TDE (Transparent Data Encryption) and in which DataStax edition TDE is supported. I've been going through DataStax documentation and from what I see, TDE is supported only in DataStax Enterprise…
Bakir Jusufbegovic
  • 2,806
  • 4
  • 32
  • 48
4
votes
2 answers

Exporting NumPy array to Tableau Extract (.tde)

I'm using Tableau's Python API to export a NumPy array as a data extract. All the examples I've seen from the library docs and elsewhere loop over each row. I'd like to just import an array as an entire table column, but it isn't clear this is…
Brice Nichols
  • 53
  • 3
4
votes
2 answers

What happens after the Certificate in SQL Server gets expired?

I have a certificate with my SQL Server Database. What will happen after the certificate gets expired? Will the record insertion, selection, deletion will work after certificate gets expired?
sms247
  • 4,404
  • 5
  • 35
  • 45
4
votes
2 answers

SQL Server TDE - how to tell when complete?

Is there a way to tell when a database is completely encrypted when using SQL 2008 TDE? I.e., ALTER DATABASE mydb SET ENCRYPTION ON The only way I can think of is to keep trying to detach mydb. It won't detach until all pages are encrypted. …
Neil Weicher
  • 2,370
  • 6
  • 34
  • 56
3
votes
6 answers

Protect sensitive information from the DBA in SQL Server 2008

Our client need to encrypt the MOSS content database so the content db should not be able to view by DBA or unauthorized people without the right encryption key. Seem the Transparent Data Encryption (TDE) in SQL Server 2008 cannot protect the…
anonymous
3
votes
1 answer

Data encryption in application cluster

I have a web application accessed over SSL. To beef up security on the back end we are looking at adding in symmetric encryption for the database. The application is spread across 6 servers in a websphere cluster. We were looking at a simple model…
Keibosh
  • 1,237
  • 1
  • 9
  • 18
3
votes
1 answer

Check if my database instance on SQL server is encrypted by TDE?

I have a question about SQL server's transparent encryption (TDE). I need to dump a database instance, which will be restored by another DBA remotely by dumped data files. I was asked to make sure the dumped data files has no TDE so DBA can restore…
lxiscas
  • 141
  • 1
  • 2
  • 13
3
votes
1 answer

SQL Server 2008 R2 Enterprise 180-day Trial - Transparent Data Encryption (TDE) error

I just installed SQL Server 2008 R2 Enterprise trial version on a Windows 2003 Server, and tried to implement Transparent Data Encryption (TDE) on my database. It failed with error: Transparent Data Encryption is not available in the edition of…
Tim
  • 41
  • 3
1
2 3
…
9 10