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 ...

I am getting a lot more unsolicited questions these days such as this one: “My co-workers tell me there is no future for SQL Server DBAs. Will I have a job in the long-term? I’m confused and ...

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 ...

This template provides a baseline for evaluating enterprise DBA candidate’s skill set, ranging from application deployment support to database design. The go-to resource for IT professionals from all ...

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 ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...