Category Archives: Work

Last minute options for filing 1099-NEC forms

Leave a comment

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

Read more Work

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

Leave a comment
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 👍👍

Read more Networking, 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