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 … Continue reading SQL Tip: The “query()” and “value()” methods (XML)

Advertisements

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 … Continue reading SQL Tip: The nodes() method (XML)

Finding the application of a given SCCM deployment via T-SQL

Recently a coworker was troubleshooting some application installation issues on a device. Looking through the "AppEnforce" log he found the deployment name and Id. As an example, here's what it would look like if you were troubleshooting the same log (I highlighted the deployment name yellow, and the deployment id green for reference): Although he … Continue reading Finding the application of a given SCCM deployment via T-SQL