Tag Archives: SQL

Signs

It’s a sign you need either: more sleep; or more coffee when you find code committed into a source code repository that you don’t remember writing and realise when you find it that it was really handy that you wrote … Continue reading

Posted in Database, Programming | Tagged , , | 2 Comments

Learning How To Scale An ASP.NET Application

For the last nine months, the development team at Stella Hospitality Group have been working on integrating a new piece of software into the enterprise. Throughout that process, we’ve come up against various stumbling blocks and subsequently learned how to … Continue reading

Posted in Database, Programming, Work | Tagged , , , , | Leave a comment

Oracle Dynamic SQL Using The DECODE Function

When developing most applications, you end up having to interact with a database. If you’re application is large enough and warrants the design and effort, it will no doubt be tiered as well. If your application is tiered, one of … Continue reading

Posted in Database, Programming | Tagged , , | 1 Comment

Storing Time Information In Oracle

I recently had a requirement to store a time within Oracle, not a timestamp or a date – just the time. As it turns out, storing just the time information in Oracle isn’t something you can do without a little … Continue reading

Posted in Database, Programming | Tagged , , | 3 Comments

WordPress 2.1 Plugin Compatibility

Since the recent release of WordPress 2.1, I thought I would proactively check all of my WordPress plugins for compatibility. I was pleased to find out that through using the suggested plugin development practices that all of my plugins worked … Continue reading

Posted in Blogging, Programming, Software | Tagged , , | Leave a comment