My First NASCAR Race

As promised, I’m finding the time to recap my experience from the weekend when I attended my first NASCAR race.

7:00 am – Departed my house, which is north of Atlanta and headed for the speedway, which is south of Atlanta. Without traffic, this should be a 1 hour trek. I had been advised to depart at 6:00 am if I really wanted to beat the traffic, but I like living on the edge. (and keep in mind the race doesn’t start until 1:15, but I figure seeing the big party in action before the race would be at least half the fun)

7:45 am – The first signs of heavy traffic.

7:50 am – Officially hit gridlock.

9:00 am – Getting pretty edgy by now and my initial interest in peeking in other cars to see just how totally rednecky the occupants were has worn off. I also have to pee.

9:15 am – For no apparent reason my wife urgently tells me to turn off at the first possible place to enter the track parking lot. This is in spite of the fact that we’re meeting some friends at ‘Enterance C’ and these friends repeatedly told us that if we stay on the main road we can’t possibly miss it. I know this, and yet that knee-jerk reaction to take the “obey” part of the marriage vows seriously kicks in and like a dumb*&s I make the turn. There’s something in the Official Woman’s Handbook that says they have to pull this crap at least once on every roadtrip. There’s probably a whole chapter dedicated to it actually.

9:17 am – By now, it’s clear to everyone in the vehicle that this wasn’t the right thing to do. We just passed ‘Enterance M.’ What’s worse, is that about 100,000 people are filing into the area behind me and naturally the street is a one way flow, so there’s no real way to backtrack without 1) pissing off thousands of drunk rednecks 2) getting arrested or 3) pissing off thousands of drunk rednecks and getting arrested.

9:18 am – My dad is even chiming in from the backseat now with his usual pessimism, and I’m feeding off it. You go dad.

9:20 am – There’s nothing left to do but hang the U-ey. It actually turned out alright and I carved out a single lane all the way back to the main road. Once the lane was established, it was smooth sailing since I was the only dumb%*s leaving the race.

9:30 am – Sure enough, there’s ‘Enterance C’ – couldn’t have freakin’ missed it if someone had thrown a vial of acid in my eyes.

9:31 am – Parked the Honda Pilot and said our hellos to our friends. Krista’s uncle Jackie, his wife and their friend had arrived about 7:00 am and had taken the liberty of introducing themselves to Krista’s friends and they had all hit it off.

9:32 am – Took a leak in the woods. Noticed that every tree within sight had been singed up to about eight feet in what must have been a pretty serious fire. I’d bet everything I have that the blaze started on a race weekend and involved alcohol.

9:35 am – Krista’s friends offer food – leftovers from breakfast that they made in their 5th wheel. Breakfast is biscuits with tenderloin steak and it is top notch. I shamelessly scarf down three and in doing so polish off the tenderloin. Things are looking up and the weather is really perfect as well.

9:45 am – By now I have marked my territory by setting up the portable lawn chairs and getting the cooler out of the Pilot. I start with iced tea to fuel up and get some energy.

10:15 am – Ok, after spending 1/2 hour sitting around and making idle chit-chat there’s really no way to avoid cracking open a beer. My stash includes a 12-pack of Coors Light, a 12-pack of Amstel Light and four 25.2 ounce cans of Labatt’s. (a.k.a. “Big Blues”) I’m truly disappointed in my choices. I should have just gone with pure Bud Light in massive quantities or maybe even good old school leaded Budweiser. Two-thirds of my stash is clearly too uppity for the crowd, and the other choice helps funds a major Republican contributor – albeit that too fits with the NASCAR motif and I don’t really have any complaints about Coors Light, except that it is impossible to get drunk on the stuff but that wasn’t even really my main concern and I needed a beer that I could drink non-stop for 6-8 hours in the sun and that one fits the bill if I’ve ever seen one. My dad seemed to want Coors Light too, so that’s how it went down. For the record, I decided to get things primed with a Big Blue. Yum.

11:30 am – Two Big Blues in the tummy now and I’m enjoying life. I’m told it’s time to pack up the plantation and head over to the race. A race official has me move the Pilot to block a possible exit, as folks won’t be allowed to leave from this area until two hours after the race to help control the crowds. I do as I’m told, even though a voice in the back of my head tells me that I just turned my 2004 Honda Pilot into an open invitation to be rammed by a big pick-up truck.

11:50 am- Just spent 20 minutes walking past a never-ending series of trailers, almost all of which had race flags flying and something to burn things in located near the trailer.

11:55 am – Decide I might try to empty out the colon so I enter the restroom.

11:55:01 am – Change my mind after seeing my options.

12:00 – high noon – Enter the track after a quick cooler search.

12:01 pm – My first true epiphany of the day. I almost stop in my tracks when I realize that I was just allowed to enter a major sporting event with no less than 20 cans of my own beer. I think it is the greatest civil liberty I’ve ever been afforded.

12:15 pm – Not much to see in the concessions area actually. Lots of places selling overpriced t-shirts that couldn’t have less appeal to me. I know the whole “When in Rome thing” but lets face it, I’m only taking it so far. I do feel out of place having a collar on my shirt. In fact, I would have felt more in place wearing no shirt at all. I’m not kidding, I’d give more than even money that there were more shirtless people there than there were people wearing shirts with collars. For the record, it was actually a race shirt too. Krista’s brother bought it for me, and it’s a golf shirt for Elliot Sadler, who drives the #38 M&Ms car. Turns out he went to JMU, so my brother-in-law decided he should be “my guy.” Fine by me.

12:30 pm – In our seats now, which are about halfway up the stands right in front of pit row with a clear view of the whole track. Oddly, my first impression is that that the track isn’t as big as I thought it would be. I do note that the turns are banked like crazy, which doesn’t really translate with any justice to tv. I also think I’m going to like being right in front of pit row.

12:45 pm – Crammed in now, but Krista’s uncle comes to get us and bring us over by them where there must be a lot of no-shows because there are many empty seats. That works out well and the people never show up.

1:00 pm – Driver introductions, which consist of the drivers being paraded around in the backs of pick-up trucks and they wave to the crowd. I found this to be pretty gay. Dale Earnhardt Jr. got an insane amount of applause, and I’d estimate that his fans outnumbered any other driver’s fans by about an 8-to-1 ratio. Jeff Gordon was booed intensely. As far as I can tell, he’s disliked because he’s pretty much a normal white guy and not a total hick.

1:05 pm – Lets get this party started. Um, saying a prayer and thanking Jesus Christ over the loudspeaker wasn’t exactly what I had in mind. Big demerit for autoracing gets filed away in my head. Did I mention I brought 20 of my own beers in without any hassel about it at all? Do those things cancel each other out, or am I still ahead in the game?

1:06 pm – Fly-over by a B-2 bomber. Pretty cool.

1:07 pm – Fly-over by two attack helicopters, one of which lands and the pace car drives out the back. That’s a pretty nice touch and it draws applause. I bet Krista and I are the only people here that didn’t vote for George Bush.

1:09 pm – Time to stand for the National Anthem. It’s sung by some country singer named John Michael Montgomery, or something like that. The guy definitely had three names and he drew quite a bit of applause himself. He proceeds to butcher the National Anthem unlike anything I’ve ever heard in my life. He’s not really singing, he’s kind of just talking, and getting words wrong, and going painfully slow. I didn’t think it would ever end, and it was an absolute all-timer in terms of unintentional comedy.

1:10 pm – Fly-over by a C130J tanker in action, refueling the helicopters, horribly mistimed well before the National Anthem is over because this guy just can’t get through it.

1:11 pm – The National Anthem is mercifully over. John Michael Montgomery, or whatever the hell his name is, proceeds to try to walk off the makeshift stage, and the drunk bastard literally falls down the stairs and lands face-first on the asphalt. I’m not making this up.

1:15 pm – Gentlemen, start your engines. The ensuing roar appeals to the 12-year old boy in more a little more than I should probably admit.

1:16 pm – It didn’t take long for a major crash. Unfortunately it happened on the other side of the track, so all I could really see was a few nondescript cars spinning around and a lot of smoke. Somehow Krista’s uncle can give me the entire run down on the crash including who caused it and why. I’m impressed.

1:17 pm – The smoke starts to clear to reveal that Jeff Gordon’s car was involved and a great roar of joy is released from the crowd. Rather pitiful, and Jeff drives off the track to the garages to many jeers. Note to self: If I ever want to get my ass kicked, buy some Jeff Gordon gear and head over to Proud Mary’s Dart Bar.

1:30 pm – Things are back underway and I’m actually starting to enjoy this. Like I said, I’m enjoying the noise. I like it the best after a re-start and all the cars are together in a pack because there’s relative quiet while they go around the track and then this really big zoom, zoom..when they all go by. I also can’t help but note how fast they go. Again, hard to tell on tv, and I know this is an obvious statement, but they zip around at an unreal pace.

1:45 pm – Krista’s uncle, along with 50,000 other people, have a scanner that lets one listen in on the different driver radios so one can hear them talk to their pit crews. It comes complete with a guide that shows which frequency each driver is on, along with the option to just scan the airwaves for action. This keeps me entertained for quite some time.

2:00 pm – Uh-oh, picking up some serious action on the scanner as someone is frantically saying “There’s a leak upstairs! We’ve got to get to that thing before it gets down below!” Hell yeah, I’m getting to hear the racing lingo first-hand. Must be a serious oil leak or something.

2:01 pm – I realize I actually picked up some cleaning crew frantically trying to fix an overflowing toilet. No kidding.

2:30 pm – The beer is really starting to go down smooth and fast now. I’m also enjoying peanuts. Every time I open a beer I think about how freakin’ great it was that I got to bring my own beer in with me.

2:35 pm – Jeff Gordon drives back on the track and receives a lot of jeers and laughs, since he’s about 100 laps behind by now.

2:45 pm – I’m not enjoying the fact that smoking is permitted in the stands, but at least I have a solid 15 cans of beer left so I can’t really complain. My dad, on the other hand, seems to be taking a liking to this civil liberty as well. My dad is also almost completely deaf in one ear, and coupled with the extreme noise, it’s almost comical how little he can hear of what is going on around him. It doesn’t seem to bother him a bit though.

3:55 pm – I dabbled in the Amstel Light early, but by now I’m drinking exclusively Coors Light at the rate of about one per ten minutes. This race is pretty long and truth be told, not much is happening. Two cars have clearly dominated all day and on each re-start they fly out ahead of the rest of the pack. I’ll be shocked if one of these cars doesn’t win the race.

4:05 pm – Probably my 4th or 5th trip to the bathroom and it gets more disgusting each time. Trough urinals just aren’t classy and probably 80% of the stalls are clogged and overflowing. I allow myself to think about the logistics and difficulty of human waste disposal for 100,000 drunk people for about ten seconds and then I muster the willpower to purge the thoughts from my head, take care of business, and get the hell out of Dodge.

4:20 pm – I actually run out of beer. I’ve been drinking for nearly 20 years and I still consistently underestimate how many beers I’ll need for an outing. This isn’t quite as bad as the JMU National Championship debacle where we plowed through our entire supply of 30 beers and ended up bumming Natty Light from 20-year olds in the parking lot before kickoff, but it’s still a shameful disgrace. My dad and my wife did their share to help. Once again, Uncle Jackie hooks me up, and with an old school can of Budweiser. Right on.

4:45 pm – Things are winding down now. I’m pretty worked up to see the end of the race, even though I’m almost certain Jimmie Johnson is going to win. Uncle Jackie even apologizes for the lack of drama.

4:50 pm – The last lap, on the last turn, the #99 car driven by Carl Edwards makes a move on the outside and tries to pass Jimmie Johnson on the outside. He pulls ahead by what must be inches as the cross the finish line and wins the race. It was much more exciting than those two sentences might lead you to believe. That guy was sly, lurking the shadows the whole race. He had everyone fooled, not just novices like me. Plus, he’s got the homage to Wayne Gretzky thing going on by using #99. (Ok, so the homage is very likely unintentional) He spins out his car on the infield, gets out, and does a backflip off the read end. That’s worth some style points I guess.

5:00 pm – Leaving the race, well buzzed and a little pumped up from the exciting finish, I’m actually handed a complimentary packet of Tums on the way out. Really. Like a parting gift or something, and a useful one at that. There was literally a girl standing there handing out Tums to everyone who left. Odd things indeed.

5:18 pm – Hey, there’s the Honda Pilot and it doesn’t look trashed or anything. I’ll be damned.

5:20 pm – Back to the camper now and trying to get the Ga. Tech game on the portable Directv setup they have, but finally settle for the radio version. Louisville is kicking their asses. So much for that. Two hours to kill before we can leave, but we’d just be stuck in traffic anyway. One final brewski and then I start to hit the Gatorade hard.

6:00 pm – Three 20 oz. Gatorades later I’m back in the saddle and heading off to the woods to pee about once every four minutes.

6:20 pm – I am fed a delicious ham sandwich.

7:30 pm – Well sober and worn out and time to drive home. Nothing much to report, except that this too took about 2.5 hours, even with sitting around and waiting after the race. If I ever do it again, I’m heading down the day before and staying until Monday.

That is all. This is plenty long for now but I’ll add some more wrap-up thoughts at some point.

Posted in general | 2 Comments

Hogzilla!

Georgia’s Hogzilla exposed!

Hogzilla was a supposed 12′ long, 1000 pound wild hog. The only evidence was a picture of a huge hog dangling from a backhoe, dwarfing the man standing next to it. The hog was so big, some folks suspected it was really just an urban legend [snopes.com]. It actually generated quite a bit of buzz: [google.com].

Apparently, National Geographic decided to dig up the remains and verify the wild claims. NG’s folks estimated about 8′ long and 800 pounds. To me, that sounds like a matchup that ends up something like “Humans 0, Hogzilla 1”. Apparently, 8′ and 800 pounds is nowhere near as scary as 12′ and 1000 pounds. So 8′ is “large, perhaps even record-setting large, but not hide-the-children-and-get-your-guns large.” Yeah, right! Not from where I’m standing!

ob credit:
I am not ahead of the pack on this non-breaking news, I picked it up from Boing Boing: [link]

Posted in general | 1 Comment

Petit-Jean, Arkanasas

Took a quick trip to Petit-Jean, pronounced Petty-Jeen for those not in the know already, last weekend. The weather was great and it was a good opportunity to get outside. Jennifer and I also used it as an opportunity to test out several pieces of equipment.

The Honda Element we bought to replace our ailing GMC van has been just great so far. The Element really fits our lifestyle. High points are the nice sound system with XM radio, it is easy to clean, and gets better gas mileage than what we had before. The vehicle is much bigger on the inside than one expects looking at the exterior. As far as being versitile, the rear seats are easy to fold up against the side of the vehicle. They are also easy to remove completely. Much easier that removing full size bench seats for the van!

Petit Jean State Park is about 75 miles or so northwest of Little Rock. Check out this really cool Google Map. I wasn’t able to get exactly to my location using the search box, but you can see that Petit Jean State Park is marked on the map. As an aside, there are some cool hacks out there for Google Maps- more on that another time.

The trip there was just fine- I was in a bad mood because the dogs were hyper and Zoe was panting like crazy in my ear sporadically throughout the trip. Fortunately, thank God, my wife gives me some leeway when I am feeling and acting like a jerk. After a while, my mood cleared and we had smooth sailing.

Petit Jean 01 This is at the start of our trip. The pack on Jennifer’s back is deceiving. This is a very short hike- only about 3 miles round trip. Jennifer is wearing her pack so she can start breaking it in. That’s in preparation for our Grand Canyon trip in May! That is the second piece of equipment we were testing out. The camera used to take the pictures with is the third- it is a AIPTEK DV4500 model camera/video record/mp3 player. I have yet to master taking decent pictures indoors or using the zoom, but it performs well enough outdoors, as can be seen here. All of the pics here have been scaled down at least 50% from the original size.

The hike is pleasant. There is a large red sign declaring the hike to be strenuous. Jennifer and I did not find the hike to be strenuous at all. I imagine that the warning is intened to discourage unhealthy people from the hike. It was steep here and there, but there are plenty of switchbacks and no part of the hike proved particularly taxing. The hardest part for me was keeping a handle of the two energetic dogs. It was wet in places and I was more concerned about the dogs pulling on their leash and causing me to slip and crack my head open.

The weather was good and the walk was refreshing. Spring foliage was not out yet, but the view was still pretty to see- click the thumbnails below to see bigger pictures:


petit jean 02

petit jean 03

petit jean 04

petit jean 05

petit jean 06

petit jean 07

The trip is culminated upon arrival at Cedar Falls:

Cedar Falls, Petit Jean State Park, Mar 5, 2005

The falls are about 80′ to 100′ high. I added an inset picture to give a sense of scale. The band of green moss that the arrow is pointing towards is probably about 4′ or 5′ tall.

Cedar Falls w/ people

The falls were well worth the price of a pleasant hike. In spring, the falls must be absolutlely gorgeous. If you haven’t already, take a look at the front page of the Park website.

More photos- click on the thumbnail to see the larger image:


petit jean 12

petit jean 11

petit jean 10

petit jean 14

petit jean 13

petit jean 15

Posted in general | 2 Comments

ODU Monarchs win CAA!

Monarchs, baby!
Old Dominion wins CAA Championship, guarentees a spot in the NCAA’s.

VCU took the Monarchs to overtime, but ODU put it away for a win. With ODU locking up the automatic bid, the CAA becomes a one-bid conference for the NCAA’s. With 27 wins, they were probably going to make it anyway, but it is all the better to take the CAA Championship.

[ESPN.com – game coverage]

Nice ESPN story: [link]

Posted in general | 1 Comment

iPod Review

Having lost my original 800,000 word post for this review, I will attempt what will likely be an abbreviated version amidst my great depression. Originally I wrote a long discussion about what I had to do to get the iPod, and I’m not going through all that again. Suffice it to say, I had to suffer a lot of spam and sign up for things like the BMG music club and the Blockbuster online rental club. The way I figured it, total expenses were roughly $120 + $15 per month for the Blockbuster club (which I am free to cancel at any time). For that cost, I got 12 cds from BMG, my wife got a bunch of books in some book club, some web space and we cancelled an account with Columbia House DVD club because their customer service and ability to actually deliver movies we paid for was a joke. (In fact I saved money by opting out of that, so consider I should have spent a bit more than $120 I guess, and was freed of any obligation because their failure to get me movies was beyond absurd) I also cancelled the web space, for which I had paid $89 for a full year and got a pro-rated refund minus a cancellation fee. Aside from tons of storage, I didn’t feel they provided me with anything more than what I get for free at geocities. (freeservers.com – although I will say they had prompt and friendly customer service)

Anyway, that was the out of pocket expense and we got that stuff + a 40 gig iPod. (which retails for $399)

For the reminder of the post, I’ll actually focus on the iPod.

Pros:

I like having 4,337 songs in my pocket. (my current total, which represents about 90% of my cd collection) On a whim, I can hear anything that strikes my fancy. So far I’ve used 17.2 gig of the memory, so I’m not even half way home.

Using iTunes and setting up the iPod is extremely easy. I simply ripped my cd collection or mp3s I got online into the iTunes library, where I can set up playlists and such. When I connect my iPod to my computer with a USB cable it automatically checks for any updates and syncs the iPod with what I have on my hard drive.

The ‘click-wheel’ control on the iPod is pretty sweet. Within five minutes of owning it I could operate it blind in my coat pocket to easily pause it, skip songs or adjust the volume. Simply brushing one’s thumb clockwise or counterclockwise on the click-wheel adjusts the volume and it’s extremely responsive to the touch.

Everything I needed was included in my package. Being an online offer I suspected that they might screw me and not give me headphones or the USB cable or something, but it was all there, including a little stand on which I can connect my iPod to a power source for charging and playing. From what I read online, that doesn’t even come with a lot of them. I also feared they might send me a hot pink one, but I’m happy to say mine is the standard white.

For $34.99 I can buy a FM adaptor that will allow me to play my iPod through my car stereo, so I can have my whole collection in my car, not to mention eliminate the clutter that comes with all the cds I have in the car right now.

Can survive a fall of about four feet onto concrete without suffering any noticeable damage other than a little scratch. Hopefully I won’t push my luck and try this out a second time.

Cons:

While it’s nice to have 4,337 songs in my pocket, the fact is I can only listen to so many in a day and I don’t often have the hankering to hear Track 10 of Reggata De Blanc, for example. So aside from a sense of great power, I’m not sure what having the 40 Mb iPod really gains me and I’d probably be just as well off with the 20Mb version (or maybe even the iPod shuffle). On the bright side, I don’t have to worry about economy of space and I have plenty of room to grow.

There is a “shuffle” feature, but as far as I can tell, it only applies to all the songs on the iPod. In other words, I can’t select a certain playlist and have it play only songs from that playlist randomly. For $400 retail, I would think it would have this feature, although to be honest I’m not sure how much I would use it. I can rate the songs from 1-5 stars, and the random feature will select the ones I like the most the most often, so at least that’s something.

The biggest negative seems to be the battery. A charge lasts approximately 12 hours. According to Apple literature the battery can be fully recharged roughly 150 times before it starts to lose its kick and will slowly fade away, with each charge holding less time. The battery can be replaced by sending it to Apple and paying them $99 to replace it. I’ve seen other stuff where batteries can be ordered online for about $40 with instructions on how to do it yourself, but there is still the matter of lithium battery disposal for the environmentally conscious. It should last a while, but for as much as I use it and plan to use it, the battery life is definitely finite and a maintenance expense.

Posted in general | 4 Comments

chimps go ape

According to CNN, a couple visiting their estanged chimpanzee, who had been living at an animal sanctuary since biting a woman’s finger off, was attacked by two chimps who escaped from their adjoining cage.

The man lost his nose, a foot, and his testicles before the rampaging animals were shot and killed.

I don’t have a whole lot of commentary except, “Holy crap!” This is sure to be all over the news, but you heard “Holy crap!” here first, unless you uttered it yourself whilst reading.

[Link]

Posted in general | 2 Comments

Admin notice

Spammers have figured out how to get through again. I will find a more direct method to resolve this as time permits. In the meantime, comments are being locked down. Please feel free to post and comment as normal, but there may be a lag as the comments will have to go through a screening process.

Moderators, assist when you are able. Thanks.

Posted in general | Leave a comment

Why news is stupid: reason #647

Watched the morning news as I was getting ready for work today. Howard Dean is now the chairman of the Democratic National Committee. Not really a surprise there, as that seems to have been the foregone conclusion for some time.

What is odd to me is the media talks about what a comeback this was from the debacle of his screechy scream given during his presidential campaign. The TV this morning replayed the screech in full glory, with commentary on how remarkable it was the Dean was able to overcome this tragedy of strategy. WTF?

CNN.com was a little less dramatic:

While avoiding the heated, emotional style of his infamous “scream” speech that contributed to his loss of the presidential nomination…..
[full article @ cnn.com]

So it was the scream that did us in and left us with Bush on one side and Kerry on the other. The scream? I can/can’t believe this can be reported as casual observance without mass reaction along the lines of “Did we, as the public at large, really cause/allow the dimissal of a viable candidate on the grounds of an unfortunate screech delivered during campaigning?”

Oh, Inverted World….

Posted in general | 1 Comment

Oracle and DECODE- updated

A few words about the DECODE function:

UPDATE is a bad thing to do. It runs slow, slow, slow. While UPDATE cuts the mustard just fine for small datasets, it is a killer for very large datasets being accessed by multiple users. When possible, it is preferrable to use DECODE statements.

A simplified example:
There exists a table, tbl_1. Tbl_1 has columns a,b,c and a column called ELIG_FLAG, that is currently defaulted to ‘0’ (zero). I want to mark as eligable those rows that have a= foo and b= bar. In other words, ELIG_FLAG needs to be set to 1 where a and b match the given criteria. In the bad old days(tm), I would do something like this:

UPDATE tbl_1
set ELIG_FLAG = '1'
where a='foo'
and b='bar'
;

Add more complicated criteria across multiple tables on several 10’s of millions of rows and the run time becomes catastrophic.

A better method is to combine the technique of temp tables with DECODE:

create table my_tbl
as
select a, b, c,
decode(ELIG_FLAG, '1', '0'),
from tbl_1
where a=foo
and b= foo
;

This kills two birds with one stone:
It creates a new temp table called my_tbl that contains only those rows that pass the eligibility criteria and updates the ELIG_FLAG attribute to ‘1’ for those rows. So, in one fell swoop, I reduced the size of the my dataset and updated the value of ELIG_FLAG. And the runtime performance improvement is quite substantial. In the very bad old days(tm), I might have used UPDATE to set the ELIG_FLAG and then used DELETE to remove the rows that didn’t pass muster. Very poor coding practice indeed!

DECODE works like this (in this instance):
decode ( name of attribute, new value, old value)

DECODE is capable of more things, but that is for another day.

Update: 02/01/2005
In this decode example, I am taking the STATE attribute values and transforming them into one of three values, and placing those values in a new attribute called RPT_STATE. It roughly breaks up into this psuedo-code if-else statement:

if STATE = 'UT', then RPT_STATE = 'UT'
else if STATE = 'WA', then RPT_STATE = 'WA'
else RPT_STATE = 'OTHER STATES'

This is a relatively simple example that lets me assign a default for all the values I want to lump together. Here is the table create code that does it:
create table &RPT_4_TBL
nologging
parallel (degree 12)
as
select
decode(STATE, 'UT','UT',
'WA','WA',
'OTHER STATES') as RPT_STATE,
SRVC_CARD_IND,
MKT_OPTIN_IND
from &REPORTING_TBL
;
commit;

Posted in oracle/sqlserver/database | Leave a comment

XM Radio: 1 month later

My lovely wife gave me an XM radio satellite receiver for Christmas. This is my take on it one month later. I was most pleased to receive this as a gift, as the relatively poor state of the radio in Little Rock has been one of my most vocal complaints about the area. There is little doubt that is was most annoying to those who had to hear it repeatedly. Of course, there is always NPR on the airwaves and Radioio on the internet. The problem there is that I don’t have an internet connection in my vehicle and some of those NPR programs can grate on the nerves. Most of the audio playing at home is coming from compact discs, vinyl, or the computer in the form of streaming media or mp3/ogg files.

The Music:
XM’s basic radio package contains dozens and dozens of channels. Each decade from the 40’s through the 90’s is represented by its own channel. There are multiple channels of country, split into channels for Old-Timey, Progressive, Top Hits, etc. I haven’t listened in yet, but I am interested in the Old Timey and Progressive channels. I am not sure what Progressive means, but if it is a departure from the over-produced “Big Top 40” sound of recent country music, than I am all for it.
Next in the lineup are the various “Hits” channels- mostly pop songs, which I generally find lacking. Something catchy hooks my ear every once in a while, and the movie soundtrack channel and showtune channel are also in this group, add a quirkiness that is much appreciated. Not my favorite section, but it gets some playtime.
What hasn’t had any playtime so far are the channels dedicated to Christian music, heavy metal/hair bands, urban, techo, classical, jazz, comedy, news, sports, talk, traffic, etc. Just not enough listening time to get them in the rotation.
So far, I find my self spending most of my time in the rock alternative channels. There is a college-like station, and several more alternative music channels with names from “I Love Lucy”. I don’t know if there is a code involved, but the channel name/descriptions look like this:

  • Fred- Classic Alternative
  • Ethel- Alternative Hits
  • Lucy- Classic Alt Hits

I don’t know where Ricky is- there isn’t a Latin or Cuban channel named after him.

Other channels of note :

  • XM Cafe- Mellow Alternative
  • The Loft- Singers & Songwriters
  • Unsigned- Unsigned Bands Only

The programming is quite extensive- check out the full channel listing here. [xmradio.com]

The Reception:
Not bad. I am using the weakest form of transmission, which is infrared FM modulation. I believe the next best solution, reception-wise is the cassette adapter. Not useful for me, as I do not have a cassette player in the vehicle. Better still is a direct connection to the stereo, with the best option being on the integrated units. The integrated unit would run me about $300, so that is currently not an option.
The reception is usually quite clear. Not necessarily CD quality, but still very good. On occassion, I am subject to light static. Unlike some other satellite radio listeners, I haven’t had my radio cut out when I enter the parking garage at work. I have had a brief hiccup in my reception going under certain bridges. In general, no complaints.

The Gear:
So far, I have really enjoyed having satellite radio. I have the Roady2 receiver made by Delphi. It looks like this (image linked from xmradio.com):

delphi xm roady2 image from xmradio.com

The install was painless. Of course, this model isn’t one of those fancypants expensive models that integrate into the car stereo. Actually, install might imply more work than I did. In that light, let me say that setup was painless. Routing an antenna wire underneath the windshield weather stripping to the inside of the vehicle was the only part that was even mildly tasking.

In about 15 minutes, I had the receiver setup and had signed up for radio service. It took somewhere in between 30 to 45 minutes before the signal came through on Christmas day, but it has been smooth sailing since then. For service, I chose the six month package. Service is $10/month, so this setup is going to have to really deliver to get me to continue to subscribe six months down the road.

One instant perk is the blissful absence of commercials. According to the XM Radio FAQ:

All of XM Radio’s music channels are 100% commercial free. Today’s FM stations carry 18 minutes or more commercials per hour.

No unreasonably amped up announcer sharing the news about the year end clearance event at Bob Howdy’s Auto Acres Extravaganza(tm). No commercials of any kind. I haven’t even heard pitches from XM itself, extolling me to try some of the premium content like Playboy Radio. Even the sadly dignified NPR pleas for support are absent, despite the fact that there is a NPR-like channel, called XM Public Radio.

Former NPR heavyweight Bob Edwards hosts his talk show on XM Public Radio. Other Public Radio favorites like Sounds Eclectic, Whad’Ya Know?, and This American Life are also present. This may not sound like a big deal, as just about everywhere probably has a NPR station, but this is a definite benefit. For instance, I don’t think Sounds Eclectic even airs on my local NPR station.

So I have had my satellite radio system for a month now. Even after a month has gone by, I feel like I am not getting the most out of it, which really is a result of not having very long drives.

I have done only minimal exploration. I am listening to XM in my car, so I can’t really play with the receiver and drive at simultaneously. Part of the problem is that the receiver’s current mount location isn’t really convenient for flipping through the stations. I am hoping to address this with the purchase of a remote control, a Roady specific model like the one below, linked from xmradio.com:

Roady2 remote (linked from xmradio.com)

Having the stand-alone receiver vs the integrated car stereo monitor has a hidden benefit. Delphi sells a kit that turns my Roady2 receiver shown above into a portable, Walkman style, audio player. At $150, the kit is a bit pricey, but it would make a great birthday present in April. From my lovely wife. For my birthday. As a birthday present. Second week from April.

Roady2 receiver in the portable kit
Some handy features taken from the product page at delphi:

  • Headset with built-in XM antenna for optimal performance
  • Extra volume control on the headset allows you to control volume of XM and FM stations without having to reach the main unit
  • Digital FM tuner – enjoy your Roady2 Personal Audio System when the XM signal is obstructed by metal buildings, overhead trees, etc.
  • Lithium ion rechargeable battery pack – lasts up to 4 hours in XM mode; at least 12 hours in FM mode
  • Docking station – for use with the Roady 2 receiver for portable personal application (connects your Roady2 to a power source, audio source and the XM antenna)
  • LCD screen with blue back lighting – displays FM station and battery life information

Did I mention this can be purchased directly from delphi at shopdelphi.com?

Posted in general | 3 Comments