Archive for October 2005
Since I can’t get my links to Amazon working in an MSN Spaces list, I thought I’d just put my book list in a regular entry and then update it as necessary.
Microsoft SQL Server 2005 Analysis Services: Irina Gorbach, Alexander Berger, Py Bateman, Edward Melomed
MDX Solutions (2nd Edition): George Spofford, Siva Harinath, Chris Webb, Francesco Civardi, Dylan Huang
Teo Lachev has announced that ‘Applied Microsoft Analysis Services 2005′ has gone to the printers and will be available by the end of November. More details and resources can be found here.
Mosha has announced that the second edition of ‘Fast Track to MDX’ is on the verge of publication. He has more details and some comments on other books on this list here.
Nick Barclay has a review of ‘Data Mining with SQL2005′ on his blog here. I’ve also just bought a copy and will be reviewing it as soon as I’ve read it properly! First impressions are good though.
If anyone wants to send me a free copy of their book for review (cheeky idea for getting free books, I know, but it might just work!) then please drop me a line at the email address mentioned in my profile.
Thanks to Nick Barclay again for the fact that ‘The Microsoft DataWarehouse Toolkit’ book (what’s listed above as ‘Data Warehousing with SQL 2005′ – I’ll update the link when Amazon UK updates its page for the book) has its own web page with some content.
Nick Barclay has a positive review of ‘Applied Analysis Services 2005′ on his blog here. Mark Hill also reviews it favourably here.
I have a review of ‘Data Mining with Analysis Services 2005′ here.
Nick Barclay has a review of ‘MDX Solutions’ second edition here.
Just spotted this post on the Analysis Services 2005 beta public newsgroup by Mosha (who I guess is a bit too busy with other work at the moment to put it in his blog), asking for feedback on MDX changes and performance. It’s good to see that the AS Dev team are as interested in engaging with customers as they always have been, but if I do have a criticism it’s that beta testers would be better able to test out new functionality if they actually knew what it was. I don’t want to sound too negative here but for instance I know that MDX Scripts have changed a lot over the last six months, and if the only information you had to work with was Richard Tkachuk’s white paper (which is now out of date in a few respects), Mosha’s blog and BOL you’d probably be struggling to understand what’s going on let alone implementing any apps which really push MDX Scripts to the limit.
I’ve been lucky in the amount of access I’ve had to Redmond to get my questions answered – Matt Carroll and Marin Bezic, take a bow - but I know from talking to other people that they’ve been frustrated at the lack of information available. I suppose the onus is on people like me, who do have the knowledge, to spread it around by blogging etc. Unfortunately I don’t have as much time as I’d like to blog or answer questions via email (I also have to work), and in any case I’m under obligation to my publishers and co-authors to save the really detailed explanations of new functionality for ‘MDX Solutions’. Similarly the dev team, although I know they make a really big effort, are obviously more focussed on building the product than writing about it. Maybe the SQL Server team needs to recruit some full-time bloggers to pump the information out to the community. Now that would be a cool job to have…
I see that Dundas have entered the market for ADOMD and ADOMD.Net client components with Dundas OLAP Services. It’s available in Windows Forms and ASP.Net flavours and although it doesn’t offer anything much in terms of functionality that isn’t already available, I’ll be taking a look because a) the web component looks prettier than most of the competition, which isn’t hard, and b) it’s from Dundas rather than a one-man-and-a-dog software company, so there’s less risk about future support.
UPDATE: you can see a live demo on Foodmart 2000 here. Having looked at it briefly, it’s as I thought – does nothing new, but those charts are nice to look at.