Transparent Data Encryption

  • Michael Coles
  • Rodney Landrum


Up to this point, I’ve focused on cell-level encryption, which represents a significant portion of SQL Server’s encryption functionality. Cell-level encryption can be an extremely useful tool for targeted data encryption, but it does have some drawbacks. For one thing, a proper strategy involving cell-level encryption requires careful planning to balance the needs of security and performance. Cell-level encryption can be difficult, or impossible in some cases, to implement when you already have a database in production. The cost of refactoring a complex database (and its dependent applications) can be a significant deterrent to implementing cell-level encryption.


Encryption Process Trusted Platform Module Entire Database Encryption Option Physical Storage 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Michael Coles and Rodney Landrum 2009

Authors and Affiliations

  • Michael Coles
  • Rodney Landrum

There are no affiliations available

Personalised recommendations