Michael is an experienced software architect/engineer from Arbroath, Scotland,
specialising in C#, PHP, AJAX, Web Services, MySQL and Microsoft SQL Server.
He also loves an ice-cold Jack and Coke and a good tikka masala.
November 30th, 2011
No Comments
I’ve been working on a project where I have to maintain data in a SQL Server database. In order to prevent different users updating the same data at the same time, I’ve also employed optimistic locking by using a “timestamp” field called OLToken on each table which is binary. This field is read out and [...]
July 7th, 2011
1 Comment
I recently had to perform a change on any stored procedures that contained a certain piece of text. Not knowing how to search for text across a database, I googled it and found the following small piece of useful code: [Via: ASP FAQ]
July 16th, 2009
No Comments
The Pro Shop that I developed at Computa Services for the Carnoustie Golf Links, is now live. It uses concurrent AJAX, calling a lightweight PHP+XML web service layer to communicate with a Microsoft SQL Server. The management application that the staff at the Links use to administer the bookings is written in C#, using C# [...]
November 15th, 2008
No Comments
The online tee-time booking system that I developed at Computa Services for the Carnoustie Golf Links, is now live. It uses concurrent AJAX, calling a lightweight PHP+XML web service layer to communicate with a Microsoft SQL Server. The management application that the staff at the Links use to administer the bookings is written in C#, [...]
March 13th, 2006
No Comments
Why can’t you use GetDate() inside a Sql Server User-Defined Function?
