XML-XSL Transformations in SQL Server

With the release of Master Data Services (MDS) for SQL Server 2008R2, it is now possible to perform XML transformations on the database server. Even though, it may sound as a bad idea to perform such operations on the database level instead of clientside, one can certainly find useful cases for this functionality.

A database configured with MDS, simply contains some CLR assemblies and UDF functions that make use of these assemblies.

Read the rest of this entry »