Tag Archives: ability

Better Triage: Getting hospital care delivered properly

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

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 »

Why I will never hire anybody for Tata?

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 »

Which is better Delayed Durability or Optimistic Concurrency

A brand new video covering the performance impact of delayed Durability vs Optimistic Concurrency. Which is better? While both have different behavior and purpose; when it comes down to the basic task at hand both essentially improve write (and in the latter’s case read) performance, so the question was can they be used together, do… Read More »

Sometimes common sense takes a back seat to BI

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 »

Training DBA from other countries

Technology is a universal language so training DBAs from other countries is not really a challenge when covering technical aspects. But here are a few things to keep in mind. Time zones- lunch breaks are different for different people. Office hours – Availability of daylight usually impacts office hours and typically there is a difference… Read More »

Single Partition online rebuild in SQL 2014

If you have a large database then you probably have table partitioning implemented. While I have already blogged a lot about partitioning one feature that is really useful in SQL 2014 is the ability to rebuild an individual partition online. Previously for VLDB that contain partitions you either had to rebuild the index on the… Read More »