PuTTY or one of its forks is a standard tool for administering Unix and Linux machines from Windows. It provides SSH connectivity for command line access, as well as keypair management for compatible programs like WinSCP. Unfortunately, PuTTY has some terrible defaults. For example, it limits itself to 200 lines of scrollback by default, which … Continue reading Set PuTTY defaults, permanently
Sometimes when my VPN connection to work goes down, certain applications that rely on intranet servers (e.g. Lotus Notes, Lotus Sametime) become unable to reconnect to their servers even after I reconnect to VPN. This is due to the operating system's DNS lookup cache reusing the failed hostname lookup from when VPN was down rather … Continue reading Fix VPN hostname resolution by flushing your DNS cache
I had an exciting tax year (lots of RRSPs, bought a house), so I picked up a copy of TurboTax 2012 to help file my Canada income taxes. Unfortunately, TurboTax crashed on startup and running it as Administrator did not help. It turns out there is a known workaround involving copying some DLLs around.
I do some reporting in Excel. The reporting involves loading data via ODBC from a DB2 database. Excel is pretty zippy with its pivot tables once the data is loaded, but setting up the initial connection can be tricky. Windows 7 is the first Microsoft operating system where the expectation is that the consumers would … Continue reading ODBC and 32-bit Excel on Windows 7 x64
I'm setting up a new primary system and I thought I'd jot down some notes. Ninite is probably the quickest way to install all the necessary software (Chrome, 7-zip, Dropbox, iTunes, Picasa, etc). You click the checkboxes and it rolls you a custom, hands-off installer. They upsell to an auto-update service, but there are free … Continue reading Setting up a fresh Windows system
It's fairly straightforward to diff or compare different revisions of an Office document on Windows. The approach below applies to Word, Excel, and PowerPoint files, as well as to ones created by Lotus Symphony, OpenOffice.org, or LibreOffice. Download and install WinMerge. This is a free, open source utility. Download the xdocdiff plugin. Unzip it somewhere. … Continue reading How to diff Word documents
My team at IBM recently released DB2 Express-C 9.7.4, the latest and greatest version of our free database. Raul wrote up a detailed article with the technical nitty-gritty of what's new. There's a bunch of different improvements, but one thing that's caught my eye are the enhancements to triggers. A trigger is something defined to … Continue reading Triggers in DB2 Express-C 9.7.4