Archives

Come See Me Present at Consona Connect 2010 Next Week

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. [...]

Using User Defined Functions to Pre-Format Fields

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 [...]

PETE- People for the Ethical Treatment of Excel

“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 [...]