Articles on web development, software, and hardware.
Articles on web development, software, and hardware.
Here are SQL queries to help migrate an entire MySQL database to the utf8mb4 character set, and utf8mb4_unicode_ci collation.
The command below shows how to move an SSL certificate from one Java keystore file (.jks) to another Java keystore file.
This article describes how to restore a SQL Server database backup file (.bak) to a SQL Server database hosted on Amazon's Relation Database Service (RDS).
How to use robocopy to move the contents of an old system drive to a backup drive.
This code below shows how to generate a unique identifier that is safe for URLs and file names.
These instructions show how to get the message count by year and week number from Thunderbird.
Notes on how to set up a new ASP.Net website in Windows 7 Pro on IIS 7.5. The trick is to create a new application pool for the new site and configure the site to impersonate the same user as the...
These are notes for how to set UTF-8 (UTF8) collation and character set in MySQL database server. There are also notes on how to set the dfeault collation and characters set to UTF-8 on Amazon RD...
Articles on web development, software, and hardware.
This is a highly optimized function to get the file size abbreviation in bytes for an arbitrary, 64-bit file size. It returns the file size to three decimals followed by the abbreviation, like KB...
Notes for setting up a cheap, low-cost MySQL database server on an Amazon EC2 t1.micro spot instance. This can be useful for situations where your MySQL instance does not need 100% availability, ...