I had an issue today trying to get data from a client where we had access to their database via their VPN, but couldn’t do a straight SQL Server transfer. I opted to use the bcp utility to export the table to a 0.75GB file, which I was then able... [Read More]

There are often cases when you need to format a string or number into a string with a specified length. SQL Server 2008 doesn’t have an inbuilt “PAD” function, but you can get around that with some String functions. [Read More]

I’ve been using XBMC at home, and I’ve been trying to find software to edit Genres on my movie files so I can sort them a little better. To my surprise, I couldn’t find anything that seems to be able to edit tags on all the file types that I... [Read More]

One of the challenges when creating web applications is the separation of logic between the client and the server. Most solutions will have the concept of “lookups” e.g. categories or some type of data that is static but necessary for the business logic. In terms of the server-side code, you... [Read More]

We use Visual Studio 2012 with an older version of Resharper at work. I’ve been wanting to use Visual Studio 2012, but our version of Resharper isn’t compatible, and although I can get by without most of the features, the one I REALLY REALLY REALLY miss is the ability to... [Read More]