September 2007 - Posts

• Rant: LINQ is just a tool...

  ...like everything else. I was browsing through a recent SQL Server Magazine with an editorial of sorts by Michael Otey, going through the benefits of 2008. He mentioned LINQ as a tool to enable C#, VB or C++ developers to use set-based operations against Read More... Posted Sunday, September 30, 2007 7:15 AM by James Luetkehoelter | 0 Comments

• 5 things every SQL developer should know like the back of their hand...

  Since I had a post on 5 things a DBA should know, I thought I'd follow-up with a quick post about what *I* think any developer should know... 1) Always prefix object names - I can't stress this enough. Even if you have no schemas in place (SQL 2005 schemas, Read More... Posted Friday, September 28, 2007 12:33 PM by James Luetkehoelter | 7 Comments Filed under: TSQL, SQL Server

• 5 Things every DBA should know like the back of their hand...

  ..."hey, what's that spot on my hand?" OK, I put in shameless plugs, but that got me thinking about topics that every DBA should really, really understand. I'm talking a Kalen level of understand (Geeks unite!). I won't be explaining all of these things Read More... Posted Monday, September 17, 2007 3:45 PM by James Luetkehoelter | 7 Comments Filed under: SQL Server

• Another Shameless PASS Plug: DR for the Paranoid DBA

  I feel really guilty for writing this (there's someone with a shotgun behind me telling me that I should be doing this - if it were up to me I'd be happy speaking from a soapbox on a streetcorner). I've got a book that is finally (finally!) nearing publication Read More... Posted Monday, September 17, 2007 3:40 PM by James Luetkehoelter | 0 Comments

• Shameless PASS Plug: Non-database Knowledge for the DBA

  OK, I'm really ashamed to plug one of my own sessions, but I do highly recommend this session (or type of session - Peter Ward is doing something similar, as are a number of others). If you're fuzzy on any of these questions, you may find this of interest: Read More... Posted Monday, September 17, 2007 3:29 PM by James Luetkehoelter | 2 Comments Filed under: PASS

• Recommendations for PASS attendees

  For those of you going to PASS, I thought I'd write up a recommendation of speakers to go to and other activities. While I am speaking myself, I'm not mentioning my own sessions - if you read the topic and it interests you, be prepared that I'm not a Read More... Posted Tuesday, September 04, 2007 5:29 PM by James Luetkehoelter | 0 Comments Filed under: PASS

• Review/Commentary:Applied Mathematics for Database Professionals

  While still working on a post on the misuse of NULLs, I stumbled across the book " Applied Mathematics for Database Professionals " by Lex de Haan and Toon Koppelaars. Having some background in mathematics, set theory and a lot of background in logic, Read More... Posted Sunday, September 02, 2007 11:25 AM by James Luetkehoelter | 0 Comments Filed under: NULL, Database Theory