SQL Coding Exercise – Duplicate Emails
The SQL coding exercise is from oj-online judge and you could submit your solution to this URL: https://oj.leetcode.com/problems/duplicate-emails/ Write a SQL query to find all duplicate emails in a …
SQL Coding Exercise – Employees Earning More Than Their Managers
The SQL Coding Exercise is from oj-leet Online Judge and you can submit your solution to this problem here: https://oj.leetcode.com/problems/employees-earning-more-than-their-managers/ The Employee table holds all employees including their managers. …
Avoid Magic Numbers by using Enum in C/C++
Using Magic Numbers is one of the causes of ugly code. For example, if you want to deal with two protocols, HTTP and FTP (to count the data packages), …
Disable WordPress Maintenance Mode when Upgrading Plugins Stuck
It happens to me quite often that when I was trying to update plugins in WordPress, the website enters the maintenance mode and the webpage looks like this: This …
Dotfuscator Registration Problem on Jenkens Build Server
Dotfuscator is a commercial software that is used to obfuscating .NET source code. It could be found in early Visual Studio (as a default obfuscator) but later it became …
How to Convert GB2312 (or other Non-ANSI Characters) to UTF-8 encoding (Both MySQL and Files Charset)
My first website steakovercooked.com started at 2006 (9 years ago). And at that time, I didn’t know much about the file encoding/charset and also, the UTF-8 was not so …