Alan Coleman
Web Dev & Creative Blog
Welcome to my Web Dev & Creative Blog. I'm a web developer interested in technology, design and photography.
Category Archives: Server
SQL Filtering against a time stamp
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 … Continue reading
Critisim from Microsoft
I’m still trying to get my head round Microsoft’s crisitism of our comapny website this week. Yes, Microsoft. The comapny that revolutionised the web with Internet Explorer, the Firebrands that changed the face of search with Bing and bossed development … Continue reading
Database caching of non dynamic content
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 … Continue reading
Strored Procedures
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 … Continue reading
jetaway.com
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 … Continue reading