Category Archives: Database

Are Daily Backups Really Sufficent?

Monday afternoon we had a critical failure of an Oracle database at work. Within a few minutes of the fault taking place, I started seeing block corruption errors whilst I was reviewing some information in the production environment. At this … Continue reading

Posted in Database, Hardware, Work | Tagged | 3 Comments

Tech Ed 2007, Day 3 Wrap Up

Yesterday I looked into the building of Background Motion using the Composite Web Block, the Enterprise Library and putting all of the different .NET 3.x technologies together in a demonstration product named Dinner Now. Today was focused around SQL Server … Continue reading

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

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