For this month’s Syntax Saturday, I do not have much time, but wanted to share two very useful XQuery extension functions introduced in SQL Server 2005′s enhancements in XML-support arena: sql:column() and sql:variable(). These functions can be used to spice up one’s XPath a bit. Consider shredding XML based on a variable or column value.   Here [...]

It is one thing for the needs of humanity to empower technologists to maintain what and how technology lives, but it is another for technology to empower technologists to sustain the needs of humanity. With respect to the latter, Experts Exchange’s knowledge-sharing technology has done just that. For a community of enthusiasts in database and [...]