In code, you can check to see if your component is in design mode with the following code: [Read More]

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]