General

Understanding SCOPE statement in MDX

Problem Today, I received a special requirement from my client that they wanted to build a report for counting distinct Brand Name of Digital Media Type. For example, a data source as below And the client expected the output as below As you saw two above image, the client only wanted to count unique Brand … Continue reading Understanding SCOPE statement in MDX

Advertisements

Understanding Window Server Failover Clustering, SQL Server Failover Cluster Instances and AlwaysOn Availability Groups

In a couple of weeks ago, one of my colleagues discussed with me about some solutions for High Availability and Disaster Recovery in Microsoft SQL Server. However, it seems there were some misunderstanding about Proof of Concepts (POC) among Window Failover Clustering (WSFC), SQL Server Failover Cluster Instances (FCIs) and AlwaysOn Availability Groups. In this … Continue reading Understanding Window Server Failover Clustering, SQL Server Failover Cluster Instances and AlwaysOn Availability Groups

How to pass parameters to MDX script through ADOMD libraries?

In the previous article, I provided the simple example to start working on ADOMD libraries. The small application was implemented to execute the MDX file. The MDX query returns data from Jan to September in 2014 and the same period in 2013 (Year-To-Date report) Now, we need a flexible method that allows us to choose … Continue reading How to pass parameters to MDX script through ADOMD libraries?

How to execute MDX query with ADOMD libraries

In previous article, I introduced the solution to execute a MDX query by SQL store procedure. However, it has some limitation such linked server performance, user permission... There are other approaches to overcome those disadvantages of the store procedure. In this article, I will introduce ADOM.NET library which also support executes a MDX file. It … Continue reading How to execute MDX query with ADOMD libraries

How to install Hadoop single node on Ubuntu 14.04 LTS

In this article, I would like to provide basic steps to install a Hadoop single node on Ubuntu 14.04 LTS. Basically, Hadoop is an open-source framework used for distributed storage and processing of dataset of big data using MapReduce model. Click here to see more detail. Prerequisite condition You absolutely install Hadoop on Window OS … Continue reading How to install Hadoop single node on Ubuntu 14.04 LTS