This, boys and girls, is precisely why having AWD in the snow doesn’t do you one bit of good if you have summer tires on your car. Yet another reason why I will continue to advocate having a dedicated set of snow tires in the winter.
Auto-Journals.com’s Nissan GT-R in the snow.
Following the theme of my favorite iPhone apps, I should keep an updated list of my favorite Android apps.
At the time of this writing, I’m using an HTC Eris on firmware 2.1.
So let’s say you’re working in Excel 2007. You’ve got a workbook with many worksheets inside, and you need to create a cell reference from one sheet to another. But what happens if you have hidden rows in the sheet you’re referencing from?
Depends on how your options are set. One of the things I noticed is that if you have the Lotus 123 compatibility options selected, Excel will not only unhide the hidden rows in the sheet you’re referencing, but it will also not hide them again.
It should be mentioned that this behavior is not enabled by default, but if you should run across it, here’s how to turn it off:
Click the Office Button -> Excel Options. Click the Advanced section, and scroll all the way to the bottom. Uncheck Transition navigation keys, Transition formula evaluation, and Transition formula entry.
Did you find this information useful or helpful? If so, buy me a cup of coffee. 
A post to be updated over time…
Currently using 3.0.1 under a jailbreak.
Favorite Themes:
- Illumine (pictured)
- Glasklart
Favorite Addons:
- Five Icon Dock (pictured)
- SBSettings
- OpenSSH
- PrivaCy
- Winterboard
Favorite Apps:
- iBlacklist (Cydia)
- GV Mobile (Cydia)
- MobileTerminal (Cydia)
- MxTube (Cydia)
Way to go, Microsoft… hiding shit from me.
So as part of this new database development project I’ve been working on, I’m having to normalize and unwind an unwieldly Excel sheet that’s chock full of intermixed data within the same columns. Values, ranges of values, integers, currency, percentages, and text. Yeah.
As part of the conversion process and figuring out what algorithms to write to unwind the data, I’m using the Visual Studio 2005 Business Intelligence Development Studio to run my data conversion and SQL population tasks. One of the things that’s SERIOUSLY irritated me from the get-go about this tool is that the Excel OleDBConnection object flat out ignores data, or gives its own interpretation as to what it thinks a certain column’s datatype is. (STUPID.) This ended up throwing errors that wouldn’t even output to the specified errorOutput columns – just to a dialog box that said it gave up. In short, it wasn’t able to convert from the datetimestamp datatype from Excel to the datetime datatype in SQL.
I showed this to my resident data warehouse SQL guru guy, who was having a similar issue with a project he was working on. Apparently, there’s a not-so-well-documented “feature” in the OLEDB connection string (used in BIDS) whereby if you append the value IMEX=1 to the end of it, it forces the data flow task to read all intermixed data as a string. Dates, integers, strings, whatever. (Verified by connectionstrings.com). The Data Conversion step in my workflow task FINALLY started behaving normally and doing what I asked it to to – including throwing data into the correct external columns and everything in my test table. WOOHOO!
Now the fun of trying to figure out how to un-wind the cluster of integer strings and values in my dataset. *Sigh* Any cursor gurus out there? 
As an avid WoW geek, and CGI aficianado, I found the following video absolutely amazing. It came through an RSS feed this morning, and after a little bit of digging I found that it’s made by a guy named Percula Craft. Though it’s been posted across the net on Vimeo and YouTube, it seems to have stemmed from HERE.
With racing season at an end for the year and riding season soon to follow, I will have more time to dedicate to making this blog a little more focused and interesting.
Stay tuned in the following months for updates.