Category Archives: Work

How to add a Google Calendar Reminder that repeats on 1st of each month

Recently I needed to create a Google Calendar reminder that repeats on the 1st day of each month. đź“… Initially, it was slightly confusing how to do this. Therefore, once I figured it out, I wanted to share the tip in case other people had similar issues: Go to Click the “+Create” button in the upper left hand corner Choose “Reminder” Set a title for the Reminder Choose the 1st day of the month that you want the reminder to

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

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

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!

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

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

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

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]

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: