Blogs

Browse by Tags

• DBA
• Performance Tuning
• SQL 2005
• SQL 2008
• SQL Tips
• SQLServerSyndication

• Wait Stat Categories

  A few weeks ago I posted a job that I use to track wait stats in the DBA database that I bring to a number of clients.  I had promised to follow-up with a couple or three reports that could be used to monitor the values that were being aggregated Read More... Posted Monday, January 04, 2010 7:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, DBADiagnostics, DBA

• If You Don’t Know Where You’ve Been…

  If you don’t know where you’ve been, how can you expect to know where you are going.  Seems like such a simple little line and I’m sure many of us can look at history, politicians, and maybe that restaurant review that you didn’t heed when it comes Read More... Posted Wednesday, November 18, 2009 9:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, DBADiagnostics

• What Happened to My Fabulous Beverage!

  Everyone likes taking some time to relax.  You’re sitting out in the sunshine or on a beach and the waitress is bringing you your favorite beverage.  The company and conversation is great and it seems like the perfect day.  And then… suddenly Read More... Posted Tuesday, July 07, 2009 4:30 PM by Jason | 1 Comments Filed under: SQL 2005, SQL 2008, SQLServerSyndication, SQL Tips, DBADiagnostics, DBA

• When Did That File Get So Big?

  I haven’t blogged much since getting back from vacation.  It seems like a good restart after the two week hiatus would be to address an issue that has arisen countless times.  And while addressing it, I’ll put it into the DBADiagnostics database Read More... Posted Tuesday, June 30, 2009 5:00 PM by Jason | 1 Comments Filed under: SQL 2005, SQL 2008, SQLServerSyndication, DBADiagnostics, DBA

• Really Search Cache for Execution Plans

  Today’s stored procedure for the DBADiagnostics database is a re-hash of a post I did a couple months ago. The reason for re-hashing the procedure is that when I used it last week I found out there were some serious issues with its results. Some plans Read More... Posted Thursday, June 04, 2009 1:31 PM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, DBADiagnostics, DBA

• Oops… A Lot Of Trees… Jobs to Update

  Yesterday I posted about having an alert in place to know when SQL Agent jobs don’t have operators setup .  I’ve found this alert to be extremely useful, but often when its been shared it just leads to junk e-mail. The reason for this is when the Read More... Posted Tuesday, June 02, 2009 8:06 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, SQLServerSyndication, DBADiagnostics, DBA

• But It Wasn’t My Job To Do The Backups!?

  It’s happened a few times, I go out to assist with recovery from some sort of failure and the question of database backups results in an uncomfortable pause.  One group thought the other group was taking the backups and the other group didn’t know Read More... Posted Monday, June 01, 2009 2:30 PM by Jason | 1 Comments Filed under: SQL 2005, SQL 2008, SQLServerSyndication, DBADiagnostics, DBA

• Does A Job Really Fail If Nobody Knows About It?

  Have you ever gone out and made a new SQL Agent job and forget to assign notification settings for it? God, I hope I’m not the only one because that would mean I suck. This is a common issue that exists in most environments that I’ve worked in. So I must Read More... Posted Monday, June 01, 2009 11:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, SQLServerSyndication, DBADiagnostics, DBA

• DBADiagnostics – My DBA Database

  A couple years ago I started consolidating all of my DBA scripts into a portable DBA database that I could use for diagnostics (hence the silly name) and for maintenance scripts. To help me to continue to be inspired to update the database and to get Read More... Posted Friday, May 29, 2009 8:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, SQLServerSyndication, DBADiagnostics