Tagging Tags

I'm a big fan of tagging (folksonomy, as the kids call it), and I've written previously about the need to this be adopted to file systems as quickly as possible. One problem with tagging that comes up is when the existence of one tag implies that others should be applies. For example, "Mac" implies "Apple". This is a formal hierarchy, of course, and that effectively means putting tags in directories: exactly the scenario we want to avoid!

Luckily, the way out of this is simple. Tagging of tags! This follows from our first principle: folders are so 1990's and hierarchies are unnecessarily restrictive. Of course, we wouldn't make a distinction between types of tags; a tag could be applied to another tag or another "entity". So for a post about "Melbourne Business School", I usually use the "melbourne business school" tag. The "melbourne business school" tag should itself be tagged with "university" and "business" and perhaps "study" or "work". Similarly, sometime I write about ColdFusion. ColdFusion should be tagged with "technology", "Adobe" and "software". Potentially, "software" could likewise be tagged with "technology" but that's just fine.

So far, I have only seen this concept applied in one place: Taglocity, an Outlook plug-in, although it is framed slightly differently. I'd like to see more it, especially for blogs.

Dynamics CRM 4: Discovering the SQL behind an "Advanced Find"

Have you ever wanted to know exactly what SQL was generated by the advanced find? This question might just be because of shear curiosity, but the results of this query by also be the starting point for most sophisticated reports using SQL Server Reporting Services.

The process is straightforward. All you need is Dynamics CRM 4 and Excel 2007 (2003 should work similarly). [See update below for doing this without Excel]

Perform an advanced find
Run the query, and export the results to Excel. Make sure you select "Dynamic Worksheet" although I'm pretty sure "Dynamic Pivot Table" will work
In Excel, once you have data displayed (which might mean enabling data connections), go to the Data tab, and click "Connections"
You should have a single connection called "Connection". Look the properties for this connection.
Go to the definition tab. The command text contains the SQL behind the advanced find.

This approach works with SharePoint lists as well. Using this technique with SharePoint list data helps you quickly determine the GUID of the list and the view you are using.

Update: Dynamics exports the data as an XML file, not a binary XSL file. Therefore, you can simply open the downloaded "Excel" file with a standard text editor and view the SQL within. 

Bring it All Together

A couple of weeks ago, I had a go at Joel Spolsky for effectively blaming bad corporate policies on MBA graduates. As a Melbourne Business School student myself, this struck a nerve.

Well it looks like he sorta acknowledges that he often makes claims without any good basis, but that it does make for entertaining reading. I wholeheartedly agree!

Of course, he does that just after he trashes another of my favourite minds, Thomas Friedman. Still, I have to grudgingly accept that he is probably right.

78 Means "You're a just a very tiny bit better than average"

It's official: I'm slightly better than average. But I'm not getting cocky; the difference is not statistically significant. So actually, yeah, I'm probably average. And that's OK.

I have now received my grades for both of my syndicate assignments, which are:

• Marketing: 78
• Accounting 78

You might wonder what mark I received last term. I'm not shy. I'll tell you:

• Managing People for High Performance (MPFHP): 78 (update: my MPFHP mark was actually a 76)

This, of course, is no freakish coincidence. Melbourne Business School grades on a curve, and I'm pretty sure the mean of that curve is 77.

Update: I've been told the mean is actually more like 75, but the gist is the same.

I'll tell you why I love the curve:The curve opens upwondrouspossibilities or learning. You see, when I know that class average must be 77, I don't hesitate to take "hard" classes that I could otherwise avoid. For example, I'm not a fan of accounting, but might try my luck at a whole class on financial statement analysis. Why not? I'm not scared of a 75. And I won't favour an "easy" class like "Leadership" just to boost my GPA. A 79 won't make a difference.

Let me contrast this with McGillwhere I did my undergraduate degree. In McGill, my major -- Computer Science -- was "hard". I can tell it's hard for a number of reasons, but an easy way to tell is that the average mark hovered around a 65, which I think was C or C+. On my transcript, it was not unusual to see a C-, and even once, a D. Without context, this isn't too good. Don't worry, though, I was able to boost slightly my GPA by taking some "easy" classes. Among them:

• Sexual Ethics
• International Organization
• Understanding Planet Earth
• Space Time and Matter

Unfortunately, I was considerably more restricted in the classes I could take than a average McGill student so my GPA stayed low in absolute terms, although probably slightly higher than average for a computer science student. Still, this low GPA had real implications in finding my first job; a legacy which still haunts me in many respects to this day.

So embrace the curve. Ride it. And enjoy your 78.

Crashing Outlook Saga

My love affair with Microsoft continues. For the past few months, Outlook 2007 crashes constantly, severely limiting my productivity. Last week, I asked someone from our help desk to look at the problem again. They did the usual:

• uninstall/reinstall
• clean my registry

but without any success.

Today, it appears that one of Microsoft's background services detected that there was a problem with outlook (500 crashes later), and decided to try to determine, once and for all, how I could fix my Outlook. (I should note by the way, that while the diagnostic scan was running, Outlook crashed 3 more times).

Here is what the scan discovered:

 

Clicking "continue" took me to a worthless web page which I will now summarize: we don't know what the problem is and we don't have any solutions.

Can they possibly waste any more of my time?

Great Gift. Thanks.

I got a "Friend of a Squid" bookmark plus "On the Beach", a classic Australian book.

Thanks.

Marketing Syndicate Assignment Wrap Up

Last night was the climax of my syndicate work for this term at Melbourne Business School. My colleague has already blogged about our presentation, and I have to agree with him that overall, we had a very engaging presentation and a very successful syndicate. However, we did face numerous challenges, probably faced by other syndicates as well:

• we had trouble coming to a consensus about the topic. I really pushed for alternative fuel vehicle, while others pushed for mobile devices and music distribution.
• I had some trouble working effectively with a particular member of the team and while there was no major conflict, I don't think there was a good synergy between us

On the other hand, everyone contributed their own strengths to the team such as:

• taking ownership of the final paper, creating a unified document out of what was effectively 5 different "mini papers"
• organising samples of wine in a can as well bottles of wine featured in our paper
• handling the logistics of distributing the wine (which included a thoughtful consideration that we should present immediately after the dinner break)
• offering high quality, constructive feedback on the presentation run-through. This helped Shoaib and I improve our presentation style and content tremendously.
• pooling some money to purchase professional images for the slides

For those that might be interested, you can download a copy of our slides. I'd be interested in getting feedback on that, or if you were in class, your impressions of the presentation.

A New Era

I just finished watching Obama's acceptance speech. I spent much of the day examining in detail the electoral map. Today's the day the I reconnected with CNN.com. Do you know the last day I spent clinging to CNN and other news sites?

September 11th.

With that thought, I realised that we have well and truly passed from one era to another. The previous one, the one when I came of age, was a cynical time. I was apathetic. It wasn't long ago that I was struggling to find excitement in my life. I think it was typical of my generation and our supposed apathy. Little did I know the effect our leaders can have on our individual self-esteem.

It was today that I learned as much about myself as I did about America. I had cast America aside. I lost faith in its ideals and in its people. In the same way, I think I lost faith in myself. I didn't believe in the value of hard work, or the many benefits a true and equal society can bring to humanity. It seemed like those who manipulated the truth were destined to get ahead.

Tonight, I really believe I'm a changed man and that America is a profoundly changed nation. I'm so proud of the message that our electorate send. That finally, we will punish those in government that will betray our trust. That today truly marks the end of our civil war. The end of a nation of used car salesmen. The end of the attacks on 9/11. Demonstration that we can be a progressive, inspirational society. We can demonstrate moral leadership. We can be a light unto the other nations. We can innovate. We can better the lives of everyone.

For the first time in a very long time, I'm proud to be an American.