HOW TO: Find When SQL Server Wait Stats Were Last Cleared

For years I have found myself often needing these three pieces of information with regards to SQL Server:When was the last time the server was restarted?When was the last time the SQL instance was restarted?When was the last time the SQL Server wait stats were cleared?If the server itself is restarted, then the...

Changing Default Database File Locations in SQL Server

When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties. You can see these properties for yourself by right-clicking on the instance name...

HOW TO: Find Currently Running Long SQL Agent Jobs

A while ago I had posted a script to help find jobs that were currently running longer than expected. Since I've been sharing some scripts recently, I decided to verify that this script still works for finding long running jobs in SQL Agent for SQL Server 2014. Why This Script Matters Because you...

5 More Questions For Interviewing a Database Administrator

I've written before about interviewing a Database Administrator (DBA) and general hiring techniques. I've talked about how an interview should be a conversation, not a trivia contest.  I always describe the interview process as being a lot like being on a blind date. You shouldn't be looking to stump someone during an interview. Memorization...

Virtualizing SQL Server: 8 Things to Avoid
Virtualizing SQL Server: 8 Things To Avoid

Last year I wrote an article for SQL Server Pro Magazine on things to avoid when virtualizing SQL Server. I finally got around to putting the article into slide format and posted it to Slideshare. You're welcome.[slideshare id=30057945&doc=8thingsavoid-140115142216-phpapp02]The full link to the slides is here: you find that you...