My machine was dying a miserable death today, as it has done often lately, and it was all down to a bug between Bluetooth software and Skype. What I noticed is literally hundreds of the same process “BluetoothHeadsetProxy.exe”, with a new one spawning every few seconds. [Read More]

Default constraints can be added in Management Studio by setting a default value for a field in the designer, or by specifying it in your table create script. This SUCKS though, because it generates a random name for the constraint, which can lead to inconsistencies across databases - if you... [Read More]

I’m perpetually restoring databases, and doing it via the GUI using SQL Server Management Studio is tedious. Instead, I like to use a script to restore my database. This involves the creation of a .bat file and an accompanying .sql file, as follows: [Read More]

Exporting an SVN repository to an Hg repo is dead easy with the latest version of TortoiseHg: [Read More]

I had a freaking nightmare deploying an MVC3 app today. Seems simple. Database was up and running. The code was deployed and had been tested on our local systems. I deployed via our amazing SVN deployment process, and published on the live server. Permissions applied automatically, all the files appeared... [Read More]