How to Enable Transparent Data Encryption for Databases in Your Availability Group

Transparent data encryption is the built-in method for at-rest data encryption in SQL Server. Taking steps towards security has always been important, but it is becoming even more important every day as there is a looming cyber threat industry hungry for easy high-profit data. We should also remember that not all threats are from the … Read more

A Simple SQL Server Security Checklist

This month I am providing a 12-point checklist of scripts to review your server’s current security posture. Use these scripts to get an idea of where you are, so that you can make plans for the places you may want to go. The paradigms of least privilege and defense in depth are important to remember … Read more