SQL Security For Dummies

Having gone through a couple of SQL setup audits with Microsoft, it became apparent that a lot of the security issues for SQL, no matter if SQL 2000, 2005, or 2008, are common sense if you have a good reference.

TechNet had an article about Common SQL Server Security Issues and Solutions. After reading through it, I found that almost every single item is easy to implement for anyone (DBA or not) using SQL. Most importantly, every single item is part of the audit when you pay for having Microsoft come on site to evaluate your SQL setup. So far I've also found that all of the items if missed are easy to remediate.