MORE ABOUT ME

SQL Tag

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

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

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

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: http://www.slideshare.net/ThomasLaRock/virtualizing-sql-server-8-things-to-avoidIf you find that you...