I am exploring TDE; I have a couple of questions.
1. I found that as long as one has the certificate, the encrypted DB can be
restored on any server. How does TDE differs from backup with a password?
2. If in a table 2 cells have same values (e.g. ABCD123), does the encrypted
values at the disk will have the same values as well? If Yes, why TDE doesn’t
benefit from database compression?
>> Stay informed about: Transparent Data Encryption (TDE)