Questions tagged [tde]

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

TDE Wikipedia page

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