Category: SQL Security

Configuring SSL Connections to SQL Server for PCI Compliance
Posted by Rob Risetto on October 22, 2015

I had a request from the client on how to enable SSL connections to their production SQL Server 2008 R2 instance to ensure that all network traffic between client application and related database is encrypted. The requirement came out of a PCI audit that dictated that Credit Card numbers should not be transported over the

Continue Reading

Protect Your SQL Server Backups in the Cloud
Posted by Rob Risetto on May 20, 2015

Consider the following situation, you create a database backup on a AWS virtual machine EBS disk and then move the backup file to Blob storage e.g. S3. However, you have switch on the Encryption option for your S3 storage. Is your database backup file fully protected? Yes, well, sort of.

Continue Reading