Blogs

Browse by Tags

• Best Practice
• DBADiagnostics
• MNSSUG
• PASS
• Performance Tuning
• SQL 2005
• SQL 2008
• SQL Tips
• SQLServerSyndication
• Whitepaper

• 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

• Does Your Stored Procedure Grant Itself Permissions?

  It’s a very good question. One that might not seem to insidious. Nothing that should be able to bring down the system and cause failures. Or will it? I’ve been to a number of clients and done it myself before where I start to check out a stored procedure Read More... Posted Thursday, December 03, 2009 7:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, DBA

• August PASSMN Meeting Tonight

  The Minnesota SQL Server user group (PASSMN) meeting is tonight down near the Microsoft offices.  Come check us out to network and mingle with your peers and also for the opportunity to learn some new things. Tonight’s topics are: Syntactic Sugar Read More... Posted Tuesday, August 18, 2009 7:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, MNSSUG, SQLServerSyndication, SQL Tips, PASS, DBA

• This Week Only PASSMN Meeting (August 18)

  Well… until next month of course. If you’re in Minnesota and reading this… and don’t mind sharing some snacks with other like minded SQL professional… then come down and join us for this month’s SQL Server user group meeting. We’ll be in a different location Read More... Posted Sunday, August 16, 2009 7:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, MNSSUG, SQLServerSyndication, SQL Tips, PASS, DBA

• August PASSMN Meeting (Aug 18)

  Coming up in a couple weeks is the next PASSMN meeting. We’ll be in a different location for this month – across the skyway from the normal meeting spot. But that puts us right over a coffee shop… not a bad tradeoff for the coffee drinkers in the the Read More... Posted Wednesday, August 05, 2009 7:00 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, MNSSUG, SQLServerSyndication, SQL Tips, PASS, DBA

• Apply Those Updates

  Staying on top of patches for your applications can be important, especially when those patches can fix issues that are currently affecting your environment.  I’ve run into this from time to time with where the fix for an issue is related to the Read More... Posted Thursday, July 23, 2009 7:00 AM by Jason | 0 Comments Filed under: SQL 2008, SQLServerSyndication, DBA

• Management Data Warehouse Whitepaper

  One of SQL Server 2008 features I’ve been especially thrilled about is the Management Data Warehouse (MDW) .  Just recently, Microsoft released a white paper  by Kalen Delany that goes into a bit a depth on MDW and covers some best practices Read More... Posted Wednesday, July 22, 2009 11:02 PM by Jason | 0 Comments Filed under: SQL 2008, Performance Tuning, SQLServerSyndication, Whitepaper, DBA

• Resource Governor Whitepaper

  There were some questions last night at the PASS MN user group meeting last night about the resource governor.  There must be some psychics working over at Microsoft because it seems just this morning a whitepaper came out on it . Some highlights Read More... Posted Wednesday, July 15, 2009 10:00 AM by Jason | 0 Comments Filed under: SQL 2008, Performance Tuning, SQLServerSyndication, DBA

• 5 Common Mistakes with Tempdb

  One of the things I get to do pretty often is to visit with clients and discuss how they’ve implemented their SQL Server environment.  And if the title of this post is any indication of the contents there are a number of issues that I tend to be Read More... Posted Wednesday, July 08, 2009 12:00 PM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, Best Practice, Performance Tuning, SQLServerSyndication, SQL Tips, DBA

• 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