Why is SQL Server Agent starting before SQL Server Engine service? A user group member asked me, and here are my quick reasons, from jobs to OS tasks.
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.
Standard DBA Reports You Can Write in T-SQL
Standard DBA reports can use T-SQL to show backup age, database sizes, job failures, login changes, and errors in one weekly review.
SQL SERVER – Find Next Running Time of Scheduled Job Using T-SQL
A scheduled job has recorded scheduling metadata as well as its actual execution history. I check both before promising a next run.
Tracking Job Failures Across Servers
Tracking job failures across servers takes a daily msdb report, a central instance list, and notifications that reach someone who can act.
Handing Over a Database to Another Team
Handing over a database should include a current map, tested recovery path, access transfer, open risks, and a defined support period.
Spotting Agent Jobs That Run Longer Than Usual
Spot Agent jobs that run longer than usual by decoding msdb duration, comparing recent runs, and checking jobs still active now.