Code Scrap: Testing for Domain presence on Windows
I’ve been making a support utility that monitors if message queues and database tables are being read from and written to as part of the day to day activities in […]
Programming
Code Scraps: Script zipping, transfer and unzipping in a Windows Batch Script
This code scrap illustrates how you can have a Batch File create a deployment zip, transfer the zip to a target server, and then unzip at the other end. Zipping […]
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 […]
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 […]
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 […]