First published on MSDN on Jun 14, 2010
This post will talk about DEK, what it is and how it is securely stored and managed inside a database. Before enabling TDE a DEK mus...
Updated Mar 23, 2019
Version 2.0
Blog Post
Hi,
Great article. I'm doing an assessment on the performance impact and would like to know exactly when the Certificate/Asymmetric Key is loaded to decrypt the DEK and in turn decrypt the data pages.
Is it on startup of the SQL Server instance? or is it on first DB query initiated? or when?
Appreciate any insight on this to understand the complete picture.