Creating and Registering SSL Certificates

A few days back, I was working with one of our partners who had a requirement of creating a SSL self-signed certificate through MMC console. As we are already aware that it is a complex and a tedious procedure, tried developing a script to ease the task for us. Also found that there were a…

0

How to “REGENERATE DEK” with a different certificate on Encrypted Mirrored database

As part of Encryption Key management in SQL Server 2008 Transparent Data Encryption (TDE) implementation, SQL server allows re-encryption of a mirrored database without breaking the Mirroring setup. In the following post I would be describing the script I used to perform this task.   Prerequisite : ·         Mirroring setup with TDE ·         Principal server…


How to change the keys for the Encryption for an already encrypted database

Have you ever wondered how to change the keys for the encryption for an already encrypted database. For this you can use “Key Rotation”. Key rotation is the process of decrypting data with the old encryption key and encrypting the data with the new encryption key.   But how to use the Key Rotation with…

1