I am in process of upgrading a 50+ SQL Servers from SQL 2008 to SQL 2012. It looks like it will be closer to 100 SQL Servers. If I had to click something 100 times – I’d automate or I may call in sick that day. SQL Upgrade requires quite a bit more steps than … Read more

SQL ERRORLOG is not optimally configured fresh out of the box. Here are a few ideas on how to make it better. There are few issues of how SQL Server sets up ERRORLOGs by default: 1. Only 7 log files are kept by default. 2. Files grow indefinitely. I (usually) do a few things to … Read more

TSQL DROPs for temp tables, procs, functions, SQLAgent jobs, synonyms This is probably the most simple TSQL I will ever post. However, it becomes useful more often than it would seem. Many times I will write a script/proc or get someone else’s code which doesn’t do any checking or clean up. Temp table drop TSQL … Read more

SQLAgent job owner change TSQL TSQL to change SQLAgent job owner Today I discovered many SQLAgent jobs had non-sa ownership of the job. It was replication jobs created by me. Here is a TSQL script to change job ownership from whatever user to ‘sa’. Or to whatever user you want. Just change two parameters: @NewOwner and … Read more