Some helpful tools coming out of SQL MDS, including regex and XSLT straight from T-SQL.
I've been having a play with SQL 2008 R2 and its new Master Data Services (MDS). I was pleased to see it adds some additional functions when you create a new MDS database. These include mdq.Split and mdq.RegexReplace which implement handy Regular Expression functions. Most of these are documented at: http://msdn.microsoft.com/en-us/library/ee633712(SQL.105).aspx
I also discovered a scalar function called mdq.XmlTransform which allows you to use XSLT: