Blog Detail
Recent Posts
SQL Server 2008 Encryption Keys - Symmetric Keys
Symmetric keys are at the bottom of the SQL Server encryption key hierarchy. A symmetric key is used to encrypt other symmetric keys or data. Because symmetric key encryption is so much faster than asymmetric encryption and does not suffer the same d...
SQL Server 2008 Encryption Keys - Certificates
Certificates are another tool provided by SQL Server for asymmetric encryption. A certificate is basically an asymmetric key public key/private key pair containing additional data describing the certificate. The additional data includes a start date,...
SQL Server 2008 Encryption Keys - Asymmetric Keys
SQL Server encryption provides support for asymmetric keys, which are actually composed of a pair of encryption keys: a public key and a private key. The private key can have a key length of 512, 1,024, or 2,048 bits. SQL Server provides the followin...
SQL Server 2008 Encryption Keys - Database Master Keys
The SQL Server encryption key hierarchy includes a single DMK for each database. The DMK directly encrypts asymmetric keys and certificates that can be used to encrypt symmetric keys. Symmetric keys are used, in turn, to encrypt other symmetric keys ...
SQL Server 2008 Encryption Keys - Service Master Key
SQL Server 2008 includes the following T-SQL statements to alter, back up, and drop SMKs:• ALTER SERVICE MASTER KEY: Allows you to change or regenerate the SMK. This statement can be used to change the SMK and to automatically decrypt and re-encryp...
