Tag Archives: post

VM and IP Configurations

By | September 18, 2015

Recently there was a post on DB mirroring not working on a VM, in the post I had suggested checking the network connectivity and NIC configurations in the VM software since there are different ways that the VM software assigns IP to the Virtual devices. For the purpose of this post I am using VMware… Read More »

The History of War Analyzed

By | September 9, 2015

War is an ugly topic, but I wanted to know if we have learnt anything from history and so I downloaded the data for all the wars since 1900 till date to get an understanding of how things have changed. The below chart shows the duration in years on the x axis and the count… Read More »

Better Triage: Getting hospital care delivered properly

By | August 18, 2015

If you have seen my recent posts on LinkedIn you probably know that I am looking to interact with healthcare professionals to brainstorm ideas on how Triage can be improved. In this post I will cover what Triage is and some common issues identified with the process and my attempt at a solution. I am… Read More »

SSIS – Fuzzy grouping task

By | August 18, 2015

It’s warm, fuzzy and brings similar data together helping correct typos, different titles for the same role and much more. Today I present a short video explaining how to configure a Fuzzy Grouping task within SSIS. It carries forward from my previous post on exporting LinkedIn contacts information to created Analytics on contacts information. The… Read More »

Video for SSIS Starter kit

By | August 11, 2015

A video explaining all the tasks (control flow and data flow) for the SSIS series for beginners. https://www.youtube.com/watch?v=zrarG-cU4RQ Here is the list of blogposts that contain the complete list of steps. http://enabledbusinesssolutions.com/blog/ssis-starter-kit-for-the-uninitiated-foreachloop/ I am waiting to modify the package to perform a few additional tasks. If you need the code urgently, please PM me and… Read More »

SSIS – Starter kit for the uninitiated – Data enrichment

By | August 10, 2015

In this last post (after which there will be a video explaining how to bring all this together in Power view) I cover how to convert geo coordinates from 38° 53′ 55.133″ N to Decimal Coordinate system 38.898648. You can find the previous posts here. The calculations is fairly simple the sql for it is… Read More »

SSIS – Starter kit for the uninitiated Data Flow Task

By | August 7, 2015

In this post we explore how to use the DFT (Data Flow Task) to load data from an XML file into the database. For previous post on how we got till this step please click here. Step Screenshot Double Click and open the DFT we had added in the previous post. Drag and Drop an… Read More »