Category Archives: Work

Last minute options for filing 1099-NEC forms

Intuit QuickBooks for contractor 1099 filings: https://app.qbo.intuit.com/app/payroll With the web based QuickBooks online filing feature, the steps are basically:#1 add your contractors#2 add payments that you sent to the contractors#3 file the 1099-NEC (or similar) online with the IRS* *they e-file with the IRS as well as mailing and emailing copies to your contractors. The process takes a few steps but the end result has worked perfectly for me this year. As of right now, they offer a $7.50 reduced

What to try if headless rackmount server doesn’t show up [SOLVED]

Dell PowerEdge Boot Up Displayed on AOC LCD monitor

Recently we booted up our old 1U Dell R610 server to restore some data from it. However, we were unable to access the VMWare vSphere capabilities and could not ping the dedicated IP address. Hooking up a spare monitor we found that the CMOS battery was bad and it was preventing bootup (i.e. it was stuck at an error confirmation screen). After using a keyboard to continue by “pressing any key” to get past the error, all was well 👍👍

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: