Tag Archives: howto

Merge Excel spreadsheets with common columns

Today I had a problem that is a non-starter when dealing with relational databases: I needed to do an inner join on two sets of data. Instead what I had was two Excel spreadsheets, and it ended up taking much … Continue reading

Posted in Uncategorized | Tagged , | 9 Comments

How to check database type of subversion repository

Doing some maintenance on my Subversion repository --namely taking out a directory and creating a new repository with only that directory-- I wanted to find out how to check what type of database (FSFS or Berkeley DB) my current svn … Continue reading

Posted in Uncategorized | Tagged | 2 Comments

Select boot device key on Sony Vaios

Most BIOSes nowadays have a feature whereby pressing a specific F key brings up a one-time boot device selection menu, handy for operating system (re)installs. The BIOS on my new Vaio didn't display any information regarding keys (not even how … Continue reading

Posted in Uncategorized | Tagged | 23 Comments

Find XPath to any element quickly with FireBug

Edit: I found out that right clicking on a tag in Firebug's HTML tab and clicking on "Copy XPath" is a much quicker method. I just discovered a way to quickly find the XPath to any element on a webpage … Continue reading

Posted in Uncategorized | Tagged , | 1 Comment

"Logon failure: unknown username or bad password." when trying to access Windows XP share from Windows 7

After a recent Windows Update I could no longer access the folders on my Windows XP file server. A window popped up asking for a username and password even though they are both the same on the two computers. The … Continue reading

Posted in Uncategorized | Tagged , , | 62 Comments

Turning screen off with "Access IBM" button

My trusty old T43 has a blue "Access IBM" button just above the F-key row that has sat unused ever since I first reinstalled windows. The other day while browsing the thinkpads.com forums I found an interesting use for this … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Windows 7 open command prompt from right click context menu

Windows XP had the PowerToys, which added useful functionality to the system. One of my favourites was the "CMD Shell here" PowerToy, which opened a cmd prompt with its working directory set to the folder you were in. Vista incorporated … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Vista/Windows 7 Links toolbar on taskbar - how to remove 'Open file security warning'

A few years ago I discovered that the links toolbar is a zillion times better than quick launch. The links toolbar allows you to create folders and group common program shortcuts in them. When you click on a folder a … Continue reading

Posted in Uncategorized | Tagged , , | 2 Comments