As the attacks in which hackers use become more and more sophisticated, and the programs in which they attack become
increasingly complex, encryption is becoming the last line of defense in database management system (DBMS) security.
A previous article of ours, An Overview of Cryptographic Systems and
Encrypting Database Data, compared and contrasted symmetric and asymmetric encryption and discussed key database
encryption concepts, including key management, authentication, authorization, and so on. The article also briefly touched
upon encryption capabilities of Microsoft SQL Server 2005.
In this article we will expand upon the first and look at how, specifically, to encrypt the data in a SQL Server 2005 database
using symmetric encryption techniques. We'll start with examining the facilities for managing keys in SQL Server and then
explore symmetric encryption in SQL Server 2005. A future article will look at using asymmetric encryption. Read on to
learn more!
Read More >