Welcome to my box of tricks (SQL scripts) for Microsoft SQL Server instance and database administration! I've put considerable effort, over many years, into creating my own scripts, as well as ...

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...

While I am a general Linux admin, I have never administered or used PostgreSQL, although I do admin a few MySQL instances. I have just been told that a system currently hosted on SQL Server 2008 R2 is ...