I was trying to restore a database to a MySQL server on a test machine and this error occurred: #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’ The problem is, the server that runs the live database is MySQL 5.7 that supports utf8mb4_unicode_520_ci but the test server I run is only MySQL 5.5 which does not support this specific encoding. By the way, […]
I love paper airplanes but I only know a couple ways to make them, i.e. the basic dart. But, there are actually many ways to make them with different types. And if you are interested, check out Paper Airplane Designs, a database of paper airplanes with easy to follow folding instructions. It’s going to be fun going through every single […]
![Machine Learning - [Reading] Machine Learning - the Emperor's Clothes?](https://i0.wp.com/www.kjctech.net/wp-content/uploads/2018/09/Machine-Learning.png?fit=520%2C176&ssl=1 "[Reading] Machine Learning - the Emperor's Clothes?")
I’ve been obsessing about machine learning for a while but haven’t found a way to really get into it. This is a great read that might finally motivate me to dive right in, in a way that I haven’t seen before. Machine Learning – Is the emperor wearing clothes by Cassie Kozyrkov, chief decision intelligence engineer from Google. Here is […]
Instead of looking for a tool, there is a very quick and easy way that lets me ping a wild range of IPs to find out which IPs are free and which ones have been taken, using the PowerShell built-in cmdlet Test-Connection. And here is how: $iprange = 200..254 Foreach ($ip in $iprange) { $computer = “192.168.37.$ip” $status = Test-Connection […]
Pwned Passwords is a great web service that lets you check your own password against millions of compromised and leaked password. It’s not only getting constantly updated by the owner, Troy Hunt but offers text-based downloadable files and API for anyone interested in building a 3rd party app. Newly added to the list is the password hashes in NTLM format, […]
When querying a PowerShell object, it only returns a few essential properties by default. For example, querying the W32_ComputerSystem class with Get-WmiObject cmdlet only returns properties like Manufacturer, ComputerName, TotalPhysicalMemory, etc. To get the full list of the properties of Win32_ComputerSystem class, you can pipe the result to Format-List, like below. Get-WmiObject -Class “Win32_ComputerSystem” | Format-List * You can even […]
Have you ever seen the timestamp format like this and wondered how it’s equivalent to the normal DateTime format? It’s the date/time value stored in Active Directory as the number of 100-nanosecond intervals that have elapsed since the 0 hours on January 1, 1601, until the date/time that is being stored. It’s always in UTC (Coordinated Universal Time, aka. GMT) […]
The wildcard SSL certificate is expiring in a few weeks. It’s time to get it renewed for both website and the Gateway server for remote access. I renewed the certificate on Namecheap, regenerated the CSR file and got the digitally signed certificate file in a few minutes. Since the digital certificate was generated for the website hosted on Apache, I […]