"Fortunate are those who take the first steps.” ― Paulo Coelho

Cloud Design Patterns – Book Download

This guide contains twenty-four design patterns and ten related guidance topics that articulate the benefits of applying patterns by showing how each piece can fit into the big picture of cloud application architectures. It includes code samples and general advice on using each pattern.

September 22, 2014 Posted by | Uncategorized | Leave a comment

How to call C#.NET Class Library from Office VBA

1 2 3 4 5 6 7

August 23, 2014 Posted by | .NET General, Office, VBA | Leave a comment

ML : How to develop a mode, algo use and one liner explanation

Supervised Learning – Classification, Regression

Unsupervised Learning – Clustering, Recommendation


(1)Classification (Y/N/not sure, Maligant tumour or not)
Which customer are more likely to buy, stay, leave(churn analysis)
Which customer is going to get loans
Which transactions are fradulent
Which quotes are more likely to get executed

   What are the algorithms are there for Classification..
1.BCD (Boosted decision tree)
2.DF (Decision Forest)
3.DJ (Decision Jungle)
4.LR (Logistic Regression)

(2) Regression (Predictive analysis)
1. Stock price prediction
2. Market forecast
3. Weather forecast
4. Calculate insurance premiums based on different factors(feature)
5. Manpower prediction
6. Workload prediction
What are the algorithms are there for Regression..
1. Bayesian Linear
2. Linear Regression
3. Ordinal Regression
4. (BCD) ANN, Boosted Decision Tree
5. DF (Decision Forest)

(3) Cluster (Segmentation)
Divide a customer base into groups of individuals, age, market segmentation,
Data compression, color reduction, pattern recognition
             Which Algorithm to use..
1. K-means

(4) Recommendations (Product recommendation)

1. Amazon Recommender system
Algorithm: Matchbox

August 11, 2014 Posted by | Azure ML, MarketLearning | Leave a comment

Feature Exploration, Visualization and Predictive Modeling with R and AzureML

Iris Data Set
Needless to say, here is the master piece

Hats off to Raja Iqbal for this wonderful meetup session.


August 7, 2014 Posted by | Azure ML, Machine learnign | | Leave a comment

Partners Say New Azure Machine Learning Service Could Be Microsoft’s Secret Weapon In The Cloud

Microsoft earlier this month launched a preview of a new cloud service called Azure Machine Learning, and some partners are already using it to build the sort of apps that used to require a team of expensive data scientists to pull off.

August 4, 2014 Posted by | Azure ML, Machine learnign | , | Leave a comment

Office Click-to-run add-in supportability.

Even though the Office product runs in a self-contained environment, the Office product can interact with the other applications that are installed on the computer. Macros, in-document automation, and cross-Office product interoperability will work. Click-to-Run is also designed to allow locally-installed add-ins and dependent applications to work with it. However, there is the possibility that some add-ins or other integration points with Office might behave differently or might not work when you are using Click-to-Run.

 In-process, out-of-process, and hybrid add-ins

A key differentiator from a technical standpoint is whether the add-in is loaded in-process by an Office application or whether an out-of-process application is making a call into Office. 

Out-of-process add-ins/applications are stand-alone programs, scripts, or applications that use Office object model APIs to start functionality in the application and integrate with Office. In this case, the out-of-process application drives Office. Out-of-process applications are not supported in Click-to-Run.

In-process add-ins are loaded in-process by an Office application, and detected and opened by the application. Because of this, the Office application can use existing mechanisms, such as looking at specific registry keys or locations in the file system to discover all in-process add-ins. There is no such mechanism for out-of-process add-ins. Generally, in-process add-ins work with Click-to-Run. 

July 31, 2014 Posted by | Uncategorized | Leave a comment

How to create Automation COM Add in (in slideshow steps)

July 30, 2014 Posted by | .NET General | Leave a comment

Weekend Interesting read -DataScience & ML – Part1

66 job interview questions for data scientists

Azure ML: A Brief Introduction

ml ml1

July 27, 2014 Posted by | Azure ML, Machine learnign, Uncategorized | , | Leave a comment

FREE Microsoft eBooks

Largest collection of FREE Microsoft eBooks ever, including: Windows 8.1, Windows 8, Windows 7, Office 2013, Office 365, Office 2010, SharePoint 2013, Dynamics CRM, PowerShell, Exchange Server, Lync 2013, System Center, Azure, Cloud, SQL Server, and much m

Microsoft Senior Sales Excellence Manager – Eric Ligman

July 10, 2014 Posted by | Uncategorized | Leave a comment

Win API (HWND) integration in Outlook is not a supported platform technology.

How to add a window that is adjacent to the preview pane in Outlook  –

June 18, 2014 Posted by | Uncategorized | Leave a comment

Support guidelines for client-side messaging development – KB266353

Why Win32 API is not supported

June 14, 2014 Posted by | Outlook, Uncategorized | Leave a comment

Exchange 2010 does not support WebDAV ( discontinued)

Exchange 2007 was the last version of Exchange to support using WebDAV.

Developer roadmap for Exchange ( search for WebDAV)

Discontinued Features

What may work for you is to use Exchange Web Serveries (EWS), which overall has superior calendaring abilities.  There is a .NET API called the EWS Managed API which wraps EWS calls and should make using EWS a lot easier.

Differences between the EWS Managed API and EWS

EWS Managed API reference

Microsoft Exchange Web Services Managed API 2.2

Explore the EWS Managed API 2.0


June 12, 2014 Posted by | Office, Outlook | Leave a comment

Office update center- build number and SP’s details + Open XML SDK 2.5

Open XML SDK 2.5 for Microsoft Office

Update center for Office, Office servers, and related products

June 12, 2014 Posted by | Outlook | Leave a comment

Microsoft Office Configuration Analyzer Tool 1.2

The Office Configuration Analyzer Tool 1.2 (OffCAT ) provides a quick and easy method to analyze most Microsoft Office programs for common configurations that may cause problems. *Download only OffCAT.msi if you want to install OffCAT. Review the ReadMe file to see if the other files are needed.

Supported Operating System

Windows 7, Windows 8, Windows Vista Service Pack 2, Windows XP Service Pack 3
This download works with the following Microsoft Office products:

• Microsoft Office 2013 (32-bit or 64-bit, Click-to-run or Msi installs)
• Microsoft Office 2010 (32-bit or 64-bit)
• Microsoft Office 2007
OffCAT version 1.2 provides scanning for the following Office programs:

•Microsoft Access
•Microsoft Excel
•Microsoft InfoPath
•Microsoft OneNote
•Microsoft Outlook
•Microsoft PowerPoint
•Microsoft Publisher
•Microsoft Visio
•Microsoft Word
The following minimum version of the Microsoft .NET Framework is required:
• Microsoft .NET Framework Version 2.0
The following Microsoft Office feature is also required:
• .NET Programmability Support

June 11, 2014 Posted by | Office | | Leave a comment

Exchange Sp details, support life cycle, EWS Java API – Links

EWS Java API 1.2 – get started!

Exchange: EWS Java API 1.2

Supportability of Microsoft EWS Java API 1.1 for Exchange Server 2007/2010 – Brij Blog

Exchange Server and Update Rollups Build Numbers

Microsoft Support Lifecycle

June 10, 2014 Posted by | Exchange EWS | Leave a comment

Procdump is preferred over Adplus- About ProcDump.

There may be many ways to capture the dumps in winodws, but which one gives us the better dumps ? Obviously Procdump has lot of advantage, details and preferred over Adplus when see the details in Windbg. 

We suggest to use Procdump and also carefully select the bitness when capturing dumps. For 64 bit use -64 or else leave it blank(default it is 32 bit).

 The syntax goes like this for crash-> Procdump -e -ma -t -64 -w Outlook.exe    (Procdump page has got details about these command line switches)

Let me put it in steps,

1)    Before taking dump, enable page heap corruption checking using the following command:   gflags.exe -p /enable outlook.exe /full

 2)    Now run the procdump command to capture the dump with bitness set accordingly. Procdump -e -ma -t -64 -w Outlook.exe  Wait for the crash and confirm dump has been created successfully.

 3)    After the crash, reset command: gflags.exe -p /disable outlook.exe You can use the following command line to see if page heap checking is enabled:    gflags.exe –p

 For additional info, refer Dan B blog post here and about procdump quick video here.

June 6, 2014 Posted by | Uncategorized | | Leave a comment

Why Office server side automation is not supported, EWS Links, Open XML starter pack

1)      Considerations for server-side Automation of Office –

 2)      EWS API links – Below are some starter links. 

 Exchange for developers –

 Developer roadmap for Exchange –

 Get started with EWS Managed API client applications -

 EWS Managed API concepts –  

 Working with the EWS Managed API –

 Microsoft Exchange Web Services Managed API 2.1  –

 C# Sample code:

        //pass the credential and EWS asmx detail

       privateint GetUnreadCount()


            ExchangeService service = newExchangeService(ExchangeVersion.Exchange2013);

            service.Url = newUri(“https://yourcasserver/ews/exchange.asmx“);

            service.Credentials = newWebCredentials(“Username”, “Password”);


            Folder inbox = Folder.Bind(service, WellKnownFolderName.Root);

            SearchFilter sf = newSearchFilter.SearchFilterCollection(LogicalOperator.And, newSearchFilter.IsEqualTo(EmailMessageSchema.IsRead, false));

            ItemView view = newItemView(50);

            view.Traversal = ItemTraversal.Shallow;

            FindItemsResults<Item> findResults = service.FindItems(WellKnownFolderName.Inbox, sf, view);

            //get the count

            int count = findResults.Count();

            return count;


3)      For Open XML,

By default, this download installs files to the following locations:

i. Visual C# snippets. PersonalFolder\Visual Studio 2010\Code Snippets\Visual C#\Open XML SDK 2.0 for Microsoft Office 2010

ii.  Visual Basic snippets. PersonalFolder\Visual Studio 2010\Code Snippets\Visual Basic\Open XML SDK 2.0 for Microsoft Office 2010

Generating Excel 2010 Workbooks by using the Open XML SDK 2.0

4)      Regarding EWS Editor –

May 29, 2014 Posted by | Uncategorized | Leave a comment


Get every new post delivered to your Inbox.