September 2007 - Posts

• Double Standard?

  While this is nothing new, a conversation I had with a client the other day got me thinking more than I wanted to about what I see as sort of a double – standard for lack of a better term at the moment. Now I fully realize this can turn into a full out Read More... Posted Thursday, September 27, 2007 5:22 PM by Andrew Kelly | 15 Comments Filed under: DBA, Developer

• DBCC OPENTRAN() behavior

  I recently was bitten by some not so obvious behavior with DBCC OPENTRAN() that I would like to share. Basically this command is supposed to show you the oldest open transaction within the specified database or the current one if none is specified. If Read More... Posted Tuesday, September 25, 2007 5:25 PM by Andrew Kelly | 18 Comments Filed under: DBCC

• LINQ to the rescue

  I heard someone state that LINQ (see http://www.sqlmag.com/Article/ArticleID/48759/sql_server_48759.html for details on LINQ) was going to rescue developers from having to know TSQL. Well if that's true then who will rescue us from LINQ? LINQ like so Read More... Posted Thursday, September 6, 2007 12:22 PM by Andrew Kelly | 16 Comments