Tag Archives: help

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 »

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 »

A simple change that could save Millions of $$$ in Support services

By | August 5, 2015

I recently came across the below error message “An exception was thrown by Target of invocation” What it really means is the application you tried to run has reported an error. This got me thinking about how software has ignored one of the most important yet frustrating aspects of user experience. Easy to understand and… Read More »

SSIS – Starter kit for the uninitiated – Foreachloop

By | August 4, 2015

I was up at 3:00 AM in the morning and felt that the world needs to know where all the airports are and how you could use SSIS and PowerView to display this information in a clean and concise way. This need was so powerful that I spent the next 4 hours writing an SSIS… Read More »

Sports- Answer to the Ultimate Question of Life, the Universe, Project Management and Everything”

By | July 1, 2015

I recently was posed an interesting question. How to measure an individual’s contribution or the success of a project. A question we all face during our appraisal cycles. While I am no expert, I rely on my experience from my college years a lot when faced with management questions. To provide some context, I was… Read More »

Performance Tuning CPU issues in MS SQL Server – Indexes

By | March 18, 2015

In this video we cover how the correct use of Indexes can help elimintae CPU bottlenecks , we cover how to identify CPU issues and a few different ways the issues can be resolved. Performance Tuning CPU issues The video is ment to provide a starting place for novices to undertsand the role played by… Read More »