Work | J.D. Hodges

Category Archives: Work

Fidelity Communications internet and phone service down

Thursday, 2014.04.03 J.D. H. Leave a comment

The internet and phone service was down in Salem MO this morning for customers of Fidelity Communications. It was quite perplexing at first, because I was working on a wireless upgrade at the Crossroads Inn & Suites hotel in Salem. During the middle of the upgrade, internet connectivity was lost. Eventually we determined that it was not our system’s issue but rather Fidelity’s. After contacting them we learned that a router went down in Kansas City and that caused widespread

Salem MO hotel with good internet [Crossroads Inn & Suites]

Saturday, 2014.03.22 J.D. H. Leave a comment

This past week I worked from Tuesday through Friday in Salem MO. I stayed at the Crossroads Inn & Suites and had a chance to test their internet over the course of my stay and my work. Here is the speedtest.net result for their free wifi: This result puts is at equal to or better than most hotel’s that I’ve stayed at in Springfield MO (another area where I work regularly). They also have (5) dedicated wifi access points for

AT&T is down in Salem MO today (cell phones and land lines)

Wednesday, 2014.03.19 J.D. H. Leave a comment

AT&T is down in Salem MO today 🙁 It is definitely affecting cell phones and also seems to be internet/DSL/land-lines, bummer! This is wreaking havoc with a lot of people and businesses. Example: Subway cannot accept credit card orders b/c their line is down. Thankfully, Verizon and other internet providers are still up 🙂 Top Search Terms:att outage branson mo today (1)att outage salem mo (1)salem mo newspaper att outage (1)

Set 24/7 operating hours for Google Places business listing

Wednesday, 2014.03.19 J.D. H. 2 comments

If you are setting up a business listing on Google Places and the operating hours are 24/7 (24 hours a day, every day) you can specify that as follow: This was helpful when working on the Crossroads Inn & Suites Google Places listing as they are truly open 24/7 365 days a year! 🙂 Top Search Terms:tell me the places that are open 24 hours (1)how to set hour as open 24 /7 on google business listing (1)how to set

Access MySQL server over SSH tunnel using Navicat

Monday, 2014.03.17 J.D. H. 2 comments

Today was my first time to access a MySQL server over a SSH tunnel in Navicat. After a bit of trial and error I was finally able to achieve success 🙂 Here are the main things I learned: #1 On the client machine running Navicat, use the same credentials that you would use if you were at the console of the remote server. In this case localhost and port 3306 #2 On the SSH tab, use the remote server’s IP

Read more Database tips, Software Tips, Work

Replace () / . characters in phone numbers with dashes (MySQL database)

Tuesday, 2014.03.11 J.D. H. Leave a comment

If you have a MySQL database containing phone number records in varying formats, you may want to standardize them. New records can easily be handled by checking data entry against your desired format (via JS or whatever method you like). However, existing records must be dealt with. That is where an UPDATE statement combined some handy MySQL functions can assist us: // Replace forward slash with dash UPDATE db_phonenumbers SET phone_field = REPLACE(phone_field, ‘/’, ‘-‘) // Replace close parenthesis with

Acer Aspire M5 583P wifi driver fix

Friday, 2014.03.07 J.D. H. Leave a comment

Q. Here us a wifi driver question from a reader comment: hello, coming to u again for some help, this time im upgrading athe hdd to an ssd on an Acer Aspire M5 583p-9688. here is a rundown on what ive attempted. cloned original hdd to ssd using paragon software ( was successful when i cloned the hdd for the asus laptop). physically swapped the drives. f12 settings changed UFEI boot settings to Legacy, placed SSD on top of the

Read more computer tips, Software Tips, Work

GoDaddy 2014 Renewal Coupon Code for .COMs

Saturday, 2014.03.01 J.D. H. Leave a comment

Recently I needed to renew about ten domains names at GoDaddy and it took me forever to find a promo code that worked for RENEWALS. Finally I found one for discounted renewals: GDBBX1705 *copy and paste the code into the coupon section at the bottom of the GoDaddy checkout page You can apply the coupon code here: GoDaddy Renewal Discount It saved me $48.54 so that’s not too shabby 🙂 Top Search Terms:godaddy renewal promo code 2014 (7)godaddy renewal code