Comparisons of various laptops and PCs

Random PCs and laptops I have used in the past for work and play: Gateway 14.1″ Laptop Passmark Rating: 5490 (actual result 2020_11)Passmark Single Thread Rating: 1652 (actual result 2020_11) AMD Ryzen 3300U (ordered a 3200U and they shipped me a 3300U!!!) UPGRADE! 4GB 20GB DDR4 RAM (4GB soldered, 16GB added) 128GB M.2 SATA SSD (not NVMe) UPGRADE! 1TB M2. SATA SSD (not NVMe) Gigabyte AERO 15 OLED laptopSA-7US5130SH 9th Gen Intel Core i7-9750H 6 core processor (12 threads) Passmark

When do I get my stimulus / economic impact check? [ANSWERED]

Question: I just updated my banking info with the IRS website, how can I find out when I will get my stimulus (economic impact) deposit? -Christopher Answer as of May 1st, 2020:As best I can determine, if you enter your bank account information any day until noon on a Tuesday, your payment date will become available the Saturday after that Tuesday. In other words, if you enter the info before Tuesday then the following Saturday you can log back in

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

How to fix Microsoft Excel’s “File not loaded completely” error message [SOLVED]

A client recently reached out to me with the following problem: When importing a large (72MB) CSV document, Excel reports “file not loaded completely”. 🙁 Sure enough, data is missing. Can you help me? This issue is caused by Excel only supporting ~1,048,576 rows in a CSV file. In the client’s instance, there were around 1.6 million records. Thankfully, for Excel’s limitation, there is a relatively simple workaround: Open the CSV file in a text editor that supports large file

Rotate a tablet screen when using TeamViewer or remote work software

Summary: sometimes a PC or tablet may be stuck in the wrong screen orientation when you log in via TeamViewer or other remote software. Solution: Turn rotation lock ON Rotate via the “orientation setting” Apply settings and you are done! Details: Recently I had to do some work for a client via TeamViewer. While that is normal, the ruggedized tablet that I was logging into was a little out of the usual. Specifically, the tiny tablet was running Windows 10

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