Author Archives: todd

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: http://www.dsmtuners.com/1g_dsm_road_racing_setup

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

Spam-me-not E-mail Link Obfuscator

http://www.ianr.unl.edu/email/encode/

Posted in Geeky Stuff | Leave a comment

Ultra Marathon Race Web Sites

  http://www.marathonguide.com/races/races.cfm   http://www.ultrasignup.com

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

Setting default Runlevel

  This was written for Fedora, not sure how many other other distros it applies to. There are three ways to change your runlevel:  * While the Computer is Running:  1. Open a Terminal.  2. Become root.  3. Type:  init … Continue reading

Posted in Linux General | Leave a comment