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
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
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
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
T-SQL Tuesday #49 – What are you WAITFOR?
It’s TSQL Tuesday again !! Props to host SQLSoldier for the topic, WAITS. We have been trying to grow the DBA team – so the past few months have been busy on the … Continue reading
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
Russ Thomas - SQL Judo 