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
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
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
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
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
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
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
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
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
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
Strate SQL 