Two previous article of ours, An Overview of Cryptographic Systems and
Encrypting Database Data and Using Symmetric Encryption in a SQL Server
2005 Database, explored cryptosystem fundamentals and looked at encryption support in Microsoft SQL Server 2005.
We compared and contrasted symmetric and asymmetric encryption, examined SQL Server 2005's key management,
and saw examples of how to use T-SQL commands to create symmetric keys and to use these keys to encrypt and decrypt
data.
In this article - the final one of the series - starts with a look at the T-SQL commands for performing asymmetric encryption
and decryption. Next, we discuss using digital signatures as a means for ensuring the integrity of the encrypted data.
This article concludes with an ASP.NET 2.0 website example that ties together the lessons learned throughout this article
series. Specifically, the database used by this ASP.NET application stores customer information with the customer's credit
card information encrypted. An ASP.NET page provides a means to view the sensitive information in plaintext as well as a means
to add new customers to the database with the credit card information properly encrypted. Read on to learn more!
Read More >