Recent Posts
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
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
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
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
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
Deleting duplicate records using T-SQL
WITH cte AS ( SELECT [Field1], [Field2] row_number() OVER(PARTITION BY [Field1], [Field2] ORDER BY [Field1]) AS [rn] FROM [Table1] WHERE [Column1]=[Condition1] ) DELETE cte WHERE
George Square, Glasgow – 19th September #throughglass
I was working late at our St. Vincent Place HQ on the day after the referendum and heard some noise down at George Square with Google
T-SQL script for identifying deadlocked processes
A useful script for identifying SQL deadlock cause/victim. WITH [Blocking] AS (SELECT w.[session_id] ,s.[original_login_name] ,s.[login_name] ,w.[wait_duration_ms] ,w.[wait_type] ,r.[status] ,r.[wait_resource] ,w.[resource_description] ,s.[program_name] ,w.[blocking_session_id] ,s.[host_name] ,r.[command] ,r.[percent_complete]
placeholde.rs – A hosted image placeholder service for developers & designers
placeholde.rs is a hosted image placeholder service for developers & designers. Just specify width and height, tweak the parameters and grab the URL.