Category Archives: Ask J.D.

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

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

Maximum Lenovo Yoga 2 Pro and Yoga 13 SD card capacity?

If you are wondering what the max SD card capacity is for the Lenovo Yoga series, I can confirm that both the Yoga 13 and the Yoga 2 Pro support 128GB SDXC cards. Woot! 🙂 Top Search Terms:lenovo yoga 2 pro sdxc (3)lenovo yoga 3 maximum sd card size (3)lenova yoga 2 11 maximum sd card size (2)lenovo yoga 2 13 sdhc (2)lenovo yoga 2 13 max sd card (2)ideapad yoga 13 sdxc 128 (2)lenovo yoga 13 sd card (2)lenovo

Ordering the Oculus Rift Development Kit 2 (DK2)

I received a tasty email in my inbox this morning, The Oculus Rift 2 is up for preorder!!! However, upon attempting to place my order I encountered some wonkiness in their ordering system (using both Chrome and Opera). Thankfully I eventually figured out how to place my order: After you enter your shipping/billing info, you should eventually make it to a screen that looks like a final ordering screen. But if you scroll down it looks like there no ‘order’

Access MySQL server over SSH tunnel using Navicat

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

SD cards for the Yoga 2 Pro that don’t stick out as much

In general, the Yoga 2 Pro is an excellent upgrade over the original Yoga 13. One of the few drawbacks of the Pro 2 is that Lenovo made it so normal SD cards stick out (rather than sitting flush like on the original Yoga). Thankfully, there are some shorter SD cards that meant to at least partially resolve this issue. You can find some more info at the links below:   PNY StorEDGE 128GB Flash Memory Expansion Module (P-MEMEXP128U1-EF): Computers &

Amazon Prime price increase to $99 a year

I received this in my inbox this morning: We are writing to provide you advance notice that the price of your Prime membership will be increasing. The annual rate will be $99 when your membership renews on August 28, 2014. Even as fuel and transportation costs have increased, the price of Prime has remained the same for nine years. Since 2005, the number of items eligible for unlimited free Two-Day Shipping has grown from one million to over 20 million.

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

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

« Older Entries Recent Entries »