Monthly Archives: August 2015

Lock, Latches, Waits and Deadlocks explained weirdly (like never before)!!!

By | August 27, 2015

When conducting MS SQL Server Trainings I often resort to weird examples to explain how certain things work. Over the years I have some favorites that I use over and over. The most disgusting by far would be the one I use to explain Locking, blocking and deadlocks. There are some definite advantages to doing… 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 »

Climate change, the Ozone the scientific method and ignorance

By | August 16, 2015

With the recent climate change talks getting less news coverage than previous years I thought I would revisit some data aggregated over the last year. The data basically contains temperature and rainfall measurements for India over a 100 year time period. The problem with the recent trends in Climate change have to do with 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 »