Tag Archives: area

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 »

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 »

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 »

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 »

What I am reading: Nikola Tesla (Sean Patrick)

By | November 5, 2014

Just finished reading Nikola Tesla by Sean Patrick off of Google Play. The book tried to provide inspiration to the reader by covering the challenges Nikola faced during his career. It is not a biography but then it’s not a self-help book either. The book fails in both areas mainly because it’s not factually correct… Read More »

SSAS: – Date dimension

By | July 28, 2014

In previous posts we have successfully created a simple cube deployed and processed it. In this post we are now going to add one of the most important dimensions that need to be added to any cube. The date dimensions is a table that contains a list of dates that can be used within the… Read More »