Microsoft Technology Stack (ESB / ETL / Big Data / Visualization / ECM)

What is the Microsoft Technology Stack for ETL / ESB and Big Data Visualization



 Some time back when I wrote a blog post on Hadoop on Azure (Microsoft Big Data Solutions - Hadoop / Hive and SQL Server) some readers wanted to list the Technology Stack from Microsoft for ETL etc. Here is what I compiled :

Analytics / BI	SQL Server Analysis Services (SSAS)
Big Data	HDInsight / Azure
BPMS / Workflow	Windows Workflow Framework
Cloud	Windows Azure
Database	SQL Server
Enterprise Content Management	SharePoint
ESB	BizTalk
ETL	SQL Server Integration Service (SSIS)
Portal	SharePoint
Reporting	Report Server
SOA	Windows Communication Framework
Visualization	Power Pivot

 

How to Track Page (Pivot Item) Navigation in Windows Phone using .NET (C#) / Windows Phone Pivot Control Events (C#/.NET)

Pivot_Change /SelectionChange  / Page Change Event in Windows Phone using .NET

One of the commonly used Windows Phone Application Type is Pivot. A Pivot application has a Pivot control and many Pivot Items in it.
This gives a good look and feel for content rich App


How to track Pivot Item Change

Each Pivot item contains some unique information, which makes it a necessary for tracking the change of Windows Phone Pivot Items

The XAML of the Pivot Control is shown below

 <controls:Pivot Title="GNANA BHOOMI - TIRUVANNAMALAI" SelectionChanged="Pivot_SelectionChanged>;





The Pivot_SelectionChanged event can be used to track the flip / change of Pivot Item to a new one by the user


private void Pivot_SelectionChanged(object sender, SelectionChangedEventArgs e)



{
  MessageBox.Show(((Pivot)sender).SelectedIndex.ToString());



}

SelectedIndex property provides the Index of the active Pivot Item

Microsoft Big Data Solutions - Hadoop / Hive and SQL Server

How to create Big Data solutions in Microsoft Framework

For quite a while Microsoft developers were baited by Open source folks on the advancement of Big Data solutions in the open source world.

Hadoop + Hive + Pig + R gave a very good platform for Big Data solutions in Open Source platform. Slowly there are many licensed versions that are coming out of the same stack - Cloudera,  Revolutionary R etc.

Microsoft had started Big Data based solutions long back in the Labs have released different tools like PowerPivot etc. Now Microsoft has its own Big Data Technology Stack

Microsoft's Big Data Technology Stack


HDInsight is Microsoft’s Hadoop-based distribution that is available on Windows Azure

The platform can be used for storing large chunks of data (as Blobs, Tables, Columnar Database etc)


SQL Server 2012 is used for Analysis and Integration (ETL)
the SQL Server instance and the Hadoop/Hive data warehouse are

configurable to establish connectivity between them



Real-Time Example of Big Data Solution using Microsoft Technology Stack



(Big Data Solution Courtesy: Ayad Shammout's SQL & BI Blog)

Ayad Shammout's SQL & BI Blog explains how the components are used in various stages effectively for analysing the Audit Logs











 Microsoft's Statistical Component / Solution

Big Data is not data alone - it's more to do with Analyzing the Data. Microsoft has SQL Server 2012 Analysis services. However, certain analysis require custom coding / statistical analysis

Microsoft's Cloud Numerics (now in Azure labs) does exactly the same