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
This is the first part of a two-part article series by Marjorie Roswell. All of the recipes in this article require CCK and the date field (also Views, and Views UI), so we won't take the space to list them in every ingredient list. In this two-part article, we create a wide variety of views, mostly from a single workshop content type. Several of the views implement style plug-ins, which appear as new options in the Views Type drop-down. If you are still working on the 1.x versions of Date, be sure to check out Recipe 44, Upgrade Date and Calendar Modules which will be discussed in the next part.Read Date and Calendar Module in Drupal 5: Part 1 in full
Learning how to figure out why things are going wrong is one of the key aspects of developing software. We call it debugging. While dealing with REST services and clients, things can go wrong and it would help a great deal to know how to find out what is causing the problems.
In this article by Samisa Abeysinghe, we will look into the techniques such as message capturing and analyzing to get to know if things are going fine, and if not, what sort of problems are causing trouble.Read Debugging REST Web Services in full
In this 2-part article series by Travis Tidwell, we will cover all the necessary steps to integrate audio content into our Drupal web site by building a custom Flash application that works seamlessly with Drupal multimedia. Here is what we will learn in this article:
- Working with audio in Drupal
- Building a custom audio player for Drupal
- Creating an audio-handling class using ActionScript 3.0
- Loading and playing audio in Flash
Feeds are a very important part of Facebook Applications. They are used to publish notifications and news in a user's profile. So, feeds are the best way to keep the friends of the users up-to-date about the user's current activities. Feeds are also a great way to publicize your applications, if you know what I mean.
In this article by Dr. Mark Alexander Bain and Hasin Hayder, we will go into the details of managing feeds (both news feed and mini feed) using Facebook REST APIs. The following sections will help you understand what the major differences between these two types of feed are, and how to use them properly in your application.Read Feeds in Facebook Applications in full