October 2009 - Posts

• Cleaning Out Your Backup History

  This week I have been pretty heads down working with a Microsoft Premier Field Engineer learning how to best customize System Center Operations Manager 2007 R2 to monitor things not included in the SQL Server Management Pack.  Based on the training Read More... Posted Friday, October 30, 2009 12:19 AM by Jonathan Kehayias | 2 Comments Filed under: Configuration, Database Administration

• SQL Saturday 21 Orlando – Presentation Files

  I am generally much better about this, usually posting my presentation files ahead of time, but I have been swamped at work and personally, so I haven’t been on the ball lately. I could bore you with details about having a Microsoft PFE onsite this week, Read More... Posted Wednesday, October 28, 2009 12:25 AM by Jonathan Kehayias | 2 Comments Filed under: Presentations Attachment(s): SQL Saturday 21 - Presentations.zip

• How many times has that Plan Guide been used?

  Plan guides aren't something that we tend to use everyday, and I certainly never think about the ones that I have created in my databases over the last few years.  However, recently someone asked how to measure how many times a plan guide has been Read More... Posted Monday, October 26, 2009 11:11 PM by Jonathan Kehayias | 0 Comments Filed under: Plan Cache

• SQL PASS Twitter Bingo - Join the Fun

  This year at PASS, SQLServerPedia in conjunction with PASS and Quest Software is hosting a Twitter Bingo game.  Rules are available on Stuart Ainsworth's blog post here .  I am not a face on a card this year, so I'll be tracking people down Read More... Posted Wednesday, October 21, 2009 3:52 PM by Jonathan Kehayias | 0 Comments Filed under: PASS

• Have you got air in your spare tire? (Have you checked your DR/HA plans?)

  This morning I was late to work because as I backed out of the driveway I noticed that my wife's car had a flat tire.  This should be a pretty simple thing to fix, but it turns out that the spare tire was also flat.  This too should have been Read More... Posted Wednesday, October 21, 2009 11:13 AM by Jonathan Kehayias | 8 Comments Filed under: Database Administration, Miscellaneous

• Less than two weeks to PASS Summit 2009

  Coming right off a excellent weekend in Central Florida with SQL Saturday, PASS Summit is now less than two weeks away.  Hopefully by now you have already registered since there was a lower price for early registration, but in the event that you Read More... Posted Tuesday, October 20, 2009 2:39 PM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, PASS, Presentations

• SQL Saturday #21 - Orlando Recap

  What a day, what a day!!  Andy Warren ( Blog / Twitter ), Jack Corbett( Blog / Twitter ), and a team of volunteers put on an excellent event today.  While this may only be a one day event, a lot of work is done behind the scenes, arranging an Read More... Posted Sunday, October 18, 2009 11:49 PM by Jonathan Kehayias | 6 Comments Filed under: Presentations

• MS09-062 - Critical: Vulnerabilities in GDI+ Could Allow Remote Code Execution

  Microsoft released a new Critical Security Bulletin that affects SQL Server today. http://www.microsoft.com/technet/security/bulletin/ms09-062.mspx If you haven't ever actually looked at one of these, let me first tell you that you can expect to be completely Read More... Posted Tuesday, October 13, 2009 6:01 PM by Jonathan Kehayias | 6 Comments Filed under: Security

• SQL Saturday #21 Orlando this weekend!

  SQL Saturday #21 in Orlando, FL is this Saturday, October 17th at Seminole Community College, 100 Weldon Boulevard, Sanford, FL 32773,  The event is free, but there is a $10 charge for lunch, which based on the meal I received the last time in Orlando, Read More... Posted Monday, October 12, 2009 2:54 PM by Jonathan Kehayias | 1 Comments

• SQL Server and Jumbo Frames

  During the 24 hours of PASS we (Thomas LaRock ( Blog / Twitter ), Argenis Fernandez( Blog / Twitter ) and myself) got into a discussion about enabling Jumbo Frames (network packets over 1500 bytes, generally set to 9000 bytes) for use with SQL Server.  Read More... Posted Monday, October 12, 2009 2:09 PM by Jonathan Kehayias | 2 Comments Filed under: Configuration, Database Administration

• Good advice can come from anywhere, but so can bad advice!

  In the past I have advocated that when it comes to advice you need to consider its source before you actually use it.  I still believe this today, but recently I got some advice that makes me add a caveat to this statement.  You also need to Read More... Posted Monday, October 12, 2009 8:00 AM by Jonathan Kehayias | 4 Comments Filed under: Miscellaneous