Tag Archives: question

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 »

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 »

SSIS – Starter kit for the uninitiated – Data enrichment

By | August 10, 2015

In this last post (after which there will be a video explaining how to bring all this together in Power view) I cover how to convert geo coordinates from 38° 53′ 55.133″ N to Decimal Coordinate system 38.898648. You can find the previous posts here. The calculations is fairly simple the sql for it 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 »

Fill Factor and Page split demonstrated

By | July 13, 2015

Recently on one of the popular SQL Forums I read a post by a DBA who seemed experienced but still had a poor understanding of fill factor and why it is important for SQL server. I’ve been asked this questions a number of times during trainings so here is a video hoping to show some… 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 »