Skip to content

David Costello

dmcostello.com

  • Home
  • About
  • Articles
    • Internet
    • Programming
    • Uncategorised
  • Projects
  • Resources
    • Downloads
    • Links
  • Contact

Programming

Code Scraps: Finding duplicate records in MySQL

22nd January 2019 @davidcostello42

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 […]

 Code Scraps, Programming  Data, MySQL, Programming, SQL  Leave a comment

Code Scraps: Send TeamCity the date and time during builds on Windows

4th December 20184th December 2018 @davidcostello42

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, Computing, Programming  Batch Scripts, Command Line, Continuous Integration, Dates, Programming, TeamCity, Time, Windows  Leave a comment

Code Scraps: Add a custom transformation file to an MSBuild project

9th October 20189th October 2018 @davidcostello42

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 […]

 Code Scraps, Programming  C#, Continuous Integration, MSBuild, Programming, TeamCity, Visual Basic, Visual Studio  Leave a comment

Programmatically storing your Database for Source Control

18th June 201817th September 2018 @davidcostello42

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 […]

 Programming  Bash, Batch Scripts, Command Line, GIT, MySQL, Oracle, Poweshell, Programming, Shell, Source Control, SQL, SQL Server, SQLite, SVN  Leave a comment

Deleting files in a directory older than a number of days

15th June 2018 @davidcostello42

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 […]

 Code Scraps, Computing, Programming  Command Line, Poweshell, Programming, Windows  Leave a comment

Boot loop issue on VirtualBox

10th April 20183rd May 2018 @davidcostello42

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 […]

 Computing  Linux, Programming, Virtualisation, Windows  Leave a comment

Code Scraps: Symbolic Links on Windows; Junctions and Hard Links

24th September 2017 @davidcostello42

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, Computing  Command Line, Programming, Windows  Leave a comment

Code Scraps: Hide system MySQL databases from phpMyAdmin listings

20th September 201720th September 2017 @davidcostello42

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 […]

 Code Scraps  MySQL, PHP, phpMyAdmin, Programming  Leave a comment

MD5 as a password storage mechanism is still a good idea

30th August 20178th September 2017 @davidcostello42

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 […]

 Programming, Security  Encryption, Hashes, Hashing, PHP, Programming, Python, Security  Leave a comment

Compiling FFmpeg for Raspberry Pi / Raspbian Jessie

15th August 20178th September 2017 @davidcostello42

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 […]

 Computing, Programming  Audio, Audio Encoding, Bash, Encoding, FFmpeg, Linux, Programming, Raspberry Pi, Video, Video Encoding  Leave a comment

Posts navigation

← Older posts

Search

Archives

  • January 2021
  • October 2020
  • March 2019
  • January 2019
  • December 2018
  • October 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • March 2017
  • February 2017
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • June 2014
Proudly powered by WordPress | Theme: Moesia by aThemes