Common SQL Server Security Issues and Solutions
In the August 2008 issue of TechNet Magazine, Paul Randal wrote an article Top Tips for Effective Database Maintenance. It was geared toward "involuntary DBAs" (IT pros who .gif)
inadvertently wind up responsible for a SQL Server instance). The article had a great response from our readers so Paul has written another article full of critical information every DBA (especially involuntary DBAs) should know.
In the May 2009 issue of TechNet Magazine, Paul presents the Top 10 Security Issue every DBA should be concerned about. He explores each problem, explains each solution, and then points you to where you can find more information on each problem. In the article, Paul discusses:
- Physical Security
- Network Security
- Attack Surface Minimization
- Service Accounts
- Restricting Use of Administrator Privileges
- Authentication
- Authorization
- SQL Injection
- Disaster Recovery
- Auditing