Russ Thomas – SQL Judo

The Art of SQL Server Database Administration, Development, and Career Skills for the Technically Minded

XQuery for the SQL Server DBA

A few weeks ago I embarked on a series to present the basics of XQuery and XPath for the SQL Server database administrator.  This is the final post and will also serve … Continue reading

December 31, 2013 · 2 Comments

XQuery for the SQL Server DBA: Iteration and FLWOR

Let’s face it.  XQuery is at odds with almost everything a relational database holds dear.  Working with both at the same time can make the DBAs mind a blur of mixed messages.  Often, it just feels … Continue reading

December 26, 2013 · Leave a comment

XQuery for the SQL Server DBA: Math & Strings

Up until now we’ve covered path statements and namespaces to retrieve values from XML within SQL Server.  It’s pretty common once you start pulling values from any data source that you’ll need … Continue reading

December 16, 2013 · Leave a comment

XQuery for the SQL Server DBA: Namespaces

Do you hate XQuery? You’re not alone… heck, I’m writing this blog post and I’m not that big a fan of it. Dr David DeWitt has said a couple times … Continue reading

December 13, 2013 · Leave a comment

XQuery for the SQL Server DBA: XPath

“I don’t always query XML, but when I do; I drink dos equis” – Dan Sorensen. This is the first tutorial in a complete series on XPath/XQuery.  The master post for … Continue reading

December 2, 2013 · 3 Comments