May 2015 – SQL Server Monthly Maintenance Checklist

It's time for a monthly reminder to review you SQL Server environment.  Hopefully over the last few months of this post not being published you've still been going through and performing your monthly SQL Server environment checklists. As with anything, just because it appears to be running well, doesn't mean that there isn't an unknown … Continue reading May 2015 – SQL Server Monthly Maintenance Checklist

December 2013 – Monthly SQL Server Checklist

The holidays are upon us and it's the first Monday in December.  That means it's time once again to take a look at your SQL Server environment and verify that things are where you want it to be.  And where you need it to be.  The aim is to be sure that while SQL Server … Continue reading December 2013 – Monthly SQL Server Checklist

October 2013 – Monthly SQL Server Checklist

It's not the first Monday of October, instead it's the second Tuesday (oops, had Wednesday in here originally).  As we are all busy from time to time, last week's post managed to slip my mind.  I was wrapped up with preparing for a birthday and Parallel Data Warehouse training. Many of you, though, are probably … Continue reading October 2013 – Monthly SQL Server Checklist

September 2013 – Monthly SQL Server Checklist

It's the first Monday of September and it's time to check up on your SQL Servers.  In truth, it's the second Monday, but for my peers here in the United States, it's the first Monday workday of the month.  The end result, though, is this reminder post is coming a week later than usual for … Continue reading September 2013 – Monthly SQL Server Checklist

August 2013 – Monthly SQL Server Checklist

I can't believe it's already August.  I had planned to get to the lake more this year, spend more time on the deck, and countless other things that have already slipped by this summer.  It's an easy trap to fall into.  Just make a deal with yourself that, I'll go to the lake next weekend, … Continue reading August 2013 – Monthly SQL Server Checklist

July 2013 – Monthly SQL Server Checklist

First Monday of the month and time to update the monthly SQL Server checklist.  Monthly SQL Server checklist, you ask?  Oh yes, if you aren't in the habit, you and your co-workers should really be doing this. Checking your SQL Server environment is about making sure that things that can go wrong, don't go wrong. … Continue reading July 2013 – Monthly SQL Server Checklist

June 2013 – Monthly SQL Server Checklist

Today is the second Monday of June and guess what I didn't publish last week? That’s right, there wasn't an update and reminder to the SQL Server Monthly checklist. Not a big deal, of course, I was at TechEd with about 10,000 other people, talking about indexing SQL Server. Fortunately, for me, waiting a week … Continue reading June 2013 – Monthly SQL Server Checklist

May 2013 – Monthly SQL Server Checklist

It's the start of the month of May, or at least the first Monday in May.  Hopefully you aren't nursing too much pain from a weekend that included two fairly dissimilar holidays.  First, there was Star Wars Day on Saturday.  Followed by Cinco de Mayo on Sunday.  There should have been something in there for … Continue reading May 2013 – Monthly SQL Server Checklist

April 2013 – Monthly SQL Server Checklist

After working on this monthly checklist for over a year, I've recently discovered that there isn't anything that we should be doing with our SQL Server databases.  Apparently, the platform is completely and absolutely self-maintaining and provides built-in disaster recovery without any effort on your part.  Along with all of these features, you won't be … Continue reading April 2013 – Monthly SQL Server Checklist

March 2013 – Monthly SQL Server Checklist

It's the first Monday of the month, do you know where your servers are? Hopefully, they are still in your data center.  If not, I'm not sure this post will help you out, so you better just call the police.  But if they are in your data center, then do you know how they are … Continue reading March 2013 – Monthly SQL Server Checklist