This technology was designed to have the entire encryption process be completely transparent to the applications accessing the database.
*This is a quick overview a more detailed hierarchy will appear later in the article. Transparent Data Encryption Encrypts SQL Server, Azure SQL Databases, and Azure SQL Data Warehouse data files. Its main purpose was to protect data by encrypting the physical files, both the data (mdf) and log (ldf) files (as opposed to the actual data stored within the database). Transparent Data Encryption (TDE) was introduced in SQL Server 2008.
