Your search for "tde" returned 100 results:
My company has been getting a lot of requests from our clients to put into place more stringent security practices. I just received the word from our CIO that all Personal Information (PI) must be encrypted at rest across all our servers. Which means we have to encrypt this data while its in the database. […]
2012-02-27
486 reads
I'm in the process of researching TDE implementation on a VLDB and would like to know if anyone has real world experience with enabling encryption on a production server. What kind of problems (if any) can I expect? My testing shows very little impact in a test environment, but I'm concerned about how long this […]
2016-06-09
1,968 reads
HiWe already have an established Log Shipping environment.The secondary has the databases in the 'Non recovery mode'I have just enabled TDE on the primary server to one of the databases that is getting log shipped.The master Key and certificate have been backed up to the primary server.I copied and pasted these 2 files over to […]
2018-02-07
1,492 reads
We have a DB about 45GB (32gb compressed-backed up) that has TDE setup, I need to remove encryption so I can backup and restore it to another server in the cloud where I don't have ability to restore the keys thus "removing TDE encryption " is necessary. Does someone know if we can run this […]
2019-03-04
423 reads
Howdy, Question: Is it possible to decrypt a Transaction Log taken off a database against which TDE is applied? Context: Business is transferring a portion of functionality to an outsourcer, this requires us to shift a substantial quantity of SQL data in a short timeframe. We'd like to use a delta approach to minimise the […]
2020-10-08
453 reads
I have a huge database 600+ GB and it is TDE enabled. I want to make database smaller. I found some tables are more than 1 million rows and one table cosumes 300+ GB . I need your suggestion if I can do Page compress for that 300+ GB table and few other ones? is […]
2014-07-26
485 reads
Dear Everyone We have implemented a data warehouse on-premises using SQL server 2019 enterprise edition running on VM Ware. SSIS, Database Warehouse and SSAS all reside on different servers in the same VLAN and now I am working on implementing TDE on the servers but I wanted to know the following: Is TDE required for […]
2020-01-23
636 reads
Morning Guys, This , I think should be an easy question but I cant find an answer online! My google-fu must be bad. I have multiple databases hostes on different servers, each with their own different tde certificate. I now need to restore these onto the same instance, side by side. Is it possible to […]
2018-03-29
2,067 reads
I know that we cannot encrypt the master, model, and msdb databases; SQL won't even let you... but is there any issue with encrypting the ReportServer and ReportServerTempDB databases? I can't find any best practice for that anywhere. Not so much CAN we do it, but SHOULD we do it is what I am asking […]
2021-11-10
190 reads
Sep 21, 2017 ... It is important to know that while backing up a TDE-enable database, the compression will kick in ONLY if MAXTRANSFERSIZE is specified in the ...
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