How to replace a string in all posts in WordPress database?

We had some anomalies in our WordPress sites that some of them old posts have the wrong interpretation of single quotes and double quotes so we had to manually replace all the wrong strings to the correct quotes. In cpanel, you can open up phpmyadmin to run the following MySQL queries, but first, you need …

How to replace a string in all posts in WordPress database? Read More »

Change Default Graphics Processor / GPU in Windows (NVIDIA)

If you have two different GPUs or graphics processors in your laptop, chances are Windows could be using the wrong one performance wise. Benchmarking always come out with the inferior one with a lower score. How to change the default graphics card in Windows for an Nvidia GPU? Search “nvidia control panel” in Start, click …

Change Default Graphics Processor / GPU in Windows (NVIDIA) Read More »

SMTP server telnet connection refused on Linux?

I was testing the WP Mail SMTP plugin to send emails in WordPress via SMTP servers but when it was trying to connect to the remote SMTP server, it kept getting error “Connection refused”. So I tried: telnet smtp.xxxx.com 587 To test the connection. Turned out my own server is preventing the outgoing request because …

SMTP server telnet connection refused on Linux? Read More »

Office365 SMTP Send Emails as Shared Mailbox via smtp.office365.com

Go to Office.com admin center > Users > Active users. Create a standalone user for the purpose of SMTP authentication, e.g. [email protected] with password XXYYZZ112233, as you don’t want to give the password of your existing users to apps (e.g. WordPress) that need to access your SMTP. Edit the created account enabling SMTP authentication by …

Office365 SMTP Send Emails as Shared Mailbox via smtp.office365.com Read More »

When to use NoSQL (e.g. MongoDB) and when to use SQL (e.g. MySQL)?

NoSQL is mostly about document databases while SQL is about relational databases. NoSQL vs. SQL Documents vs. Tables MongoDB vs. MySQL Property vs. Entity The trick is 4: Property vs. Entity Design your data models on a piece of paper. Use MongoDB if … If you see more trivial *entities* such as category, tag, brand, …

When to use NoSQL (e.g. MongoDB) and when to use SQL (e.g. MySQL)? Read More »

How To Proactively Manage Your Programming and Personal Lives

Managing your business and personal lives can help you get more work done and lead a happier, healthier life. However, instead of cracking down on yourself to get more done in a day, consider giving yourself free time that can help you spend time enjoying life. Even if you love your job as a programmer, …

How To Proactively Manage Your Programming and Personal Lives Read More »

9 Things to Look for When Purchasing B2B Email Lists

Email marketing has been considered a great tool to create leads and enhance sales for years. A recent forecast of Statista declares that the global revenue of the email marketing industry was 7.5 billion USD in 2020, and it will reach up to 17.9 billion USD by 2027. Similarly, the number of email users is …

9 Things to Look for When Purchasing B2B Email Lists Read More »

Whitelist server IPs for SSH connection against ERROR – ssh: connect to host port: Connection refused

If you have multiple servers you’d probably need rsync to transfer files among servers via SSH. An error like this, however, will occur when CSF protects the servers against malicious SSH connection attempts: The solution is very simple. Just whitelist each server IP on the other server and vice versa: Wherein 1.1.1.1 is the other …

Whitelist server IPs for SSH connection against ERROR – ssh: connect to host port: Connection refused Read More »

10 Best Mass Emailing Tools

Many studies have been done, all with the same results. The average email marketing campaign yields low conversion rates. Marketing Insider reports that only 1 in 5 of your email recipients are going to open your email, and even worse, for every 100 marketing emails you send, 3 will convert to a subscription, purchase, or …

10 Best Mass Emailing Tools Read More »

Archetypethemes.co Review: 5/5 Best Premium Shopify Theme I Know of Thus Far

I have started several Shopify stores that are now still online and making money for me since 2017. It’s been a terrific experience as Shopify has made so many things so simple after the golden old days when you had to provision and manage a server yourself with hand coded websites on your own garage …

Archetypethemes.co Review: 5/5 Best Premium Shopify Theme I Know of Thus Far Read More »

Clone any static site by a simple Linux command WGET

Just use this and the WGET command will start crawling the target site and download certain levels of pages from the starting URL, including all its assets such as images or CSS files. wget -k -K -E -r -l 1 -p -N -F –convert-links -H -Dcdn.shopify.com,v.shopify.com,www.yoursite.com,your-site.myshopify.com –restrict-file-names=windows https://www.yoursite.com/ The -D option specifies all the hosts …

Clone any static site by a simple Linux command WGET Read More »

New Amazon Affiliate Site: Men’s Winter Boots dot Com

As someone at NamePros suggests with some of my exact match .com names, I created this affiliate site with the domain MensWinterBoots.com and see what kind of business or cash flow I can get. Exact match domains used to dominate in Google search results but no more. I’m skeptical of how this would turn out …

New Amazon Affiliate Site: Men’s Winter Boots dot Com Read More »

Office.com Office 365 Creating Shared Mailboxes by the Same Name under Different Domains

When you have multiple domains under the same Office 365 admin account, e.g. domain1.com, domain2.com, etc., you can’t directly create these emails: [email protected] [email protected] Which would give this error when you try to create emails by the same name already used by another domain: Now you can have a little circumvention to get around this …

Office.com Office 365 Creating Shared Mailboxes by the Same Name under Different Domains Read More »

Add SSL / HTTPS for WordPress Network sub-site as cPanel Alias Domain

Site Address (URL) We first change the Site Address (URL) of the sub-site. Go to WordPress Multi-site: “My Sites” => “Network Admin” => “Sites” => Click “Edit” of the sub-site, and change the Site Address (URL) to the top level domain URL like this: https://www.example.com/ Click “Save Changes“. Domain Mapping (plugin) A top-level domain is …

Add SSL / HTTPS for WordPress Network sub-site as cPanel Alias Domain Read More »

How to link external code source folder in Eclipse PDT projects & Array initializer indentation size?

Code folders may be distributed across different locations and paths but you want to manage them in one Eclipse project. It’s easy to achieve this by linking code source in your Eclipse project. Right click on project Click “Properties” Select “PHP” > “Build Path” Click “Link Source…” Click “Browse” Select the code folder to link …

How to link external code source folder in Eclipse PDT projects & Array initializer indentation size? Read More »