Tag Archives: place

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 – Starter kit for the uninitiated – Execute process task and PowerShell

By | August 4, 2015

In this fourth part of the series (see previous post here) we proceed to modify the XMl files downloaded from the web service. While this step is not mandatory in most cases where the XML is well formed, in this particular example we see an issue with the file. Namely < And > text is… Read More »

Why I don’t have a lot of personal info on the internet- OLAP – BIGDATA and the future of privacy

By | July 19, 2015

I was asked this question while having a chat with a few friends. Mainly the complaint was I don’t have a lot of social media presence. The only real social media I follow is LinkedIn and that’s because it is mostly a Professional network. But more importantly, the reason why I don’t have a massive… 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 »

OStress.exe – use it if you aren’t already

By | July 5, 2015

I was recently trying to simulate the performance implications of hashing vs encryption and wanted to simulate hundreds of sessions and 1000’s of requested on a username/password table. Most time developers and testers use a test harness for automating this kind of activity or use a load testing tool. I however am not a tester… Read More »

NULL Management, SPARSE Columns, Vertical partitioning and a query

By | June 23, 2015

When discussing DW design I often take a lot of time to emphasize the impact Nulls have on query performance, aggregations, design, storage and much more. While this is not new to most seasoned DW developers it is often overlooked during the design phase and added at a later point in time mostly after testing… Read More »

Why I will never hire anybody for Tata?

By | April 7, 2015

Reaching a certain level of incompetence takes just as much commitment as being good at it. It’s like telling someone “you can’t mess this up even if you tried” and then being proven wrong. Case in point is the recent TataSky upgrade that happened all over India. By the CEOs admission Tata Sky has over… Read More »