Bob's blog - SQL 2008 R2 MDS Easter Egg - wBob

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:

Bob's blog - SQL 2008 R2 MDS Easter Egg - wBob