mrclay.org

(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 method [...]

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 [...]

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
[...]

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 IP ban and [...]

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. [...]

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

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 [...]