Your search for "tde" returned 100 results:
All, I ran into a strange bug and wanted to see if anyone else has experienced this. It's on a SQL 2019 Standard (CU 8) instance with a TDE enabled database and database compression turned on at the instance level. There seems to be a bug when backing up a TDE enabled database with backup […]
2020-12-17
319 reads
Hi DBAs I am planning to Implement TDE on cluster nodes..Please throw some valuable suggestions and Tips... I appreciate your valuable suggestions. Thank you.
2012-04-02
4,659 reads
May 24, 2019 ... Take a COPY_ONLY backup of TDE protected database on Azure SQL Managed Instance · 1. Check if the db is encrypted with TDE: · 2. If the db is ...
My database has TDE (database level, NOT the column level). My drive are filing up and don't have option to add another drives. some of my tables contains data types (max) varchar.... when I run calculations from GUI I find I can save some of the spaces. Questions are: 1. Since it's TDE enable should […]
2015-03-09
93 reads
I thought that you need the Private Key to restore a TDE Database? All that I have is the following: tde.key tde.cert Master.Key Service Master.Key Is this enough to restore a TDE Database? I tried looking up the syntax to do the restore but I'm not clear on the steps that are needed. I did […]
2016-01-28
190 reads
2015-02-18
126 reads
A look at how you might recover from a disaster using encryption and an HSM module in SQL Server 2008.
2010-06-02
8,458 reads
Is it possible to restore through a TDE encryption operation? By this I mean restoring the unencrypted backup taken pre-encryption, then applying the transaction logs that bridge the pre/post encryption period, using the key for all log backups from the first log backup with encrypted data.
2024-03-12
21 reads
I've searched around quite a bit and can't find anyone else with this problem, but ever since we implemented TDE encryption (we have a separate certificate for each Instance but not each database) we have seen corruption pop up ALL OVER THE PLACE. This is especially the case with ETL servers.. seems like even 1 […]
2019-01-23
324 reads
Wondering if using TDE satisfies HIPAA requirements around encrypting PHI and PII data and if anyone knows if there are any specific Microsoft documents pointing to TDE as such. I found this: https://www.microsoft.com/sqlserver/2008/en/us/compliance.aspx but it's not real detailed. Thanks!
2014-02-26
390 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers