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
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
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
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
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