PASS Summit Session Follow-up: The Plan Cache Whisperer

I've wrapped up my session at my first session at this year's PASS Summit.  My session this Thursday was The Plan Cache Whisperer: Performance Tuning SQL Server [DBA-313]. The session appears to have gone really well and the content has been uploaded to the PASS Summit for download.  To provide access to the materials now, the slide deck … Continue reading PASS Summit Session Follow-up: The Plan Cache Whisperer

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

Can You Dig It? – Find All Plans for a Database

With today's SQL Server instances, there easily be anywhere from a dozen to a hundred databases on a single SQL Server instance.  In fact, on my laptop, I currently have almost two dozen databases and these are just from working on projects. Setup a SharePoint server and add a few sites and you'll easily see … Continue reading Can You Dig It? – Find All Plans for a Database

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