I’ve been using Redgate SQL Source Control on an install of SQL Server Management Studio 2014 for a while now. It works well and integrates with our version control setup to give us a bit of reassurance when developing. I…
I’ve been using Redgate SQL Source Control on an install of SQL Server Management Studio 2014 for a while now. It works well and integrates with our version control setup to give us a bit of reassurance when developing. I…
Here’s a little problem I faced the other day. Filtering rows against a timescale based on three dates that may or may not exist. This way round the problem uses the IFNULL, GREATEST and LEAST MySQL functions. IFNULL has to…
I started working at Firebrand Training in 2007 when the company was still called Training Camp. Taking over from an outgoing developer, I had to endure two mammoth interviews before starting work in their central London office. A blog post can’t…
This is something I’ve been meaning to do for a while now. Resurrecting an old PHP CMS Project that I built back in 2006. I had great fun building this initially so thought it would be a good little project to breath…
Every time I come to write an SQL query that uses the current time against a time stamp in a record, someone always seems to suggest a different way of solving the problem. That in itself isn’t an issue, there’s…
We run a dynamic website that retrieves information from a relational database. There’s lots of content involved across loads of domains and in several languages, this makes the site fairly heavy. Performance is as important as ever and it’s only…
I’ve been working on a project over the last week that involves fairly heavy use of Stored Procedures. It’s not a new technology and we’re not that new to it either, it’s just that during the development cycle the logic…
jetaway.com is a database driven site providing a travel agency style flight booking facility. It uses Active Server Pages to query and update a database. The design is based around a simple colour and logo scheme that is implemented using…