I’ve been having some problems with writing to a custom event log as well as the standard ‘Application’ event log where it failed with the following error :  Read →

I needed to obfuscate some data for a demo server but rather than re-invent all the data I simply wanted to randomly swap data so associations could not be made between a store and pay rates for example. After a bit of head scratching I came to the conclusion that I simply needed to be able to correlate one set of data with a random set. The simplest way I thought of was to use a row_number() to correlate one list of data with another where one set of row numbers were ordered by a primary key whilst the other used a little trick of ordering by newid() which is recalculated for each row and therefore randomly distributes the data. Here’s the code :  Read →

I didn’t realise you could do it until I found an article describing exactly how to do it and it works a treat! I’m thinking of using my SkyDrive account to backup photos off a NetGear ReadyNAS Duo storage device onto the cloud so they’re all doubly safe!!  Read →