Tag Archives: addition

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 »

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 – 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 »

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 »

The tempdb – why shrinking doesn’t always work

By | July 6, 2015

Recently I was working on performance issues for a client and one of the topics we were looking at was tempdb. There was some confusion about when tempdb is a problem so I figured I would write this quick post explaining the auto growth and shrink behavior of tempdb. Here is what I started with.… Read More »

There is a very important discussion happening!!! Are you part of it?? Net neutrality

By | April 8, 2015

This is probably one of the most important stuff you can do in your life time.Net Neutrality is the idea that the internet should not be restricted by the ISPs. Currently ISPs in India are claiming loss of revenue due to apps like skype and Whatsapp taking over the SMS and Call space that was… Read More »