SSH options for $remote

PermitRootLogin yes
PermitTunnel yes

As root@$local

ssh -w 0:0 root@$remote 'while true; do echo "[$(date)] $(uptime)"; sleep 10; done'
ifconfig tun0 192.168.1.2/30 192.168.1.1

As root@$remote

ifconfig tun0 192.168.1.1/30 192.168.1.2

This will set the remote endpoint to 192.168.1.2 and the local endpoint to 192.

Despite having used them awkwardly before, the ranking functions in SQL Server finally clicked for me. Compared to the gymnastics I have gone through to emulate such functions in MySQL, this is downright gorgeous. Instead of going on at length, here's an example. The best T-SQL median query ever made.

SELECT ( Read more... )

A quick anecdote.  I was struggling to find a good way to keep track of some sensitive docs, such as my password list and financial information.  For a while I carried these around on a flash drive, but that never sat right with me.  Plugging it in all the time was a real drag.  And heaven forbid I dropped it; someone could have unfettered access ( Read more... )

I finally gave in.  I'm using iTunes to maintain my music library.  I'm still tagging with MusicBrainz, but then tweaking a bunch of stuff in iTunes.  Here's the basic workflow:

1. Add files to itunes
2. Load from itunes music folder into musicbrainz
3. Tag but don't rename
4. Reload updated metadata in itunes and clean it up by hand

The hand cleanup goes like this ( Read more... )

I love MusicBrainz a whole lot, but there are a few things I don't like about their data.  Eventually I will come up with some way to override these things automatically (perhaps with Picard plugins), but for now I'm making a raft of changes by hand:

• Artist name substitutions.  Say all you want about "original intent", but I get really agitated by ( Read more... )

I was curious if my political tendencies have shifted, so I took the excellent political compass test again. My scores are about the same as I remember them. Perhaps I shifted a little to the center in the economic scale, but I'm still in the same quadrant. Without further ado, here are my results:

The Political Compass

Economic Left/ ( Read more... )

I heard a story on NPR the other day which, at first, made me incredulous. It was discussing MPG vs GPM as a useful measure of fuel efficiency. It stated that a smaller increase in MPG at the low end--say, 10 MPG to 15 MPG--was worth more than a bigger increase at the high end--say, 30 MPG to 50 MPG.

Intuitively, this seems ridiculous. But once ( Read more... )

(8:20:15 AM) William: 10.1.2.9 was down ( Read more... )

Googling will reveal issues with duplicated artists to be fairly common, but the solutions always center around fixing spelling errors, removing spurious spaces, or cleaning up other textual errors in the tags. Since I'm a MusicBrainz tag nazi, this isn't the problem for me. After a bit of flailing and comparing tracks from these problematic ( Read more... )

After using Google reader for a while, I've built up a pretty good list of subscriptions. In case anybody is interested (and as a bit of return on investment for those who helped me build up my initial list of feeds), here are the feeds I'm currently subscribed to. Enjoy.

• An Antic Disposition
• Bills due
• Cheap Eats
( Read more... )