Monthly Archives: March 2013

Secure Remote Backups on the Cheap

Posted on March 26, 2013 by todd

Like many “technically minded” families we have started to accumulate a startling amount of data at home.  A couple hundred gigs of storage on the file server used to be more than adequate.  I did a pretty good job of making sure … Continue reading →

Posted in Linux General | Leave a comment

Getting Permanent Marker off a Whiteboard

Posted on March 18, 2013 by todd

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

Posted on March 15, 2013 by todd

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

Posted on March 5, 2013 by todd

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