BrustBlog

Tech Industry Pontifications, NYC Quips, and the Occasional Political Outburst


News

My Stats

  • Posts - 114
  • Comments - 24
  • Trackbacks - 0

Twitter












Recent Comments


Recent Posts


Archives


June 2008 Entries

Analysis Services 2008 Wizards: Is the Magic Gone?


I’m updating chapters in my book on SQL Server 2005 for the impending release of SQL Server 2008. Right now, I’m focusing on the chapters that cover Analysis Services (AS), the BI component of SQL Server.  I’ve come across an “improvement” in the new version of AS, and I’m not sure I like it: the wizards do less.

In AS 2005, the Cube Wizard could create a time dimension for you, and the Dimension Wizard could create a parent-child dimension/hierarchy for you. 

Cube Wizard AS2005 Time Periods Cube Wizard Dimension Design AS2005 Parent-Child Dimension AS2005

In AS 2008, only the Dimension wizard will create a time dimension, but won’t do so very easily when you supply your own dimension table for it.  And, as best as I can tell, under AS 2008, there is no wizard interface at all for creating parent-child dimensions.  Even for regular dimensions, the Cube Wizard creates only a key attribute for each generated dimension.  If you want multiple attributes, you’ll need to add them manually or use the Dimension Wizard.  The cube wizard actually gives you no insight into attributes at all:

Cube Wizard AS2008 Cube Wizard AS2008 Finish page

This is most perplexing.  So let’s play devil’s advocate.  The AS 2005 wizards had a feature called Auto build (it was called IntelliCube when AS2005 was still in Beta).  It didn’t work that well, and I usually disabled it. 

Auto Build

I can understand that giving rise to a point of view that the AS 2005 Wizards were over-engineered.  Fine.  I can therefore see streamlining the wizards.  A little bit.

But why take away all that good, helpful functionality?  Has thin-client computing led to thin Wizard computing?  Frankly, I think this is absurd.  Under the guise of having the wizards build leaner cubes (and dimensions) in fewer steps, we end up with a product that simply does less.  It doesn’t affect me personally. I know how to use the Analysis Services designers and the Properties window to do on my own what the Wizards would do for me.  But beginners don’t know how to do that.  And aren’t Wizards for beginners?

posted @ Sunday, June 22, 2008 11:40 PM | Feedback (0) |


You Always Have Other Options?


With yesterday’s announcement that Yahoo and Microsoft have broken off all discussion of a merger (partial or otherwise) and that Yahoo has closed an agreement with Google to carry the latter’s paid search ads on the former’s search engine, it certainly seems like MicroHoo has bitten the dust.  Perhaps both companies have decided that the expansion of Yahoo’s fabled acronym (referenced in the title of this post) is the best philosophy.  I still believe there’s a lot of posturing going on, and I still believe a deal is necessary.  I also think a deal is possible, but I don’t think it’s guaranteed.

I once owned my own firm and I remember how strongly I felt that I would never sell it.  My own pride was wrapped up in the company and its success, and I took any subjugation of the company’s identity to equate to that of my own.  I suppose Jerry Yang may feel likewise about Yahoo.  But, with all due respect (whatever that means), that kind of internalized, emotional approach to business is more appropriate to running a candy store than to being the CEO of a top-tier Internet company.  I sold my firm in 2004 so that I, and my employees, could move on to bigger projects and new technologies.  I suppose the analogy's a weak one, but why won’t Jerry Yang do the same for his team?

Jerry may get over himself or Carl Icahn may succeed in ousting him and force Yahoo to pursue a Microsoft merger deal with vigor (instead of with passive aggression).  But the fact that so much time has elapsed since the beginning of this round of deal-making truly complicates things.  Whatever Microsoft may have felt was a fair price for Yahoo several weeks ago, the reality is that the passage of time and events have changed Yahoo’s intrinsic value and its value to Microsoft specifically.  Consider:

  • The Yahoo brand is now tarnished.  And a shareholder rebellion led by Icahn will tarnish it further.  This would ostensibly have impact on the reach of Yahoo’s network of sites and the enthusiasm and satisfaction of its customers while surfing it, which could impact click-through rates.
  • Microsoft has already lost valuable time and momentum pursuing this deal.  With each passing day, the potential boost to its Internet advertising prowess that a Yahoo acquisition could provide diminishes, and the lost potential revenue piles up.
  • The caché for Microsoft on the Web that would have come from a swiftly and amicably executed deal with Yahoo is now beyond reach.

All of the above are Yahoo’s losses, first and foremost, but they hurt Microsoft too.  There’s no other deal that Microsoft can do that will bring them the audience share, and the demographic diversity of it, that Yahoo can offer.  And whether you believe that Microsoft should go into the Web advertising business or not, it’s important to realize that Microsoft is absolutely convinced that it must do so.  Under these circumstances, it becomes important that it do so as shrewdly as possible. 

At this point, doing a deal depends on (a) Carl Icahn’s maneuvers, and their success, (b) Microsoft’s willingness to accept acquiring a distressed property, rather than a trophy prize and, quite possibly, (c) Yahoo willing to accept a significantly lower price than the one it has already turned down.  That’s a lot of intrigue and compromise, and it’s far from certain that either company knows how to endure each or both, let alone do so quickly.  There’s a good business school case study in here somewhere.  It remains to be seen if it will be a study of success or failure.

posted @ Friday, June 13, 2008 9:44 PM | Feedback (0) |


An Unexpected Lunch


On Tuesday morning (June 3rd), at Microsoft’s Tech*Ed Developer conference, Bill Gates made his last scheduled public presentation as a full-time Microsoft employee.  About 90 minutes later, 15 tech “influencers,” myself included, gathered around a square table in a small room at the north end of the convention center, and were joined by Mr. Gates for lunch.

We were invited to this luncheon just a few weeks ago, and very unexpectedly.  A couple of weeks later, we were told that we’d each have the chance to ask “BillG” (as he is known on Microsoft’s email system) a question.  So I prepared one or two clever questions in advance.  I had planned to ask Mr. Gates about the future of the BASIC programming language…given its historical importance to Microsoft’s business, and considering its apparent demise of late, at least in the world of .NET development.  I also had a non-technical question prepared: whether Gates has ever considered running for public office.  I expected the latter question would be ill-suited for a luncheon at which 15 top evangelizing geeks were in attendance, but I was hoping the conversation might swing that way.

To my surprise (and, from what I can tell, the surprise of everyone there), the questions asked of Bill at lunch were almost entirely focused on education, policy and issues concerning the world’s poor.  The questions from our group were all quite astute, and I, for one, enjoyed very much being able to talk about matters beyond the keyboard.  Throwing out my prepared questions, I instead asked Gates of his views on the United Nations.  Gates answered, and I am paraphrasing, that the United Nations is important, necessary and broken.  In other words, if I may infer, it needs reform, and it necessarily suffers from bureaucratic inefficiencies, but it’s an irreplaceable institution, and that trashing it (or de-funding it) is naive and ill-advised.  That’s a pretty nuanced answer compared to the more polarized positions expressed by many politicians.  It bucked a trend.  There was more of that to come.

From others’ questions, I learned that Bill Gates is extremely focused on issues of secondary and higher education.  He is quite critical of teachers unions, as he believes they institutionalize a system where under-performing teachers become ensconced in the educational system; in effect, he believes the union discourages any notion of competition or real meritocracy.  Perhaps that sounds reactionary…but I have to tell you that in the context of his discussion, even to my own liberal sensibilities, it seemed, unexpectedly, quite reasonable.  Gates also feels that school systems controlled by mayors (including in my own home town of New York City) are more more investment-worthy than are schools controlled by school boards (which Gates feels lead to contract negotiations between teachers and teachers).  What is really hard to convey here is that Gates states these things more as empirical observations than partisan positions.  And as he does so, he eliminates the component of controversy that you might expect (and I would have expected) in such proclamations.

And the surprises didn’t end there.  I learned that Gates feels Junior/Community Colleges and Associates Degree programs are essential to helping develop the labor pool (including skilled labor) in this country.  I also learned, courtesy of a question from Stephen Forte, that Gates is somewhat critical of micro-financing and bullish on “micro savings.”  He feels micro-financed loans often have unreasonably high interest rates and can therefore be ineffective.  Meanwhile, the lack of access by the world’s poor to simple retail banking services requires them to do things like invest their money in livestock (often resulting in losses of up to 30% when they need to liquidate the investment) or in jewelry (which has inefficiencies of its own), or to posses the cash and suffer inflationary depreciation, and risk of theft. This can lead to problems more grave than those solved by micro-finance loans.  And between the use of small retail locations for deposits, ATMs and cell phones (for checking balances, and so forth), even remote, poor areas could have access to banking services.

There’s one thing about a person having financial and political independence: he can avoid politically correct rhetoric with impunity.  For Bill Gates, one example of this was his reference to poor countries, not as the “third world” or the “developing world” but as the “poor world.”  Trust me here: this phrase was not one he used in condescension.  Rather, I think Gates likes to use directly descriptive names for things, because it saves time, and gets right to the point.  It is also, I found, more respectful of the problems faced by the poor, and more respectful of the need to help them.  And to Gates, at least as I read him, helping more people emerge from poverty isn’t just about charity, ethics, or responsibility.  It’s about an opportunity, not just for them, but for the people who will employ them.  Lifting people out of indigence can actually mean economic benefit for the rich.  That was inspiring, because it made the problem of poverty seem approachable to me. Another unexpected outcome of the conversation.

Gates’ keynote at Tech*Ed was, unfortunately, anti-climactic: there was little new announced and the presentations lacked punch and enthusiasm.  Lunch, on the other hand, was inspired.  And inspiring.  It’s pretty clear then where Gates’ real passion now lies.  And with him (and his foundation’s money), focused full-time on a pragmatic, mostly a-political approach to solving some of the world’s worst problems, I am hopeful that he can be an agent for real and lasting improvements.  For Gates (to borrow a phrase attributed usually to the Mormons), solving world problems is not just about doing good, but also about doing well.  Each of these motivations is quite powerful; together they could be transformational, if not unexpected.

 

posted @ Friday, June 06, 2008 3:50 PM | Feedback (0) |