Truncating a T-SQL (SQL Server) table with foreign keys
Here’s a quick reminder on how to best truncate and reset primary keys on a table in Microsoft SQL Server that has foreign keys defined. DELETE FROM [TableName] DBCC CHECKIDENT […]
Author: @davidcostello42
How not to interview for a software role
I’m currently in the grueling task of trying to find a new job in the software engineering space. I’ve had some really good interviews, and I’ve had some absolute train […]
ASpell-based Language Detection – basic, reasonably quick language identification
I recently published an old prototype language detection library on GitHub. The library utilises open-source ASpell dictionary files to identify the language of the text being passed to the library. […]
Handy Notepad++ plugins for developers
This is a quick list of the plugins available for Notepad++ that can benefit developers (as of January 2018). All plugins are available from the Plugin Manager inside Notepad++. There […]
API.Toys updates
Several years back I created API.Toys, a small hobbyist website where I’m slowly publishing random JSON-based data endpoints for various different things. I’ve recently updated the website to include ISO-3166-1 […]
Securely erasing a hard drive
Recently a relative of mine asked if I could get rid of a couple of old desktop computers and a laptop. The relative had removed all their important files from […]
BT Service Hacks: BT Charge Advice
My parents-in-law have had a frustrating service on their phone line for about 15 years. Whenever they make an outgoing call on their landline, once completing their outgoing call they […]
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 […]