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 […]
Author: @davidcostello42
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 […]
Code Scraps: Retrieve all tables in a SQL Server database
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 […]
Run a C# or VB.NET Windows Service in debug mode inside Visual Studio
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 […]
Adding error information to TeamCity email notifications
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 […]
Remote Desktop Connections in Windows 10
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 […]
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 […]
Code Scraps: GenerateApplicationManifest build error in Visual Studio
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 […]