Archive for February, 2006|Monthly archive page

Find Duplicate Rows in Database Table

This little chunk of SQL saved my ass today after I found out that most of the 223 students who had been automatically enrolled in an Activity Management system I just deployed were actually enrolled twice because the student list provided by another system was corrupt:

SELECT * FROM table_name WHERE field_name NOT IN (SELECT DISTINCT(field_name) FROM table_name)

Ideally the field in question would be UNIQUE, but in this scenario that is not the case because the field was a student number and this system supports multiple courses — meaning a single student number is allowed to exist multiple times so long as each instance is tied to a different course. New constraints and checks have been put in place to ensure this can’t happen again, but regardless; lesson learned 😉


Super Silly Search Term

The funniest search phrase that has ever led a Google user to this site:

the more you stir in shit russ meyer

Ummm… ok 😕

Totally burnt out

2 months into 2006 and I don’t think I’ve ever felt less like turning the computer on in my life.
This hurts and it won’t stop.

Dear Google, email is not IM.

My last reason for using gmail, speed, has just whithered away.

With the recent addition of Google Talk to Gmail, they have lost me as a user and supporter of their webmail product. Upon first signing on this morning I was bombarded with all sorts of nonsense that had nothing to do with why I use Gmail — to read my mail and get back to work!. There were requests to allow others to see my online status and a new chunk of UI cruft that continually calls home.

Forget browser memory leaks, the new kid on the block is AJAX bandwidth leaks. I, for one, hate it with a passion.

“Settle down Andrew, surely you can turn this stuff off in the settings?!”

If only it were that simple. For you see, the most annoying feature of the Google Talk/Gmail integration is that Google has the nerve to assume all my email contacts are Google Talk users and that I would wish to check their online status prior to reading any email.

To this end, they have inserted a pause between the user clicking a mail item and that piece of mail being loaded. During the pause, a modal window appears showing the user’s GTalk status and other such nonsense.

After one email session involving these new additions, I’m even more certain that I need to ditch Gmail for good switch all my accounts to the Roundcube install I setup in January.

My Dad is blogging!


Peter Krespanis, my father, is entirely reposible for my interest in computers and is also the reason I have almost zero knowledge about computer hardware. I’m just too used to “support calls” that start with

Hey Pa, How you going? Cool. Ummm, I’ve got a bit of a problem, can I pick your brain for a minute?

What are you waiting for? GO CHECK IT OUT!
(And yes, I do intend on moving him to WordPress ;))