MDX for SQL Developers
This Video series is focussed on the building of MDX language skills in the SQL Developers by using the familiar SQL concepts as a background to start with and move gradually towards the advanced topics.
Focus of this series is on the MDX language, NOT OLAP modeling and designing, though good knowledge of MDX would be helpful in OLAP modeling and designing as well.
All along the series, you will get to see lot of SQL and equivalent MDX queries.
Using T-SQL to Transform XML Data to a Relational Format
In this article it was demonstrated how we can use inbuilt features of SQL Server query engine to manipulate the XML data.
One of the important differences between XML and relational storage is the way data relationships are maintained.
When data is stored as XML, entity relationships are implicitly preserved by the very nature of XML structure, which is hierarchical format.
On the contrary, when data is stored in relational format, entity relationships are explicitly maintained by foreign key relationships.
Since SQL 2005 lot of XML features have been added to the core engine that allows us to manipulate XML data without the need of adding
application layer for such transformations. Appropriate XML indexes can be created to boost the performance of such
transformations from the XML to the relational format.