Capping a runaway report with Resource Governor uses workload groups, pools, and a tested classifier to limit one workload safely.
Stopping Backup Success Messages From Flooding the Error Log
Reduce backup success messages in the SQL Server error log with trace flag 3226, verify msdb history, and cycle logs safely.
Hunting Suspicious Objects After a SQL Server Compromise
Investigate a SQL Server compromise by preserving evidence and checking logins, startup procedures, Agent jobs, risky features, and changed objects.
A Health Check for an Inherited Server
A health check for an inherited server reviews backups, access, configuration, error logs, and jobs before anyone changes the system.
Sending a Microsoft Teams Alert From a SQL Server Agent Job
Send a Teams alert from a failed SQL Server Agent job with a Workflows webhook, PowerShell, SQL Server 2025 REST calls, and mail fallback.
SQLAuthority News – Download – SQL Server 2008 Developer Training Kit
Download the SQL Server 2008 Developer Training Kit by Microsoft to learn how to build web applications with the new data types in SQL Server 2008.
A Weekly Routine for SQL Server Administration
A weekly routine for SQL Server Administration checks recovery, failures, capacity, integrity, security, and pending changes in a practical order.