Archive for May, 2006

Alias in View Bug in Microsoft SQL Server Management Studio

Posted: Wednesday 10 May 2006 @ 2:47 pm by joecm

I knew I should have waited for SP3, but SSMS has a much nicer tabbed interface. It integrates Enterprise Manager and Query Analyzer into one place and in general improves my productivity. But it clearly should still be in beta. I’ve had a number of problems with DTS which I won’t go into now, but I just ran across a crazy bug.

I have a SQL Server 2000 database that has 4 tables and a view. We recently had to add a column to one of the tables. Simple right? I used SSMS and added a varchar(10) to the end of the table. When I went to test the results, my app started spitting out all kinds of jumbled data. Huh? What the hell is going on? I only added a column.

I soon traced it to the view and I was suprised at what I had found.

Sharks vs Oilers - 5-on-1 Power Play

Posted: Tuesday 9 May 2006 @ 8:29 pm by joecm

Playoff hockey is exciting.  But this was off the hook.  The San Jose Sharks had 2 men in the box and 2 had lost their sticks.  Watch as the kill a penalty with basically one “fully armed” defender.  Thanks to whoever posted this on You Tube as I was at the Giants game and missed it live.

It has been awhile…

Posted: Tuesday 9 May 2006 @ 8:00 pm by joecm

Ok, I know it has been a while since I posted.  I realized it even more when  it took me more than 10 minutes to log in.  First, I had forgotten the admin URL — so I was off to a good start.   After getting past that one, It took me a dozen tries to get my username/password combo right.  My guess is that is why my traffic is so high. 

Oh crap, now I just realized I don’t have a category that this fits into.  I want to go with Miscellaneous, but how the hell do you spell it?  Damn spell checker has ruined my brain.  I can’t spell sh*t anymore.  Thank you answers.com for the spelling.  I’m sure that category name is going work well in links.

So sorry for not posting in ages.  I’ve been busy watching 7th Heaven and ANTM (if you don’t know this acronym, you are just not cool). I will try to post more often for my loyal readers^H (thanks for the hits, Mom).