Step by Step Guide of BI Case Study of MYSQL via Visual Studio Code-SharePoint 2016

February 28, 2019

Step 1: Install MySQL environment
Go to following link:
Download MSI package, and install MySQL Server by following default steps.
After MySQL Installation, SharePoint 2016, Central administration and all sites collection, stop working.

Investigating error in ULS logs show following error:

Application error when access /default.aspx, Error=The connection string name is missing for the MySqlSiteMapProvider

at MySql.Web.SiteMap.MySqlSiteMapProvider.Initialize(String name, NameValueCollection config)

at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType)


Central administration, has web site in IIS. Suppose your central administration pot is 39805, then your web site will be located at following location.

You have to add the following code to the web.config file :




<remove name=”MySqlSiteMapProvider” />




Similarly, for all web applications, in SharePoint, see the port of web application. For each web application, see the virtual directory as below.


Where XXX, is the port of web application of SharePoint environment.

After these web.config changes, Central administration and all site collection, starts working properly.

For details about POC , see the attached PDF. Step by Step Guide of BI Case Study of MYSQL via Visual Studio Code


IOT for Cisco kinetics IOT Platform

October 31, 2018

Recently, I have been working on few POC related to IOT for Cisco kinetics IOT Platform for motion detection with Axis IP Cameras.

Here is Glossary:

What Kinetic Internet of Things (IoT)?

Cisco Kinetic makes it easy to connect distributed devices (“things”) to the network, and then extract, normalize, and securely move data from those devices to distributed applications. The Kinetic platform also plays a vital role in enforcing policies defined by data owners, so they can control which data goes where, and when.

Cisco Kinetic is a distributed system of software that streamlines your IoT operations by performing the following three key functions:

  • Extract datafrom disparate sources (“things”), regardless of protocol. The data is transformed so it is by the applications that provide business value.
  • Compute dataanywhere from the edge to a destination to provide processing where it’s needed. This enables fast decisions at the point of action, dramatically reduces latency, and makes the most efficient use of network resources.
  • Move dataprogrammatically to get the right data to the right applications at the right time. The platform distributes data in multi-cloud, multi-party, and multi-location situations. Data policies are used to enforce data ownership, privacy, and security.!overview/overview

What is IoT Hub?

IoT Hub is a managed service, hosted in the cloud, that acts as a central message hub for bi-directional communication between your IoT application and the devices it manages. You can use Azure IoT Hub to build IoT solutions with reliable and secure communications between millions of IoT devices and a cloud-hosted solution backend. You can connect virtually any device to IoT Hub.

IoT Hub supports communications both from the device to the cloud and from the cloud to the device. IoT Hub supports multiple messaging patterns such as device-to-cloud telemetry, file upload from devices, and request-reply methods to control your devices from the cloud. IoT Hub monitoring helps you maintain the health of your solution by tracking events such as device creation, device failures, and device connections.

Edge computing—also known as just “edge”—brings processing close to the data source, and it does not need to be sent to a remote cloud or other centralized systems for processing. By eliminating the distance and time it takes to send data to centralized sources, we can improve the speed and performance of data transport, as well as devices and applications on the edge.

Fog computing is a standard that defines how edge computing should work, and it facilitates the operation of compute, storage and networking services between end devices and cloud computing data centers. Additionally, many use fog as a jumping-off point for edge computing.


Microsoft Flow Presentation

June 30, 2018


Topic: Microsoft Flow
Scope: basic
Level: Executive

Click here to download presentation

Code organization ideas-SPA-SharePoint Add-in

May 23, 2018

Don’t want to be shameless, self-promoted…….:)……But here is my folder structure for for SharePoint Add-in with following keywords.
#[Somebody might get code organization ideas.]
#[Code structure for SharePoint Add-in]
#[Folder structure for SharePoint Add-in]
#[Single Page App, SPA as of SharePoint Add-in/SharePoint Hosted App]
#[AngularJS app for SharePoint Online]
#[AngularJS based App for SharePoint 2016]
#[AngularJS Add-in for SharePoint Online]
#[AngularJS Add-in for SharePoint 2016]
#[SharePoint Hosted App]
#[Angular-UI based SharePoint development]
#[Angular-UI based Two way binding and separation of concern for SharePoint development]
#(Angular UI Grid, based client side development SharePoint development )
#[Bootstrap based SharePoint development]
#[Bootstrap-UI based SharePoint development]
#[NG-Router based SharePoint development]
#[Module loading based on RequireJS for SharePoint Add-in/SharePoint Hosted App]
#[Lazy loading of AngularJS Controllers via RequireJS for SharePoint Add-in/SharePoint Hosted App]
#[MVC based app development for SharePoint Add-in/SharePoint Hosted App]
#[MVVM based app development for SharePoint Add-in/SharePoint Hosted App]
#[MVP based app development for SharePoint Add-in/SharePoint Hosted App]
#[JS-JavaScript design pattern for SharePoint Add-in/SharePoint Hosted App]
#[JS-JavaScript OOP for SharePoint Add-in/SharePoint Hosted App]
#[SharePoint client side development-JSOM for SharePoint Add-in/SharePoint Hosted App]
#[SharePoint client side development-Rest API for SharePoint Add-in/SharePoint Hosted App]
#[John Papa, SPA ideas for SharePoint Add-in/SharePoint Hosted App]
#[ Andrew Connell – SPA ideas for SharePoint Add-in/SharePoint Hosted App]

Crystal clear focus provide a depth of knowledge.

April 29, 2018

Software Industry is evolving very fast. A lot of dimensions are there. So it is very important for a software professional to focus. Crystal clear focus provide a depth of knowledge.

My career focus is as:

  • Cloud Productivity/Platform (Office 365/Azure)
    • Collaboration and Content (SharePoint)
    • Project and Portfolio Management (Project Server)
    • Application Development


Application Architecture Cloud Guide attached is very important to grow knowledge about Azure design.

This guide presents a structured approach for designing cloud applications that are scalable, resilient, and highly available. The guidance in this ebook is intended to help your architectural decisions regardless of your cloud platform, though we will be using Azure so we can share the best practices that we have learned from many years of customer engagements. In the following chapters, we will guide you through a selection of important considerations and resources to help determine the best approach for your cloud application:

  1. Choosing the right architecture style for your application based on the kind of solution you are building.
  2. Choosing the most appropriate compute and data store technologies.
  3. Incorporating the ten high-level design principles to ensure your application is scalable, resilient, and manageable.
  4. Utilizing the five pillars of software quality to build a successful cloud application.
  5. Applying design patterns specific to the problem you are trying to solve.

Thanks to Microsoft and LinkedIn, for sharing the guide with me.

JavaScript in SharePoint App development / SharePoint Framework

March 31, 2018

JavaScript in SharePoint App development / SharePoint Framework.

AngularJS based App.  Angular-UI

Bootstrap based App.



Shared with Thanks to Progress, Telerik.

Office 365 – Sway

June 18, 2016

Topic: Office 365 – Sway
Audience: Executive
SCOPE: Brief

Office 365 – Sway

* Most of the presentations are dual purpose – To present and To use a Tutorial.