In Scott Larsons blogpost referenced in my last post he gives a short but important note: his favourite MDX resource. And I agree: a 62 article series in learning MDX. Since I’ve worked with SQL “all my life” I’ve not bothered to much with MDX, but with this series I’m really looking forward to learning it better. To do the tutorials you’ll need the free MS-SQL 2000 samples (that unfortunately aren’t bundled with neither MS-SQL 2005 nor MS-SQL 2008). You can download them from here. I should note that while it compiles fine with VB6, using it with Visual Studio 2005 left me with a pretty large debugging job. But don’t worry, the data sources are included and that really is all you need to work through the tutorials. For the interface, you’ve got BIDS

Categories: Technology