Lesson Learned #72: Is my database still encrypted (TDE)
A quick lesson learned from the field when dealing with TDE (Transparent Data Encryption). After running something like ALTER DATABASE [AdventureWorks] SET ENCRYPTION OFF One quick spot where people usually will look for information if a database is encrypted or not is sys.databases SELECT database_id, name, is_encrypted FROM sys.databases Even though it shows the state… Continue reading Lesson Learned #72: Is my database still encrypted (TDE)