-
Trade Your iPod
I would like to trade my iPod for a day with different people I know. It would be great way to get exposed to knew music, flirt (if you are trading with a potential hottie) and spice up your day. Maybe there should be a “Trade Your iPod Day”?
-
Community Server Upgrade Hell
This last week I was tasked with upgrading a Community Server 1.1 install to 2.0. I was expecting a simple process after navigating the seas of .Text to CS 2.0, but I forgot to “knock on wood”. I ran the upgrade script as indicated in the upgrade instructions and got about 15 separate errors. I […]
-
Find and Delete Duplicates in SQL
We all know we shouldn’t have duplicates in the database. And despite my best efforts, somehow they sneak in from some legacy code, or from the hyper-active-compulsory-submit-the-form-fifty-times-in-five-seconds-bloke. So now and then I find myself writing the same SQL to track them down. Most solutions online say that you have to use a temporary table or […]
-
Jury Duty Thoughts
I am not about to complain about having to serve Jury Duty. I am a citizen of this country, and that is a duty of citizenship. And things are nicer now then when I first served. Now it is “one day-one trial”. I don’t know if that is a California guideline, but it means I […]
-
Sopranos, March 12
Wow, how many years has it been? Like 12? Well now a new generation can learn cuss words from my favorite Italian family (except for the Micelli’s from Who's the Boss? ). New season starts next week. Thank goodness; with Project Runway ending I didn't know what I was going to do with myself.
-
Bruce Leeroy
Sweet. As an aside, it was a bit of a pain to be able to insert this in my blog post. Do be able to do so, add the following to the markup/html node in communityserver.config: <object width = “true” height = “true”/> <param name = “true” value = “true”/> <embed src = “true” type […]
-
Using Case in Order By with Group By
Wow, that’s a mouthful. This is what I am trying to convey: When you do a Group By with Rollup, what happens is that the rolled up column shows null, and won’t necessarily be ordered at the bottom. For example: select firstname , count(*) as total from AdsEntered ads join tblStaff s on s.staffid = […]
-
Why the PS3 Will Suck
If you know me, you know I am a big Xbox 360 fan. Heck, I have a whole category devoted to my 360 diatribes. But the funny thing is I don’t want the PS3 to suck, although it is going to. Here’s the deal: Sony screwed up big time and got out-maneuvered by Microsoft. And […]
-
.Text to Community Server 2.0
I made the leap and upgraded my blog to Community Server (CS) 2.0. It took about 4 hours researching, downloading, uploading, converting and fixing. I couldn’t find a way to directly upgrade my .Text Version .95 directly to CS 2.0, so I decided to first upgrade from .95 to CS 1.1, then use the standard upgrade […]
-
Valentines Day
p>I’d say we had a pretty unique Valentine’s Day: First I gave her my gifts: Put the wedding CD I created on her iPod Nano and changed the Artist to the wedding day, the album to “Scott Loves Samantha”, and changed each song album cover to a picture of us. Compiled another wedding CD from […]