Access MySQL server over SSH tunnel using Navicat

Use the remote server's IP and approriate SSH login credentials

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 and

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

Screenshot of forum thread discussing the SD card size issue

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

Tax notes

https://ttlc.intuit.com/questions/2231912-need-help-regarding-cost-basis-for-a-1099-s-proceeds-from-real-estate-sale-city-reported-their-purchase-of-an-18-easement-to-extend-sewer-main-down-the-driveway-of-my-rental-property-to-irs-using-a-1099-s https://ttlc.intuit.com/questions/1772542-received-a-1099-s-for-road-right-of-way-permanent-easement-and-2-temporary-easements-how-should-i-enter-this https://ttlc.intuit.com/questions/2211264-i-have-a-1099-s-this-is-for-the-sale-of-land-right-of-way-to-a-utility-company http://www.portal.msue.msu.edu/objects/content_revision/download.cfm/revision_id.582335/workspace_id.580668/Oil%20&%20Gas%20Income%20Tax%20Consideration%20for%20Farm%20&%20Forest%20Lands.pdf/ http://www.aicpa.org/Publications/TaxAdviser/2014/march/Pages/Kebodeaux_mar2014.aspx  

Printable Chase Deposit Slips [SCAN/JPG/PDF]

Click the image for a larger higher resolution version

I have been a longtime Chase customer but unfortunately they do not have ANY ATMs or branches around here. Deposit by mail can be pretty handy but the problem with that is that I often run out of deposit slips. The last time I checked the box on their deposit envelope for them to mail me more they sent me one deposit slip To remedy this situations, here is a printable scan of a Chase deposit slip: I have printed these

Page 20 of 120« First...10...1819202122...304050...Last »