I have 'sensitive' eyes and certain repeating patterns, like bright sunlight through slatted blinds, will trigger auras. Flourescent lights usually seem too bright as well; I'm one of those that...

I've had the infamous "I haven't needed to do those kinds of object transactions" excuse - I just became an 'accidental DBA' moving from a low-key, low-needs environment (higher ed,...

Ah yes. The merge statement was not available in SQL 2005, was it? I've seen references to it but not had a chance to use it. Thanks!

Hello!

I commonly write stored procs that handle add/edits to a single table. If the ID value passed in is zero, then it adds the record to the table. If the...