Technical Log

This is my technical log of interesting issues I run into in the field, mainly using the Microsoft stack:

  • C# and .NET
  • SQL Server
  • BizTalk Server 2010

Birthday Problems, Friendly Identifiers, and MongoDB

Recently I came across a bit of an interesting problem. An application I was working with had functionality that required the generation of user-friendly identifiers (e.g. 8 or less numbers). This seemed to be working pretty well the first day … Continue reading


Preventing SQL Injection in BizTalk

I was reviewing a solution recently using the BizTalk WCF-OracleDB Adapter and detected an interesting security vulnerability. Before you dismiss this as “I’m using SQL Server, I’ll be right mate”, this issue probably also affects the BizTalk WCF-SQL Adapter and … Continue reading


What’s your IDE look like?

A couple of recent releases have prompted me to spend a little time trying a new style for my IDE. Specifically: The Tomorrow Theme (and associated Hacker News thread) Adobe Source Code Pro font (and associated Hacker News thread) The … Continue reading


How to Change the Commands FtpWebRequest Sends

Below I discuss how I’ve worked around some limitations of the System.Net.FtpWebRequest to allow low-level customisation of the actual commands sent by the FtpWebRequest class. This allows resolution of a couple of issues, including: Customising the logon sequence (allowing support … Continue reading


FtpWebRequest is Broken

I’m going to take a brief break from helpful solutions to have a bit of a rant about FTP support in the .NET Framework. When all you have is hammers.. FTP as a protocol is pretty lousy, but its support … Continue reading


Detecting Duplicate XML data in SQL Server

Had the interesting problem today of trying to detect duplicate XML values in a SQL Server table (stored in a column of field type XML). I’m not the first to cover this issue: Matt Woodward has covered the simplest case … Continue reading


Zebras in System.Net.NetworkCredential

Ran into an interesting problem recently where some pretty straightforward FTP code was throwing a WebException on GetResponse when using correct server details. Looking a little further, the error indicated there was an Object reference not set to an instance … Continue reading