Every time I get a new machine, I always have to set up Console2 again, and because I have the memory of a goldfish, I always forget how. So this time around, I thought I would blog the minor changes I make. [Read More]

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]