SQL SELECT Clause Order Cheat Sheet & Other Opinionated Site Building Tips

Written by Gregory Milby | Monday, April 11th, 2011

Have you ever been building a SQL statement, and tried to remember which order your, “ORDER BY” goes in.  This short quick reference saves me some time – it’s not difficult, but if you’re like me, and do not use it everyday – it’s cumbersome to remember. These are the “mostly used” statements: FROM (Table [...]

No Comments

Setting Up A SSH Trusted Connection & Bash Alias To Speed Up Automated Scripts

Written by Gregory Milby | Wednesday, July 7th, 2010

Need to automate some scripts?  Tired of constantly entering ssh user@server.address, then the password?  Having a trusted connection can drastically improve productivity if it is used in the correct conditions.  If you’re using a public machine, then this is NOT SMART.  If you’re using a machine that anyone else has access to, then again, this [...]

1 Comment

Migrating from wordpress.com to wordpress.org or self-hosting

Written by TechZ | Wednesday, September 5th, 2007
, , ,

Recently I convinced my brother to move from a hosted WordPress.com blog that was doing rather well, to a self-hosted WordPress blog. After all, I had the hosting in place, web hosts offer so much nowadays that you can’t use more than a small percent of it. Not to mention he had a chance to [...]

12 Comments