Whilst the core components of SQL 2008 R2 have been signing autographs on the red carpet, Master Data Services has sneaked quietly in through the back door. If you have MSDN access, download a full version (guessing developer and enterprise only but haven’t checked) and off you go. The install is a not part of the main installation either, you need to run it directly from the DVD\ISO in the MasterDataServices folder. Setup is very simple and there’s some good sample packages to play with.
StreamInsight is on there as well :)
First of all a quick correction following my post on day one where I had a bit of code name confusion. Project "Madison" is the evolution of the DatAllegro acquisition, Project "Gemini" is the self service BI and "Kilimanjaro" is the code name for the (interim?) release in the first half of 2010 that will include "Madison" and "Gemini"
So what of day two? The Ben Stein keynote was interesting, though not a patch on the Michael Treacy's from last year. This was followed by an extremely cheesy and completely staged "Q&A" session with the platinum sponsors about where BI will be in 2020. I didn't stay to hear the answers! I know they have to keep these sponsors happy but do MS really think people take any notice of this stuff?
I went for the MDM session next which was very heavy going and disappointing in that we still didn't get to see the product - though we may see it at next year's BI conference (same time next year)!
Got to meet Patrick Husting and a number of other PPS experts over lunch, and in the afternoon we got a chance to quiz some of the Gemini team on a few of the points mentioned yesterday. I raised the topic of "AS hell" where users are creating random cubes all over the place and they had a good response: People are always going to do self service reporting in some way whether we like it or not, no matter how good the underlying data is, so why not do it in a controlled manner where everything is audited and logged and the IT team has full visibility of what is going. There was a "Gemini" breakout session which showed the operations dashboard behind the scenes - very cool. "Gemini" really looks impressive and has obviously already had a lot of effort put in, I have a feeling the usual version 1 worries may not be surfacing too much here - people are going to be desperate to get their hands on it!
Last session of the day for me was the BI power hour which was very entertaining. A working Monopoly game in PPS with full analytics and Profit and Loss for each player, a girlfriend management Planning model (looking at how the seriousness of your relationship affects your future cashflow - ha ha) and two player battleships in Reporting Services - I want these guy's jobs! Also a chance too briefly see MDM in action - it looks pretty good! Why they couldn't show it in the MDM session I don't understand...
Finally the conference party which was held at the the impressive QWest stadium, home of the Seattle Seahawks, with casino games, lots of x-box and Football and American Football out on the pitch.
Here's Jereminho scoring an absolute peach - back of the net!
Microsoft's first Technology preview of their upcoming MDM product will be available from tomorrow. More details on how to participate can be found in Kirk Hasselden's blog
Rumours are it's all going to be based around SharePoint...
Everybody hates documentation but this is a really neat, free tool for modeling multi-dimensional databases and is particularly suited to MSAS 2005.
ADAPT™ (Application Design for Analytical Processing Technologies) from Symmetry Corporation is a Visio stencil.
Example of a time dimension is shown below:
There's a white paper that's worth a read to get you started
Microsoft have acquired the MDM company Stratature
So Kirk Hasselden's hints were as thinly veiled as they seemed after all! He was almost apologetic for not being able to tell us anymore at his session in Seattle and with hindsight it's clear why.
This is definitely an interesting move and if MS are planning to bundle this very capable product in with Katmai (enterprise edition perhaps?) then it will really push them to the top of the league for enterprise data solutions.