SQL Tip: The “query()” and “value()” methods (XML)

[edit: March 2019] This was originally posted to my internal (to Microsoft) blog on July 27, 2013 as part of a series I called 'SQL Tips' for coworkers and anyone else who was interested. You'll see that at the time I was relatively new to XQuery. Rather than update or fix this tip now that …

SQL Tip: The nodes() method (XML)

[edit: June 2019] This was originally posted to my internal (to Microsoft) blog on June 10, 2013 as part of a series I called 'SQL Tips' for coworkers and an email distribution list people could sign up to. I have left this as originally written but have updated formatting for my WordPress theme. Note: I …

The InventoryLog Report

A year ago I blogged on the "InventoryLog" table and how it can be used to help troubleshoot hardware inventory issues. I also got a comment asking about how I wrote the query/report I showed in that post. I was reminded today about that comment and figured I should post something...a year later is better …

SQL Tip: XML in SQL

[edit: April 2019] This was originally posted to my internal (to Microsoft) blog on May 29, 2013 as part of a series I called 'SQL Tips' for coworkers based on an email distribution list I sent out before the internal blog. I have left this as originally written but have updated formatting for my WordPress …

SQL Tip: APPLY

[edit: April 2019] This was originally posted to my internal (to Microsoft) blog on May 14, 2013 as part of a series I called 'SQL Tips' for coworkers and an email distribution list people could sign up to. I have left this as originally written but have updated formatting for the my WordPress theme (and …