Your search for "tde" returned 100 results:
Hi Guys, I am trying to backup a certificate that I created for TDE but I am not successful. Please see my scrip below and also the error message: and the error is the following:Msg 15151, Level 16, State 1, Line 26Cannot find the certificate 'TDE_Cert', because it does not exist or you do not […]
2017-08-16
3,873 reads
Long shot I know, but kind of losing the will to live with this now. Have created a new instance o0f SQL 2016, it is fully patched and is showing as SP1, trying to make a brand new database TDE compliant, but getting the error below,'Transparent Data Encryption is not available in the edition of […]
2018-01-24
2,500 reads
Transparent Data Encryption on an Availability Group and Automatic Database Seeding
2018-03-08
2,337 reads
Hello I have a requirement to change the TDE master key password in one of the environments. Do I need to redo the whole process (encrypt the dbs with the new master key password) again after I regenerate the master key password? Kindly advice
2022-08-18
294 reads
Hi All, I have some questions related to SQL 2008 EE feature Transparent Data encryption (TDE). While implementing TDE we create a certificate in master database as follows and immediately take the backup of it. use master go CREATE CERTIFICATE TDECert WITH SUBJECT = 'Test TDE Certificate' go Question 1) By default expiry date of […]
2020-03-16
325 reads
I've inherited an instance that contains two certificates in the [master] database to implement TDE. I'm guessing one is used to encrypt the databases on the instance and the other was used to encrypt a database from the TEST instance, then moved over when that database was moved from TEST to PRODUCTION. Is there a […]
2011-10-19
234 reads
Jul 31, 2020 ... As TDE encrypts the page and not the actual data , so what's the meaning of encrypting the page and not the data inside it? How encrypted page ...
Can I use TDE along with DDM at the same time? Does the TDE encrypt the DDM or how does it work? Thanks
2018-11-12
682 reads
We enabled TDE on a heavy transaction server and started noticing cpu over utilization. so we bumped the core count and memory on the server and now it's running around 20% most of the time. My boss is asking me to look into turning off TDE. Can you do that w/o rebooting or having a […]
2015-11-24
53 reads
Heya... I have been tasked with setting up TDE on our SQL Server 2019 instance, and am doing so in our DEV environment as I have never done this before. I managed to create the master key, the certificate, and encrypt a database easily enough; so as a test I decided to try restoring the […]
2021-03-29
880 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