Erich Allen Peterson

Category: SQL Server 2005

An In-Depth Look at Database Encryption with SQL Server 2005 + ASP .NET v2.0

It has been my honor to have another article published on 4GuysFromRolla.com. Entitled “An Overview of Cryptographic Systems and Encrypting Database Data” and is the first of a two three part series. The first part (published today) gives an overview of what exactly is encryption, what are its properties, how can it be used, and [...]

Listing Asymmetric and Symmetric Keys in a SQL Server 2005 Database

If you ever want to see a list of keys in your current database or see some of their properties (e.g. the encryption alogorithm used), just use the two statements below to list your symmetric and asymmetric keys from the system catalog views: SELECT * FROM sys.symmetric_keys; SELECT * FROM sys.asymmetric_keys;