Author Archives: todd

Getting Permanent Marker off a Whiteboard

The other day while taking notes during a conference call I accidentally wrote on my whiteboard with a Sharpie marker. After several minutes of swearing I remembered a tip I had heard years ago. Using a white board marker scribble … Continue reading

Posted in Life Hacks | Leave a comment

Batch gpg Decrypt and Unzip

In Linux: To batch decrypt with gpg: echo {yourpassphrase} | gpg –passphrase-fd 0 –decrypt-files *.pgp To batch unzip: unzip “*.zip”

Posted in Linux General | Leave a comment

Common SQL Server Troubleshooting Queries

Last Query for All Open Connections (source): SELECT    * FROM    sys.dm_exec_requests er     CROSS APPLY    sys.dm_exec_sql_text(er.sql_handle) AS t Number of Open Connections (source): SELECT      DB_NAME(dbid) as DBName,      COUNT(dbid) as NumberOfConnections,     … Continue reading

Posted in SQL Server | Leave a comment

PayPal Link Generator

PayPal used to let you create a payment link in addition to the current payment button. ┬áThe link was nice for a quick and dirty method when the button wasn’t needed, but PayPal seems to have done away with it. … Continue reading

Posted in Geeky Stuff | 1 Comment

Quick DVD Backup to ISO on Linux

I often want an easy command line way to easily backup a standard definition (non-BlueRay) DVD to and ISO image.  The command line is nice because I can do it remotely on an idle MythTV Frontend machine and can copy the … Continue reading

Posted in Linux General, MythTV | Leave a comment

Remove Unsed Linux Kernels

I hate manually cleaning out all of the old kernels here is a script to do it for you: dpkg -l 'linux-*' | sed '/^ii/!d;/'"$(uname -r | sed "s/\(.*\)-\([^0-9]\+\)/\1/")"'/d;s/^[^ ]* [^ ]* \([^ ]*\).*/\1/;/[0-9]/!d' | xargs sudo apt-get -y purge … Continue reading

Posted in Linux General | Leave a comment

DSM Links

Road Racing Upgrade Path:

Posted in 24 Hrs of LeMons / Chump Car Racing | Leave a comment

Spam-me-not E-mail Link Obfuscator

Posted in Geeky Stuff | Leave a comment

Ultra Marathon Race Web Sites

Posted in Uncategorized | Leave a comment

Roomba Blink Error Codes

The little light to the left of the Clean light on the 500 series, which if it is there can look like either a little Roomba or an exclamation point is called the Check Robot light (according to the Customer … Continue reading

Posted in Uncategorized | Leave a comment