Superbowl – Didn’t Watch It

I’ll be honest, I watched maybe 10 minutes of the Superbowl. I have lost interest in it. I have lost interest in pro sports altogether. When did this happen? Somewhere in high school I realized that getting paid a bunch of money to play a sport, not cure cancer or the like was ludicrous. Why don’t we pay teachers more? Their service is much more needed and worth the money than some guy throwing a ball down field farther than anyone else.

I am tired of the showing off after every single play (something that made me switch the channel during the Superbowl). Yay, you got a tackle, stop flapping your arms and play the game. Now, don’t get me wrong, celebrating a huge play is fine but it is when you celebrate every single event in the game it becomes annoying.

Even the commercials during the Superbowl were dissappointing. The only funny one I saw was the convertible Ford Mustang one where it looked like the opening scene of ‘Fargo’.

Ok, I’m off my soapbox.

Finalist for SXSW 2005

The finalists for the 2005 SXSW Web Awards were announced yesterday and ISAR is a finalist in the CSS category.

ISAR was created by Segars Communications, my employer. Josh did all of the CSS work and his work on this site is as clean as it gets.

The other sites that are finalists are very nice as well, my favorite being the Ride4Ever.org site. It has great colors, flows nicely, and it’s about motorcycles.

The competition looks tough but I think ISAR has a good chance.

Despising Doctors

We all know that doctors have the ability to make us feel better (or sometimes worse) and the power to prescribe powerful drugs to get over ailments, well, they also have the power to ruin your day.

I usually show up to the doctor 15-20 minutes before the appointment is scheduled just in case there is any paperwork or problems. Today was no different. My appointment was for 10:30am for a “progress” checkup. I sat in the waiting room until 11:15am when the doctor finally called me in and basically took 7 minutes to ask me a few routine questions run a quick eye coordination test and walk me out. I missed class for that!? A class that I had homework due in. Had the doctor got me into his office when my appointment was scheduled for I could have easily made it to my class, no sweat.

All doctors do this, I don’t think I’ve been to a single one that has actually been timely in getting me in and out. It’s just frustrating.

Weather Feeds

The NWS has XML feeds available to display current conditions for a given area (or a set of given areas). Weather.com offers a feed as well but you have to sign up for the service and sometimes the updates are iffy. I have been playing with both and while the NWS feed is nice the document is somewhat sloppy. I want to try their web service and will probably end up doing so when I have a chance.

The Weather.com feed is nice but I have noticed that sometimes it fails to update or gives incomplete information. I am going to keep playing with it and see if I can get it to perform a little better. I am going to be implementing one of the options here soon, I just need to decide which one I like better.

Speaking of weather, the temperature has dropped into the 20’s and we are getting pretty heavy flurries… Strangest weather, ever.

The Dangers of ENUM and SET

I was browsing through the source code of WordPress this evening and noticed that it’s table creation statements used a lot of ENUM declarations for fields that are ‘Y’ or ‘N’. I am not dissing the code in any way but ENUM is not an across the board datatype. It is not in PostgreSQL at all and I believe there is a way to build it into Oracle.

The problem I have is that we (developers) have a huge push towards standards compliance with CSS and RSS so why not databases? I should be able to take code that is intended for MySQL and directly port it to SQL Server, Oracle, PostgreSQL, or Firebird. I shouldn’t have to worry about datatypes or whether sub-queries are allowed (since MySQL 4.1 they’re allowed).

I know what you’re thinking, “But Stephan, MySQL is the most commonly used Open Source database right now” and I agree but my issue is that in some situations MySQL either doesn’t cut it or there are issues with the host, company, etc. that keep MySQL from being installed.

It is not hard to use CHAR(1) to get the same effect as ENUM or SET. The real problem with the SET type is that if you make something like:

SET('Y','N')

technically it is completely valid to have a value in the database with (‘YN’) in the field. It is a dangerous type and I have slowly started removing it from my old code and not using it in new code.

This is not an attack towards Matt or any of the other WordPress developers, just some constructive criticism.

Why I Hate Dell

I tried making this post yesterday but the database choked or something and the post did not go through (another reason to write the post in Notepad first).

To begin, I have never been a huge Dell fan. I’ve always thought of their products as being second rate and even though recently their product quality has increased I still have issues with their technical support. In general I find outsourced tech support to be the most unuseful thing to a computer buyer.

I agreed to help a friend with her printer, which she received as a gift (along with a laptop) from her grandparents. She had a single piece of paper that had all of the information about the computer on it, which I thought would suffice.

On Friday afternoon I went to her apartment and started looking at the printer, it was one of those models that has a built-in scanner. The problem she was having was that the printer would crumple the paper and jam every time she tried printing. After a few different tries with it I thought I would use the paper feed to see if it jammed during every action. It did. My next course of action was to call technical support and see if they could give me any guidance.

Surprisingly, I was only kept on hold on Dell’s automated system for 10 minutes. After that I spoke to a human who asked me for the account number, which I gladly provided. He then asked me for the name on the account to verify the identity; No problem. The “representative” then asked me what my problem was and I explained the issue with the printer. He wanted me to give him the “service code” located on the back of the printer and I provided it. I was put on hold for a few minutes as he retrieved the information, after which he came back and said that there was no information available for the service code I provided. I again provided the code, this time using the NATO Phonetic Alphabet so that there would be no confusion about the letters. He put me back on hold and came back again telling me the information could not be found. At this point I was not frustrated, until I repeated this process probably 3 more times. Finally, the rep put me on hold to go talk to his supervisor. When he came back he informed me that the service code I had given him was associated to another person and our printer was associated to someone else. He explained that I would need to talk to customer care and have them switch the numbers around so that everything would be on the level. After that was over I could call him back and get my problem solved. By this time it was 9pm and I was ready to get home.

Saturday came around and I was back over at my friend’s apartment spending some time on the phone with Dell. I reached customer care and explained the issue, at which point I was quickly told that my account was a higher education account and I would need to talk to that billing department. What?! This is not a billing issue, it is just an issue with your records. Their response was to forward my call to billing. I again explained the problem and the representative acted like she may actually get something done. It wasn’t to be. She took some notes on my problem and gave me a case number to tell the finance department. Why they ever connected me to their finance department I’ll never know, this computer was completely paid off and I didn’t need a loan. Once I was connected to the finance department, the guy on the other side of the line told me that he couldn’t handle my issue and that I would need to be connected to customer care. What?! I just spent an hour and a half talking to 3 different people and now you’re telling me that I have to start the whole process over again? Needless to say I gave up and her printer never was fixed.

I have never been thrown for such a loop and I have talked to a lot of technical support people. I will say that they were cordial and understanding but they were no help. If Dell wants satisfied customers they are going to need to address the problem of effective communication. Just pushing someone from one rep to another will not work, it frustrates people and eventually they will give up and go buy another computer (ok, maybe that’s a little extreme). My fear is that Apple may go down this road and end up with the same problem. I am hopeful that they will catch the problem before it gets too far.