Category Archives: Encryption

Permissions for certificates and symmetric keys

I’ve taken this example from BOL and worked it a bit to get a desirable solution… The code is the first code block  from this URL… http://technet.microsoft.com/en-us/library/ms179331(v=sql.100).aspx Here is the first code block… (This is using AdventureWork2008) USE AdventureWorks; GO –If … Continue reading

Posted in Encryption | Comments Off on Permissions for certificates and symmetric keys

Encrypting SSMS connections using certificates

We had a requirement for PCI compliance that all admin connections to SQL Server must be encrypted. I took this a little bit further to ensure that this requirement was easily enforced using Login triggers. In our environment, we have … Continue reading

Posted in Encryption | Comments Off on Encrypting SSMS connections using certificates