APEX can be a great way to create an application rapidly on an Oracle Database. Although it is generally straightforward, there are just a couple of things you have to watch out for.… Read more
One of the more important tasks in the process of rolling out incremental developments to a multi-server production system is to double-check that all of the planned modifications, and nothing else, have been deployed. An Oracle expert, Bruce Armstrong, comes across SQL Compare for Oracle, and sees if it helps with this time-consuming task.… Read more
Tom Kyte's contribution to the AskTom column and site over ten years has been outstanding. Much of what he says has relevance to all relational databases. His views are straightforward, the discussions he provokes are lively: Not only does he know a frightening amount about both Oracle and SQL Server, but he's also refreshing to listen to. … Read more
We soon learn, in SQL Server, that heaps are a bad thing, without necessarily understanding how or why. Jonathan Lewis is an Oracle expert who doesn't like to take such strictures for granted, especially when they don't apply to Oracle. Jonathan discovers much about how SQL Server places data, and concludes from his experiments that heaps perform badly in SQL Server because you cannot specify a fill factor for them.… Read more
From hope and euphoria, to desperation, firings and the ultimate demise of a company. Tim Gorman charts the rise and fall of a "visionary" IT project.… Read more
