Latest Articles

Debugging the Scheduler in Oracle 11g Databases

by Ronald Rood | July 2009 | Oracle

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

Adding Interactive Course Material in Moodle 1.9: Part 1

by William Rice | July 2009 | Moodle Open Source

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

Query Performance Tuning in Microsoft Analysis Services: Part 1

by Chris Webb | July 2009 | .NET Microsoft MySQL PHP

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

Query Performance Tuning in Microsoft Analysis Services: Part 2

by Chris Webb | July 2009 | .NET Microsoft MySQL PHP

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
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software