Rafiki Technology

Tech Insights

[rafikitechnology]

Google Sheets CountIf and ImportRange Return 0 and Won't Offer to Allow Access

Google Sheets CountIf and ImportRange Return 0 and Won’t Offer to Allow Access

When making references to a range from one Google Sheets into another Google Sheets, you will need the Google Sheets IMPORTRANGE function. If you need to count the occurrences of a certain string of characters or any cell content that meet certain criteria, you may need the Google Sheets COUNTIF function. Combining the two formulas gives you the superpower of counting over an external range based…

View On WordPress

[rafikitechnology]

Comment construire le triangle de Pascal et être capable de calculer des trucs comme (x+y)^n Oh, les bons vieux temps!

[rafikitechnology]

Beware of Fake Go Daddy Invoices from PayPal

Beware of Fake Go Daddy Invoices from PayPal

There has been an increase in emails from services [@] PayPal[.]com that claim to be billing for a domain name you own or to which your email address is connected.

Do not fall for these. They are fishing emails you need to stay away from. You can read up more on this issue from previous reports on the topic here: https://www.godaddy.com/community/SSL-And-Security/Fake-PayPal-GoDaddy-Invoices/t…

View On WordPress

[rafikitechnology]

Your Debit Card Is Locked Scam

Did you get a text message stating that your Debit Card was locked? Well, do not fall for it. I may look many different ways including the following:

FROM:Debit Card Alert. Call 844-307-2969 Now MSG:0000 New Message! Your Debit Card is Locked

Best response here is to NOT call the number in this message, but rather to call your Debit card company directly to confirm using the number on the back of…

View On WordPress

[rafikitechnology]

Cybersecurity Incident or Full Blown Breach at Web.com, Register.com, and NetworkSolutions.com

As painful as it is to announce this, what some consider the 5th largest domain registration company in the world has been breached. Or should we call it a cybersecurity incident as they claim in their mea culpa, comforting customers that, “No credit card data was compromised as a result of this incident?” (Emphasis ours). The mea culpa is posted on a subdomain of their website: https://notice.we…

View On WordPress

[rafikitechnology]

Where Can I Learn Regular Expressions? How About Testing?

Where Can I Learn Regular Expressions? How About Testing?

Where Can I Learn Regular Expressions Syntax and Use?

Regular expressions are fun, if you can figure out how to use use them of course. So, let’s fix that. Well, even better, just go fish on your own starting with Regular-Expressions. I kinda like how colorful that site is!

Where Can I Test My Regular Expressions?

If you are learning Regular Expressions, you probably wonder sometimes if…

View On WordPress

[rafikitechnology]

What Does It Mean That "App" Is Not Optimized For Your Mac?

What Does It Mean That “App” Is Not Optimized For Your Mac?

If you are a MacOS user, you most likely have a pop up message on your mac recently stating, “This app will not work with future versions of macOS and needs to be updated to improve compatibility. Contact the developer for more information.

Pop up you get whenever you run an app that’s not 64-bit on your Mac.

Despite the fact that the frequency of those messages is a bit exasperating, you…

View On WordPress

[rafikitechnology]

UniFi Video Won't Allow Login to NVR After Firmware Upgrade

UniFi Video Won’t Allow Login to NVR After Firmware Upgrade

If you have ever had to manage a UniFi Video NVR from Ubiquiti, you will know what a pain it can be to try to log back into your UniFi Video system after you perform an operating system update or firmware upgrade.

Several hours of chat with their support team could result in more frustration than necessary. The solution is simple unless the upgrade really destroyed your device and you require…

View On WordPress

[rafikitechnology]

This made my day! Git Emergency Procedure. I had to share this with you! If you have any issue remember some basic git commands here is a way you can remember at least three of them using this mnemonic device: If case of:> git statusFIRE> git commit> git push> git out! That's all I have to say right now!Inspiration : Louis-Michel Couture.

[rafikitechnology]

Warning - Major WannaCry-like Windows Security Exploit

Warning – Major WannaCry-like Windows Security Exploit

If you have a Windows computer different from Windows 10 and Windows 8, you need this update!

Windows 7, Windows XP, Windows Server 2003, Windows Server 2008 R2 and similar all need updates right now.

More on this

Here: https://krebsonsecurity.com/2019/05/microsoft-patches-wormable-flaw-in-windows-xp-7-and-windows-2003/

and here: https://www.theverge.com/2019/5/14/18623565/microsoft-windows-xp-re…

View On WordPress

[rafikitechnology]

Microsoft SharePoint Under Attack - CVE-2019-0604

Microsoft SharePoint Under Attack – CVE-2019-0604

SharePoint is under attack as attackers have discovered and are exploiting vulnerability CVE-2019-0604. Find out more about the vulnerability in the linked security advisory by Microsoft below:

A remote code execution vulnerability exists in Microsoft SharePoint when the software fails to check the source markup of an application package. An attacker who successfully exploited the…

View On WordPress

[rafikitechnology]

What Is This So Called God Mode on Windows and How Do I Access It?

What Is This So Called God Mode on Windows and How Do I Access It?

Windows has a really cool tool you will be glad to discover if, like me, you like to have lots of power on you computer. Some people have called this feature the “God Mode,” but we will call it “Power Tools Mode,” because we fear God here.

The Power Tools Mode is easy to access. Just create an empty folder on your Desktop, Rename the folder to the following exact code with the brackets and dot…

View On WordPress

[rafikitechnology]

What is Microsoft Windows Reliability Monitor?

What is Microsoft Windows Reliability Monitor?

One of the hidden gems on Windows computers is the Reliability Monitor. This tool can help you detect problems on your system before it is too late. The Monitor is hidden in the Control Panel > System and Security > Action Center > Reliability Monitor in some of the flavors of Windows, but the quickest way to unearth it on Windows 10 is to Windows Start / Search for “Reliability.” This should…

View On WordPress

[rafikitechnology]

Is Facebook Keeping Your Password Secure? The answer is yes if keeping passwords in plain text is considered secure. The obvious answer is NO.

[rafikitechnology]

Critical Vulnerability in WinRAR Exposed - Absolute Path Traversal

Critical Vulnerability in WinRAR Exposed – Absolute Path Traversal

According to a report this morning from SonicWall, a vulnerability that could allow remote code execution has been discovered in WinRAR. This software vulnerability exposes the half a billion users of this Windows unarchiver. The vulnerability exploited is detailed by MITRE in CVE-2018-20250.

To find out if you are vulnerable, check to see if your WinRAR version is anything prior to WinRAR prior…

View On WordPress

[rafikitechnology]

Windows 10 Command Line - How to Set Password Never to Expire

Windows 10 Command Line – How to Set Password Never to Expire

On Windows 10, using the Windows Management Instrumentation Command Line (WMIC), you can set the password never to expire with the command:

WMIC UserAccount WHERE NAME='username' SET PasswordExpires=FALSE

View On WordPress

[rafikitechnology]

Update on Facebook Hack – Are You One Of The 30 Million Users Who Got Hacked? Facebook published this October 12, 2018 an update on the attack that we presented to you just about two weeks ago in an article titled