July Monthly SQL Server Checklist

It’s a new month, and time to check out your SQL Servers to make sure everything is configured and working properly.  Originally, I had planned to put this out on the first Monday of every month.  The trouble is, yesterday was a US holiday and I was likely jet skiing.  Did I just give away … Continue reading July Monthly SQL Server Checklist

Re-blog – June 24-June 30

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Some posts of interest that you may want to check out are: Why’d That Job Fail? (6/26/2010) – SQL Agent Job advanced options to get job failure information.  A best practice of mine. Database Mail Failed Items … Continue reading Re-blog – June 24-June 30

Minnesota SQL Server Study Group (July)

For the past few months, I’ve been openly working towards the SQL Server MCM.  I failed a couple times (written exam and lab) and passed one time (written exam).  As part of working towards the MCM, I’ve been getting together to study with some friends and members of the local SQL Server community. To make … Continue reading Minnesota SQL Server Study Group (July)

Pain of the Week: Understanding Your Indexes

Want to take a few minutes out of your day on to learn a bit more about indexes?  On Thursday, I’ll be presenting at Quest’s Pain of the Week webcast.  The session will be Understanding Your Indexes: Operational Stats. There's a lot that goes on under the covers of SQL Server with your indexes. But … Continue reading Pain of the Week: Understanding Your Indexes

Let's Get Registered! Registered!

The PASS Summit is only a few short months away.  But before that happens there is an important deadline fast approaching… the end of the pre-June 30th discount.  For the last few months, you could save $600 off the cost of the regular entry fee.  But on Thursday it all ends. I figured we’ve seen … Continue reading Let's Get Registered! Registered!

Re-blog – June 17-June 23

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Some posts of interest that you may want to check out are: Index Those Foreign Keys (6/18/2010) – Query to help make certain that foreign keys in your databases are indexed. CLR_AUTO_EVENT Wait Stat (6/19/2008) – Details … Continue reading Re-blog – June 17-June 23

PASS DBA Virtual Chapter Tomorrow

Tomorrow is time for part two of my presentations this month on Extended Events for the PASS DBA Virtual Chapter.  If you missed the first part of this series, you can watch it before hand here. Below are the details on the event and the session description… Extended Events, Work Smarter Not Harder – Part … Continue reading PASS DBA Virtual Chapter Tomorrow