In recent articles, I’ve apologized because my blogging has become sporadic and mentioned that there were reasons for it which would be revealed soon. Well, one of them is that Consona (Made2Manage) has foolishly graciously asked me to present at their national conference in Vegas next week and I’m all kinds of geeked about it. [...]
Some DBAs would cringe at what I’m about to tell you, but I often use T-SQL to format my data prior to presenting it in a report. Many experts feel that data formatting should always be done in the presentation layer. There are a couple of reasons why I do this.
I re-use as much code [...]
“If you only have a hammer, you tend to see every problem as a nail.” – Abraham Maslow
Before you start posting your negative comments, let me just say that I think Excel is a wonderful tool for business intelligence. Excel’s position for data analysis will only continue to grow in future [...]