jQuery Change Persister for DOM text inputs

Example usage:

Set the value:


Extracting a price from a VARCHAR in T-SQL


Virgin Money London Marathon 2015

I will be running the 2015 Virgin Money London Marathon on 26th April 2015 for the British Lung Foundation who are currently funding research on the prevention of lung damage in COPD and many other areas related to lung disease.  You can read more about the BLF’s research here.

My fundraising target this year is £1,750.00 and any donations, big or small, would be greatly appreciated.  My fundraising page can be found here.

If you leave your name on the donation list, I’ll be sure to contact you to say thanks :-)

Arduino Christmas Tree Project

I decided that it was essential to give our customers the ability to turn our Christmas tree lights on and off over the web.


Check out our Christmas Tree API here, Arduino code below.  Live stream to follow!



Code Running on Arduino UNO


The number of records in the table exceeds the maximum number of 5000 – Dynamics

When attempting to export records via Microsoft Dynamics and the number of records is greater than 5,000, you may receive this error.

The number of records in the table exceeds the maximum number of 5000. Set a filter to decrease the number of records in the table. Exporting too many records at once can affect system performance.

Dynamics CRM Online

Follow this guide.

Dynamics NAV

Open using your preferred ClientUserSettings.config

NAV 2013 R2
Default location is

NAV 2013
Default location is

NAV 2009
On Windows 7, Windows Vista, or Windows Server 2008, the default location is

On Windows Server 2003 or Windows XP, the default location of this file is


is the name of the user.

Change MaxNoOfXMLRecordsToSend property value from 5000 to, for example, the maximum integer value of 2147483647

If you’ll insert a number bigger that 2147483647 you’ll receive the following error message:

The MaxNoOfXMLRecordsToSend config

Duration setting must have a value between -2,147,483,648 and 2,147,483,647.

Self-Executing Functions in JavaScript

I’ve been steadily migrating my JavaScript assets to use self executing functions (and more recently literals) as they are a good way to enforce scope on variables and make your JavaScript more readable.

The examples below show the difference between implementing a self-executing function and using literals.

I have found that on most browsers (except Safari), there is a considerable performance win when using literals.

Creating a module via a self-executing function

 Creating a module via object literals


Using a Git repository with an existing Heroku app

You can  take an existing Git repo and add a remote using the git URL provided when you created your app. You may need to do this to associate a Git repository with an existing application.

The Heroku git:remote command will add this remote for you based on your applications git URL.


Deleting duplicate records using T-SQL