Author: Jen McCown

I don’t think this QUITE qualifies as a code sin, but it’s close. I’m reviewing code today, and I wanted to prove beyond a shadow of a doubt that this: UPDATE T2 SET col1 = CASE WHEN ( col1– @d ) > 0 THEN ( col1– @d) ELSE 0 END Is better than this: UPDATE […]

I’m altering a table in my dev environment, mostly because I didn’t capitalize one column and we’re picky about these things.  So what I need to do (in order to keep existing dev data) is to copy the data to another table, drop and recreate the original table, and reinsert the data.  CREATE TABLE [dbo].[FreshPrince_TEMP] […]

Dearie me, we do indeed have some goodies this week.  Let us rock it freestyle, shall we? First there’s your chance to win a “free book of your choice from Apress”. This week’s free eBook comes from ITPublishing:The Shortcut Guide to Subject Alternative Name Certificates. What a great pick for Gramma’s Christmas stocking!  You know, […]