SELECT * FROM Week WHERE DAY = ‘Friday’

  • I’m searching through a table with 15 foreign keys trying to find a specific person on a specific day, then find out which foreign keys are actually meaningful. ‘LastModifiedBy’ is one I can probably skip. But this one stored procedure has been my biggest timesaver this week.

sp_fkeys @fktable_name = ‘<TABLENAME>’

  • I’m searching through the SALE and TRANS tables trying to find discrepancies. On the surface, they look identical [same number of rows, same number of distinct rows, same dollar total]. But a report I don’t trust anyway says there’s a $4000 difference. I got to say this to Amy Accounting: “I’ll be happy to look into it but it won’t be today; there are too many other important things.”
  • I’m running 4 different IM protocols, talking over all of them to coworkers, vendors, friends, and more coworkers.

Finale of Battlestar Galactica tonight, 8pm Central. I’m going to run/walk 7.5 miles tomorrow morning. I’ve got to pick up a new Rock Band guitar controller, new insoles for my running shoes, clean my kitchen, and at some point get 8 hours of sleep.

Battlestar Galactica – The Board Game

I didn’t know what to think of it at first, since it just seemed like overt merchandising. But it came highly recommended so I gave it a long look. Turns out, Travis already bought a copy. So we played a trial run Thursday night with 4 people and played 2 games Friday night with 5 people. There is a lot to love with this game.

I’m a sucker for strategy games and some of my favorite games combine strategic movement/placement on the game board with game politics between players. The Battlestar Galactica game puts a whole new spin on things. Politics is the foremost skill in the game and strategy and tactics flow from the political climate of the game. It uses an entirely different side of the brain and when the second game ended just after 1 am, all 5 of us weren’t really tired and probably could have played another one.

Here’s the kicker: in a game of 5 people, 2 people end up being cylon. There are about 10 ways for the cylons to win, but the humans win if they can survive long enough to reach earth. In both games last night, Herch and I drew the cylon loyaty cards and we got back to back turns. We destroyed so many civilian ships, we took the population down from 11 to 1 in two rounds. It was devious fun. And I’ve been on the human side of things too, because as soon as the cylons start to get a bit of momentum there’s a real sense of panic because you can just feel the game slipping away.

I can definitely see this game being in the regular rotation.

And I was on vacation all this last week, so I’m caught up on sleep and caught up on a few tv shows. Part of me wanted to get out of town for a while, I even priced a 3 day trip to Arizona for the start of the Cactus League, but as soon as the Mariners signed Ken Griffey Jr, all spring training tickets at Peoria Sports Complex sold out by the end of the day. Too bad, because the Mariners squad embarrased the Dodgers 18-2 and that would have been fun to watch.