- SQL Server database stuck in single-user mode (error 924): find the session holding it and restore MULTI_USERDatabases · 10 Nov 2026
- Shrinking a SQL Server data file safely: DBCC SHRINKFILE in steps, low-priority waits and fixing the fragmentationDatabases · 9 Nov 2026
- SQL Server logins vs users: give someone read-only access the right wayDatabases · 7 Nov 2026
- SQL Server: check database size, free space and what is filling your diskDatabases · 6 Nov 2026
- A map of the msdb tables behind SQL Server Agent: jobs, steps, schedules, activity and historyDatabases · 25 Oct 2026
- A reusable T-SQL template for creating SQL Agent jobs the same way every timeDatabases · 25 Oct 2026
- Starting a SQL Agent job from an SSIS package and waiting until it finishesDatabases · 25 Oct 2026
- Turning sysjobhistory's integer dates, times and durations into something readableDatabases · 25 Oct 2026
- What is Agent doing right now? Running jobs, current steps and next run times from T-SQLDatabases · 25 Oct 2026
- A T-SQL toolkit for SQL Server Agent: list, script, change and clean up jobs in bulkDatabases · 23 Oct 2026
- Reading SQL Agent history like a DBA: queries for failures, durations, trends and slow stepsDatabases · 23 Oct 2026
- SQL Server DBA cheat sheet: the queries and commands you use every weekDatabases · 23 Oct 2026
- What runs when? A readable SQL Agent schedule report decoded from msdbDatabases · 23 Oct 2026