Work | J.D. Hodges

Category Archives: Work

MySQL Server has gone away when importing large sqlfile [Navicat, SOLVED]

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

Recently I tried importing a 1.2GB SQL dump file and Navicat kept immediately timing out with: [Err] 2006 – MySQL server has gone away Eventually, I was able to the entire file (6 million records worth) to import by unchecking* the “Run multiple queries in each execution” option before starting the import process. After this, the process completed perfectly! *normally I always uncheck that box, but for some reason this time I forgot to uncheck it on my first attempt.

Best iPad for video meetings – ALL iPad camera specs LIST Video Conferencing & Photography

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

Last updated: April 28th, 2020 The iPad was first introduced in 2010 without a camera. Since then, the capabilities and models of the iPad family have steadily expanded. In this time of physical/social distancing and teleconferencing via a myriad of apps (Zoom, Skype, Facebook Messenger, WhatsApp, Facetime, etc.), camera quality has become even more important. Unfortunately, it can be hard to keep track of the camera changes over the iPad line after so many years. Therefore, I compiled a handy

Photoshop JPG file sizes are way too BIG!

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

Recently I received an unusual JPEG for a work project. The resolution was fairly low (1344×576) and the document resolution was also set to a relatively low screen resolution of 72dpi: Normally I would anticipate this file being less than 1MB. However, it was over 10MB! Copy and pasting the image content into a blank Photoshop file and saving as a JPEG also resulted in a 10MB file size. Even using a very high compression level (and thus reducing the

Keep formatting in Excel when copying/pasting from web page

Monday, 2018.02.12 J.D. H. Leave a comment

Question from B.G.: Sorry to bother. How can I export and keep the integrity of the web page table columns? When I copy and paste to excel, it puts all data to 1 row. Answer: Good question! Please find the steps below: Instructions In your web browser window showing the table/report, press CTRL+A (to select all) Then press CTRL+C (to copy) Switch to a blank spreadsheet in Excel, press CTRL+V (to paste) That should result in a nice separate set of

[SOLVED] Lenovo BSOD on Windows 7, Windows has recovered from an unexpected shutdown

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

One my clients uses a number of Lenovo mini PC systems. The systems perform very well for their intended purposes, however, some of the systems were sporadically shutting down (blue screen of death). Thankfully, disabling Bluetooth devices/adapters in Device Manager seems to have permanently resolve the issue. The client did not need the bluetooth capability in the first place, so now all is well 🙂 For reference, here is the error message and assorted diagnostic info: Problem signature: Problem Event Name:

How to cancel business registration on GoDaddy

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

To Cancel Business Registration: Login to your GoDaddy account. Go to My Account Account Settings Renewal & Billing Check the box next to the Business Registration account that you want to cancel, and then click Cancel Item. Confirm. Screenshots of the process: Further explanation: I had a client that was getting billed $4.99 for Business Registration and they were not using the service (it had never even been set up). They asked me to help them cancel it and I did

When closing TeamViewer it automatically locks my PC back to the logon screen?! [SOLVED]

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

Recently I had a client dealing with a Windows PC always being locked when they logged into their machine via TeamViewer. They wanted to be able to login directly to the machine without a password prompt so they tried disabling automatic lock via Windows Power Settings, no luck. They tried auto logon via control userpasswords2, no luck. Thankfully, I was able to fix the issue by utilizing the following TeamViewer option: Actions -> Lock -> UNCHECK Lock on session end Screenshot:

How long to file for & receive an EIN online? [SOLVED]

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

Q. How long does it take to file for and receive an EIN??? A. Generally, it takes less than 15 minutes to receive an EIN. Here are the details: If you visit the IRS website during normal hours of operation and your principal business is located in the United States: You can complete the process online at the offical IRS website: https://www.irs.gov/businesses/small-businesses-self-employed/apply-for-an-employer-identification-number-ein-online It takes about 5-10 minutes, after which the IRS will assign you an EIN You will immediately receive your EIN