Category Archives: Work

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

2 comments

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: Finally, you have a reminder that will occur on the first day of each month! The process should be similar for an Event or a Task. 👍👍 PS here are some screenshots that

Read more Chrome, Software Tips, tech tips, Work

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

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.

Read more Software Tips, Work

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

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

Read more computer tips, iOS, photography, Work

Photoshop JPG file sizes are way too BIG!

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

Read more computer tips, Work

Keep formatting in Excel when copying/pasting from web page

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

Read more company tips, Software Tips, Work

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

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:

Read more computer tips, Software Tips, Work

How to cancel business registration on GoDaddy

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

Read more Internet tips, Work

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

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:

Read more computer tips, Software Tips, Work