Posts from: February 2010

22 Feb 2010

Guitar Tuning By Ear

(This is edited from an answer I posted to KeyMinor, a music Q&A site. They need more users!) A lot of recordings end up slightly higher/lower than standardized pitch (I always called this “in the cracks” but don’t google it!), and this is the quickest way I’ve found to tune a guitar to them.  This

[...read the post]
In
16 Feb 2010

SQL Server Mgmt Studio Can’t Export CSV

I’m trying to export large (e.g. 16M rows) SQL Server 2008 views for eventual import into MySQL. The underlying setup for these views is bizarre: A SELECT for a single row can take over two minutes, a SELECT * FROM view with no WHERE clause is much faster, but still too slow to finish an

[...read the post]
In
15 Feb 2010

Bash: unbom (to remove UTF-8 BOMs)

Tests for and removes UTF8 BOMs. #!/bin/bash for F in $1 do if [[ -f $F && `head -c 3 $F` == $'\xef\xbb\xbf' ]]; then # file exists and has UTF-8 BOM mv $F $F.bak tail -c +4 $F.bak > $F echo “removed BOM from $F” fi done USAGE: ./unbom *.txt The magic is tail

[...read the post]
In
12 Feb 2010

Could this be an OpenSSH bug?

Last week I tried to SSH into my webhost account (on Site5) from work and—forgetting my password—it locked me out after several failed attempts. SSHd would just close the connection without asking my password. work:~$ ssh user@example.com Connection closed by xx.xx.xx.xx I could log in from any other location, so I figured it was an

[...read the post]
In
7 Feb 2010

Chord Theory: 13 is probably 7(13)

A 7th add 13 chord is often voiced r-5-7-3-13, sometimes leaving out the fifth. To pin this to a key, a G7(13)—G⁷⁽¹³⁾ if your chart can handle Unicode—is usually voiced G-D-F-B-E and is a common (in jazz and standards anyway) way to make the resolution from G7 to C more subtle and harmonically interesting. In

[...read the post]
In
4 Feb 2010

David Rawlings and Gillian Welch on Tiny Desk

Amazing performance and recording. Apparently David’s a great writer, too. I need this album.

[...read the post]
In
3 Feb 2010

AFA Leader Would Like to Fix Gays by Force of Law

I support the American Family Association’s right to pay for the Tebow ad—Americans have no right to not see promotions of ideas they might disagree with—but the AFA’s new leader, Rev. Bryan Fischer, should be watched. He has an interesting idea to fix a country that’s so broken that gays can…continue to exist: Fischer suggests we

[...read the post]
In