It’s inevitable that sometimes sql scripts and stored procs can run away with themselves and get quiet complicated. A really handy feature to Rollback a script to a certain point if there’s been a ...

I got a bug through on one of our applications the other day, the user said the system kept on crashing on them. When I checked the error log the inner exception coming through was System.Web.Http...

A very neat command line tool I was not aware of is TaskKill. I’ve recently been having an issue with an automated task in Open Office causing the soffice.bin file to stall and cause a massive back...

So an unusual requirement popped up recently. A 3rd party data update was being applied to one of our data tables which was causing issues. Basically, despite the fact we needed the data sometimes ...

Here is a handy bit of SQL for Oracle to allow you to do an Upsert on a row. MERGE INTO UserDetails DEST USING(SELECT 1 AS ID FROM DUAL) src ON (DEST.userid = 'john.smith') WHEN ...

A really handy design pattern for cleaning up your Javascript is the Revealing Module Pattern, as variables in Javascript are global by default this is a great way to create a OO style class with p...

It’s simple to get JQuery Intellisense in visual studio and two situations where you’d want it. Webpages (html, aspx etc.) Ensure you have the jquery vsdoc file in your project scripts folder....