Tag Archives: member

SQL Server is an awesome product.

By | September 16, 2015

While I might seem biased in my choice of wording for the title, the fact is SQL Server is an awesome product. If you looking for actual numbers click here. MS SQL Server is the top OLTP and among the top DW RDBMS. More importantly you see that SQL server provide everything you need to… 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 »

You might be a DBA if…

By | July 6, 2015

Was watching stand up on YouTube and remembered the “You might be a redneck if …” by Jeff Foxworthy here is my list for DBAs. You might be a DBA if ….. You wake up in the middle of the night screaming virtual IP addresses You might be a DBA if ….. You can’t remember… 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 »

Auto Update Statistics when does it occur

By | June 17, 2015

I was recently asked when does the actual Auto Update Stats trigger and while I know its during query compile I wasn’t exactly sure what the thresholds were so I did some RnD, the results are anyway well documented in the link in the references but I have still posted the results here because I… 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 »

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 »

Part 2 Buffer pool extension SQL 2014

By | January 16, 2015

In this second part (read the first part here) of the series we continue testing the limits of our RAM and try to understand SQLs behaviour when it encounters memory pressure. To this end we have created a table that is little more than 2 GB in size and have set out SQL server buffer… Read More »