January 2009 - Posts

• When did DBCC CHECKDB last run on my databases?

  I've seen this question a few times on the forums, and unfortunately there never is a really good answer that is easy to use.  SQL Server 2000 didn't track this information internally, and even though an internal tracking mechanism was added to SQL Read More... Posted Wednesday, January 28, 2009 11:32 AM by Jonathan Kehayias | 2 Comments Filed under: Database Administration

• Online Credibility, How to build it and how to lose it in an instant

  Last week Gail Shaw made a post about Bad Advice and the impact that it has on credibility of not only the person posting it, but also on the site where it was posted.  This got me thinking about what kind of credibility a person might or might not Read More... Posted Monday, January 26, 2009 3:57 PM by Jonathan Kehayias | 5 Comments

• SQL Saturday #10 - Tampa FL Presentations

  It was a pleasure presenting at SQL Saturday today and meeting a lot of people.   The presentations from today will be available for download from the SQL Saturday website, but you can also snag them from the following links. Automating Common Read More... Posted Saturday, January 24, 2009 11:44 PM by Jonathan Kehayias | 2 Comments Filed under: Presentations

• Error: 945, Severity: 14, State: 2 | Database 'mssqlsystemresource' cannot be opened

  This is a somewhat continuation post from my post Error: 5123, Severity: 16, State: 1 when moving TempDB . So breaking my laptops SQL Instance and then fixing it got me interested in how else could I break SQL Server and make it not start up. I recalled Read More... Posted Thursday, January 22, 2009 8:21 AM by Jonathan Kehayias | 9 Comments Filed under: Error Messages

• Using the sql_variant datatype in CLR

  I am not generally a proponent of creating tables with columns of datatype sql_variant in them.  Often times these tables seem to be a really great idea at first, but then slowly begin to become problemattic.  However, if you do happen to use Read More... Posted Wednesday, January 21, 2009 7:32 AM by Jonathan Kehayias | 4 Comments Filed under: .NET/CLR Integration

• Breaking a String into "Words" the CLR way

  A good friend of mine an fellow MSDN Forum Moderator Aaron Alton recently wrote a blog post entitled Breaking a String into “Words” in which he rambles slightly more than I do (I sense an attempt to trump my claim to fame as The Rambling DBA) Read More... Posted Tuesday, January 20, 2009 2:40 PM by Jonathan Kehayias | 6 Comments Filed under: Comparing TSQL/SQLCLR

• How to ask a Forums Question

  I find it both amusing and frustrating how people ask questions on the various forums I look at online.  Often times the questions lack significant details necessary to solve the problem, or the topic of the question can easily be copied and pasted Read More... Posted Monday, January 19, 2009 7:49 AM by Jonathan Kehayias | 9 Comments Filed under: Rants and Ramblings

• Wordle and blog content

  SQL Server with Mr. Denny is one of the blogs that I follow, and a week ago he posted a blog entitled, I was bouncing around the net, and found Wordle.net .  In it Denny tagged Michelle Ufford aka SQL Fool who returned from vacation to post her image Read More... Posted Friday, January 16, 2009 9:15 PM by Jonathan Kehayias | 0 Comments Filed under: Miscellaneous

• Error: 5123, Severity: 16, State: 1 when moving TempDB

  I have seen the problem for this post twice in the forums in the last month and both times the way it was fixed was not documented as supported method, though in a desperate "production down" scenario I probably would have done the same thing Read More... Posted Tuesday, January 06, 2009 8:15 AM by Jonathan Kehayias | 3 Comments Filed under: Error Messages

• Goals for 2009

  A lot of people have been blogging lately about their New Years Resolutions and goals for 2009.  I had intended to blog this earlier, but I have been busy working on the Extended Events Manager app that I wrote for the SQL Heroes contest.  I Read More... Posted Sunday, January 04, 2009 11:34 PM by Jonathan Kehayias | 0 Comments Filed under: Goals