Technical Log

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

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

Birthday Problems, Friendly Identifiers, and MongoDB

Posted by Matt Mitchell on June 26, 2015

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 →

Comments

Preventing SQL Injection in BizTalk

Posted by Matt Mitchell on July 22, 2013

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 →

Comments

What’s your IDE look like?

Posted by Matt Mitchell on October 10, 2012

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 →

Comments

How to Change the Commands FtpWebRequest Sends

Posted by Matt Mitchell on July 30, 2012

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 →

9 Comments

FtpWebRequest is Broken

Posted by Matt Mitchell on July 29, 2012

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 →

2 Comments

Detecting Duplicate XML data in SQL Server

Posted by Matt Mitchell on July 20, 2012

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 →

Comments

Zebras in System.Net.NetworkCredential

Posted by Matt Mitchell on July 9, 2012

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 →

Comments