Why is Sharepoint busy when no one is using it?

Jun. 13, 2013 by

Sharepoint has hundreds of timer jobs running. Queries against the TimerJobHistory table will identify jobs that are active for long periods. You can then go into Central Administration and see

Grouping Sets, Rollup, and Cube

May. 1, 2013 by

As BI professionals we spend a lot of time making information visible through reports. One of the main technologies behind those reports is Structured Query Language (SQL). SQL is an

Merging git changes from master to branch

Jan. 14, 2013 by

There is no spoon. – from “The Matrix” (1999) I started using version control before git existed, so I bring some preconceptions with me when I use git.  It is

Speaking plainly about slowly changing dimensions

Nov. 22, 2012 by

As an expert in my field, I regularly use technical jargon because I need to be precise. There are circumstances when the difference between an indexed view and an un-indexed

The Cobbler’s Shoes

Sep. 26, 2012 by

“The Cobbler’s children have no shoes” is an English proverb that stays current because it describes a flaw inherent in all of us.  When we are our own client we