Code Scraps: Finding duplicate records in MySQL
This is a quick code scrap to illustrate how to identify duplicate field values in record sets in MySQL. The code may also work for other SQL languages, but do […]
Programming
Code Scraps: Send TeamCity the date and time during builds on Windows
Having the date and time available to you during a TeamCity build is very useful – but this information isn’t always available by default to TeamCity. Here is a Windows […]
Code Scraps: Add a custom transformation file to an MSBuild project
Visual Studio has offered a neat feature for transforming config files for Web Applications for years – that’s where you have a default web.config file, and then a web.<something>.config for […]
Programmatically storing your Database for Source Control
Databases are often a critical part of most applications today. But how do you go about storing them for Source Control purposes? There are a number of approaches – the […]
Deleting files in a directory older than a number of days
Here’s a quick Windows Powershell script to delete all files in a folder that are older than a certain number of days. # Delete all Files in <directory> older than […]
Boot loop issue on VirtualBox
Here’s a quick tip on a not so obvious bug you can have with VirtualBox. I took ownership of a Windows 7 virtual machine from a colleague. I copied the […]
Code Scraps: Symbolic Links on Windows; Junctions and Hard Links
Did you know Windows can do its own equivalent of Linux Symbolic Links? It’s been able to do them for quite a while, but it’s not something a lot of […]
Code Scraps: Hide system MySQL databases from phpMyAdmin listings
Here’s a quick code scrap to hide the system MySQL and phpMyAdmin databases from being listed within the web application itself. Open your phpMyAdmin’s config.ini.php file and locate the end […]
MD5 as a password storage mechanism is still a good idea
No, I’m not mad. Hear me out It is now good practise not to use MD5 for secure hashes. There have been published rainbow tables of the most common password […]
Compiling FFmpeg for Raspberry Pi / Raspbian Jessie
There’s plenty of guides around, but none that worked flawlessly for me. Here’s my recipe for building and compiling FFmpeg for the Raspbian Jessie environment for Raspberry Pi. If you’re […]