Skip to content

David Costello

dmcostello.com

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

Author: @davidcostello42

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

Code Scraps: Retrieve all tables in a SQL Server database

24th August 2018 @davidcostello42

MySQL has a really useful command called SHOW TABLES. It lists you all the tables available in the connected database. Unfortunately Microsoft SQL Server doesn’t have such a useful shorthand […]

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

Run a C# or VB.NET Windows Service in debug mode inside Visual Studio

22nd August 201822nd August 2018 @davidcostello42

Here’s a quick tip for running a C#.NET or VB.NET Windows Service in debug mode inside Visual Studio. First – modify the Main() in your C# or VB project to […]

 Code Scraps, Programming  .NET, C#, VB.NET, Visual Basic, Visual Studio, Windows, Windows Services  Leave a comment

Adding error information to TeamCity email notifications

15th August 201824th August 2018 @davidcostello42

JetBrain’s TeamCity is a pretty decent Continuous Integration Server. It’s my go-to CI Server of choice. I’ve set it up in a number of workplaces and convinced a few companies […]

 Computing, Programming  CI, Continuous Integration, TeamCity  Leave a comment

Remote Desktop Connections in Windows 10

11th July 201811th July 2018 @davidcostello42

Recently a Windows update was published by Microsoft that can cause errors connecting to hosts using the Remote Desktop Connection application. The error that displays actually explains the nature of […]

 Computing, Security  Command Line, Remote Desktop, Security, Windows  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

Code Scraps: GenerateApplicationManifest build error in Visual Studio

6th June 20186th June 2018 @davidcostello42

I got an unusual error in Visual Studio the other day that I hadn’t encountered before. The error was relating to an issue doing App.Config Transformations on a C# Windows […]

 Code Scraps, Programming  C#, Visual Studio, VS2013, Windows  Leave a comment

Posts navigation

← Older posts

Search

Archives

  • 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