TDE, or Transparent Data Encryption, is used by Microsoft and Oracle to encrypt database content.
Questions tagged [tde]
141 questions
2
votes
1 answer
Clarification on SQL Azure Transparent Data Encryption (TDE)
I'm creating a POC for TDE to enable security on our SQL Azure DBs.
I'm not sure what exactly TDE does but found below during my test:
You can still run the SQL Script against DB and still get results (unencrypted).
No changes are required on…
Nil Pun
- 17,035
- 39
- 172
- 294
2
votes
1 answer
SQL Server TDE and LINQ
I have a requirement to use TDE for data protection and to prevent DBAs from seeing the data. Our current data access layer use LINQ to access SQL without TDE. If the database is converted to TDE with encrypted columns, we have to make LINQ produce…
frosty
- 2,421
- 6
- 26
- 47
2
votes
1 answer
SQL Server 2012 TDE Restore Certificate Issue
I have two instances of SQL Server 2012 Enterprise but struggling to restore a TDE database from a set of backups (full, differential and log) from instance one to instance two. I am getting the error 'Cannot find server certificate with…
iggyweb
- 2,373
- 12
- 47
- 77
1
vote
1 answer
Unable to setup TDE via Azure SDK for python
I'm trying to setup transparent data encryption on my Azure SQL server with the help of a customer managed key I have stored on my key vault. I'm doing all of this via Azure SDK for python. I'm providing code for the same.
def…
Swapnil91color
- 11
- 1
1
vote
1 answer
How to do collections-not for TDE with Marklogic
I am looking to how to implement the collections-not for Marklogic TDE.
The equivalent one for the CTS query is
cts:not-query(cts:collection-query("archived"))
According to TDE documentation, it only supports AND, OR collections. I am looking for…
XCELERENT - I want to dance
- 523
- 2
- 7
1
vote
1 answer
Marklogic Perfomance impact on where to place the string replacement in Optics query or TDE
It is about searching XML content in MarkLogic.
One of the fields has some double quote characters inside, which causes a problem for CSV export. It is decided to change the double quote to a single quote.
I used TDE with Optics API to perform the…
XCELERENT - I want to dance
- 523
- 2
- 7
1
vote
2 answers
Marklogic TDE columns with property values
I'm trying to find out if it is possible to put document properties into a var like last-modified and use them in a value.
However, nothing seems to be able to access the properties.
I am aware the xpath property expression doesn't work but I've…
supersteve
- 17
- 2
1
vote
1 answer
Invalid TDE template
My MarkLogic database consists of a couple of sample documents in the folder "patents":
/patents/airless_diving.json
/patents/smart_racket.json
/patents/tuning_ukulele.json
/patents/waterski_drone.json
Each document looks like that:
{
"patent":…
Nadia
- 99
- 6
1
vote
1 answer
Which way is better to model TDE in MarkLogic? Two different data type for the same field or Cast the data type from OPTIC API?
I want to know which way is better to model TDE with MarkLogic.
We have XML documents with many different DateTime fields.
Most of the time (99.99%), the timestamp part is of no biz use.
I guess the remaining 0.01% use case is for data problem…
XCELERENT - I want to dance
- 523
- 2
- 7
1
vote
1 answer
Will reloading all TDE templates tigger reindexing cause ML Performance issue?
Now I am using gradle mlReloadSchemas tasks to reload TDE templates.
I guess even if the change is for one tde file only, the reload schemas task may delete all in DB and load all TDE templates to ML DB.
I wonder whether it will cause a performance…
XCELERENT - I want to dance
- 523
- 2
- 7
1
vote
1 answer
Why fn:substring-after Xquery function could not be used inside ML TDE
In my ML db, we have documents with distributor code like 'DIST:5012' (DIST:XXXX) XXXX is a four-digit number.
currently, in my TDE, the below code works well.
However instead of concat all the raw distributor codes, I want to simply concat the…
XCELERENT - I want to dance
- 523
- 2
- 7
1
vote
1 answer
Where can I find what SQL dialect that MarkLogic TDE based SQL support?
MarkLogic TDE enables SQL 'like' access to the document data.
Hence via common ODBC driver, other BI tools could possibly access ML DB in a 'relation db' way. However the challenge I have is to know which SQL dialet ML supports.
For example, I want…
XCELERENT - I want to dance
- 523
- 2
- 7
1
vote
1 answer
How to check that TDE is enabled and working in Azure Sql Database
As I understand from Microsoft's documentations, TDE is on by default and is managed automatically (if not choosing the option of BYOK). As a user with administrative permissions to the server, I can see all the data I want through MSSM Studio.
Even…
CodeMonkey
- 11,196
- 30
- 112
- 203
1
vote
0 answers
MarkLogic TDE: Not able to get data on multiple nested repeating fields and maps
I am working with TDE (Template Driven Extraction). I have an entity and trying to get data for repeating fields ( No Results) and valueMap (which is returning result in one line.)
…
vikram singh
- 21
- 1
- 4
1
vote
1 answer
bringing back a TDE database in AlwaysOn gives an error
We recently added a new disk to our SQL Server 2016 AlwaysOn environment, configuration is equal on both nodes. I wanted to move some databases to this new disk. (all databases have TDE enabled, AlwaysOn is working fine). This is what I…
Wilfred van Dijk
- 89
- 4