Tag Archives: city

Combining Results from multiple datasets in SSRS – performance comparison

By | September 7, 2015

Recently at a training I was asked how to combine the results from two different datasets, while I have used this function before I couldn’t recollect how much of a performance difference it made to look up within SSRS vs performing the join directly with the dataset query. In this blog I try to find… 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 »

SQL 2016 – Updatable Columnstore Index finally OLTP and DW workloads delivered

By | July 13, 2015

So SQL 2016 comes with updatable non clustered columnstore index. Are you wondering why this is a big deal. It is and here’s why In SQL 2012 the Non clustered Columnstore index was introduced but was severely handicapped by the fact that once implemented the table was read only. In SQL 2014 the Clustered Columnstore… Read More »

Sometimes common sense takes a back seat to BI

By | March 9, 2015

This post has to do with how we sometimes loose the tree for the forest (no this is not a mistake), I had written a blog post sometime back about game theory and how it can help decide the outcome of certain business cases. I came across two instances in the last week where game… Read More »

Done with trainings for 2014!!!! Huge surprise waiting just around the corner

By | December 30, 2014

It’s been a whirl wind year!!! With trainings in almost every major city in India and having trained over 600 database professionals. This year we have added over 10 new clients as well as my revisited almost all our existing clients. Training is not just a job; those who have attended our trainings know that.… Read More »

Bangalore – Bengaluru Slowly Changing Dimensions

By | November 1, 2014

I would like to introduce Type 6 EBS Modified SCD and get your feedback. I couldn’t find any documentation explaining this approach so I guess this is a first, please prove me wrong. So it’s finally happened Bangalore is now officially Bengaluru. Naturally this means a lot of the changes on the road and Highways… Read More »

When it’s an Emergency, what do you do ?

By | September 1, 2014

I recently needed to send a courier on a very urgent basis to a friend of mine and was stuck on how to do it. Time was critical and it was a Saturday evening. I went to a number of courier services such as DTDC and BLUE DART but was informed that the pickups for… Read More »