Blogs

June 2009 - Posts

• 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

• Presenting on Indexing at PASS Summit 2009

  I tweeted it a couple Friday’s ago when I got the notice but I was on vacation and had made the decision to avoid blogging anything during that time.  But since vacation is over, here’s the session that got accepted: Getting To Know Your Indexes Read More... Posted Friday, June 26, 2009 1:55 PM by Jason | 0 Comments Filed under: PASS Summit, Performance Tuning, Conference, PASS

• This Wednesday ITCare Event - Solving Business Pains with SQL Server Integration Services

  If you’ve been looking for some free training on SQL Server Integration Services, I’ve got the answer for you.  The details are below and you can register for the event here . Course Overview ITCare, delivered and hosted quarterly by our Partners Read More... Posted Monday, June 22, 2009 8:00 AM by Jason | 0 Comments Filed under: SQL 2005, SSIS, SQL 2008, SQLServerSyndication

• June PASSMN Meeting Today

  The weather says it’s supposed to be storming today.  What a better way to spend a rainy afternoon that in a conference room with your peers discussing SQL Server.  So come out at 2:30 PM for snacks and socializing and we’ll kick things off Read More... Posted Tuesday, June 16, 2009 9:15 AM by Jason | 0 Comments Filed under: SSAS, SQL 2008, MNSSUG, Performance Tuning, SQLServerSyndication, PASS

• June PASSMN Meeting Tomorrow

  If you are still trying to make plans for tomorrow afternoon… there is a PASSMN meeting you could attend.  This month we’ll be hearing about Analysis Services Dimension Creation Best Practices & Disks, Real and Virtual and What is Important for Read More... Posted Monday, June 15, 2009 11:00 AM by Jason | 0 Comments Filed under: SSAS, MNSSUG, Performance Tuning, SQLServerSyndication, PASS

• SQL Satur-What? Here Comes the East Iowa SQL Saturday

  Did you hear?  The call for speakers for the East Iowa SQL Saturday! I’ve submitted four sessions and plan on driving down for the weekend.  As Michelle points out it’s only a 5-hour down to the event.  The event is free and will have a Read More... Posted Monday, June 15, 2009 8:00 AM by Jason | 0 Comments Filed under: SQLServerSyndication, Conference

• June ITCare Event - Solving Business Pains with Integration Services

  Some lines got crossed with this month’s New Horizons ITCare event.  The topic and speaker have changed but the date is remaining the same.  Instead of the previous topic, I’ll be presenting on SQL Server Integration Services.  As I mentioned, Read More... Posted Friday, June 12, 2009 8:00 AM by Jason | 0 Comments Filed under: SQL 2005, SSIS, SQL 2008, SQLServerSyndication

• Oct 21 – IT Care - Painting by Numbers, Update Your SQL Skills with New Paintbrushes

  This event is a ways out there but thought I’d start getting the word out now for this free event.  The session will be hosted by yours truly and feature tricks and tips that I’ve picked up and want to spread the word on. Here is the registration Read More... Posted Thursday, June 11, 2009 11:26 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, Performance Tuning, SQLServerSyndication, Conference, Tpis & Tricks, Tools and Tips

• 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

• July PASSMN Meeting Date Changed

  At the last meeting of the PASSMN board, the date for the July meeting was changed from July 21 to July 14.  This was changed because of a conflict with some of the people invited to speak on the Ask the Experts panel. Speaking of which, we are still Read More... Posted Wednesday, June 03, 2009 3:00 PM by Jason | 0 Comments Filed under: MNSSUG, SQLServerSyndication, PASS

• June PASSMN Meeting (6/16/2009)

  The topics and speakers for June PASSMN meeting have been announced. Analysis Services Dimension Creation Best Practices & Disks, Real and Virtual and What is Important for SQL Server June 16, 2009 3:00 PM - 5:15 PM Register Here or visit http://www.mnssug.org/ Read More... Posted Tuesday, June 02, 2009 9:00 PM by Jason | 0 Comments Filed under: SSAS, SQL 2008, MNSSUG, SQLServerSyndication, PASS

• 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