In this article by Ronald Rood, we consider the fact that when the jobs get more complicated, it gets harder to understand why something works differently than planned. This article gives the reader a fresh look at how to follow and debug Scheduler jobs in Oracle 11g.Read Debugging the Scheduler in Oracle 11g Databases in full
In this three-part article series by William Rice, we will learn how to add Interactive course material in Moodle. Interactive course activities enable students to interact with the instructor, the learning system, or each other. Note that Moodle doesn't categorize activities into 'Interactive' and 'Static'. In Moodle, all activities are added from the Add an activity... menu after turning the editing on. We use the terms 'Interactive' and 'Static' as a convenient way to categorize the activities that Moodle offers.Read Adding Interactive Course Material in Moodle 1.9: Part 1 in full
In this two-part article by Chris Webb, we will cover query performance tuning, including how to design aggregations and partitions and how to write efficient MDX. The first part will cover performance-specific design features, along with the concepts of partitions and aggregations.
One of the main reasons for building Analysis Services cubes as part of a BI solution is because it should mean you get better query performance than if you were querying your relational database directly. While it's certainly the case that Analysis Services is very fast it would be naive to think that all of our queries, however complex, will return in seconds without any tuning being necessary. This article will describe the steps you'll need to go through in order to ensure your cube is as responsive as possible.Read Query Performance Tuning in Microsoft Analysis Services: Part 1 in full
In the previous part of the article by Chris Webb, we covered performance-specific design features such as partitions and aggregations. In this part, we will cover MDX calculation performance and caching. We'll see how important caching is to overall query performance.Read Query Performance Tuning in Microsoft Analysis Services: Part 2 in full