One of the new exciting features of SQL Server 2005 is its built-in T-SQL encryption functionality. Previous versions of SQL Server offered no built-in encryption functionality for data. In order to encrypt sensitive data, database administrators and developers had to turn to third-party tools or write their own extended procedures. Even with these tools in place various aspects of the system, such as encryption key management, left many databases in a vulnerable state.


Encryption Algorithm Block Cipher Encrypt Data Current Session Asymmetric Encryption 
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.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Michael Coles 2007

Personalised recommendations