How to upgrade 51 SQL Servers from SQL 2008 to SQL 2012
Automating a 50+ server SQL Server 2008 to 2012 upgrade: the full prep checklist, detach/attach scripts, security and replication migration, and instance switchover.
Read more →SQL House
No Wimpy Databases!
3 SQL Server ERRORLOG must have configurations + 7 useful techniques
Fix SQL Server ERRORLOG defaults: keep 99 log files, cycle them nightly, use trace flag 3226, and find the log when SQL Server won't start.
Read more →
5 DROP TSQL statements I can’t live without
Handy T-SQL DROP snippets for temp tables, stored procedures, functions, and SQL Agent jobs, each with a safe existence check before the drop.
Read more →
SQLAgent job owner change TSQL
A T-SQL script to bulk-change SQL Agent job ownership from any login to sa (or any user you choose), matching the old owner with a simple parameter.
Read more →