The SQL Server 2005 Log Viewer shows SQL Server error logs, Agent logs, Database Mail and Windows event logs in one place, ready to filter and export.
Checking Which Accounts the SQL Server Services Run As
Inventory SQL Server services and their accounts, compare virtual and managed identities, and verify permissions after a change.
SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings
The global configuration list shows configured and effective SQL Server settings. I compare both before deciding that a change has taken effect.
SQL SERVER – 2008 – User Account – sa or sysadmin
SQL Server 2008 treats sysadmin as the modern home for the old sa account rights. Here is what changed and why sa now needs a password.
Parameterized Queries From Application Code
Use parameterized queries from application code to prevent SQL injection, improve plan reuse, and avoid parameter length mistakes.
Finding Dynamic SQL Open to Injection
Find dynamic SQL open to injection by searching module definitions for concatenation, then replace data concatenation with parameters.
A Quarterly Permission Review
A quarterly permission review checks server and database roles, new grants, orphaned users, service accounts, and owner signoff.