For years we have been able to use Transparent Data Encryption or TDE to encrypt our database files on SQL Server Enterprise Edition. This ability was the only reason many clients needed to upgrade from Standard Edition to Enterprise Edition. SQL Server 2019 includes TDE as a Standard Edition feature. No longer do you need to shell out the extra …

Transparent Data Encryption (TDE) on SQL Server 2019 Standard Edition Read more »

To start with for Transparent Data Encyrption (TDE) we will need to be using Enterprise (or Developer) edition of SQL Server 2014. I am using SQL Server 2014 Enterprise Edition CTP1, which is the early release of SQL Server 2014. Next we need a database to work with.  I will just use the Sample Database for Common Table Expressions, a simple …

Enabling Transparent Data Encryption on SQL Server 2014 Read more »