There are very many, and from my own professional perspective, too many (I’ve got to try and learn all this stuff) new features in SQL 2005. Some of them can be described as ‘catch up’ features and some of them might be described as ‘tick in the box’ features. There is one that is wholly revolutionary and which shouldn’t be described as a feature and that is the Unified Dimensional Model (UDM).
I have read and re-read articles that talk about the UDM, some internal, some public, and I’m still trying to get my head all the way round it. It is beautiful, to be sure, but it is a major shift in paradigm. This means you have to chuck out some of the old mind set before you can let the new stuff gel; all of which just adds to the overall learning effort.
To help you on this journey I’m going to point you towards some articles I’ve read and some I haven’t. Firstly however, I’m going to give you some facts you should keep in mind while you travel on this voyage of discovery, facts that should help break the old mind set and lubricate the transition to this new enlightenment. Then I’ll outline some of the key benefits of the UDM to wet your appetite and to keep you motivated through the morphing process.
The big fact: The “UDM- Server” is Microsoft SQL Server Analysis Services.
So what are the benefits over AS 2000?
There’s more – but I can’t keep my eyes open, its late, I’ve had too many sherbets and wine gums …. I’m off to bed
UDM does look like a BI paradigm shift - it'll be interesting to watch its adoption. Mosha's blog refers to a presentation on MDX changes:
BTW, what is the level of SQL compatibility for UDM (it was quite limited in AS 2K)?
Sorry for the delay - I've been snowboarding in France; haven't worked out to do an 'Out Of Blog' message yet.
I'll get an answer to you as soon as I can
Deepak - check out my post http://blogs.msdn.com/mat_stephen/archive/2005/03/21/400006.aspx