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)

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)

How to see the Hardware Inventory classes and properties via T-SQL

Recently I was asked "Are you aware (do you have an example) of a way to extract data from the ConfigMgr database for hardware inventory rules and classes?" (That was in a comment of a blog I posted on my team's blog: https://blogs.technet.microsoft.com/system_center_in_action/2012/05/19/auditing-software-inventory-rules-in-system-center-2012-configuration-manager/. This post is in response to that comment. [edit: April 2019] That … Continue reading How to see the Hardware Inventory classes and properties via T-SQL

Creating Registered Servers in SSMS via PowerShell

I wrote a script that creates a "Registered Server" group and then a "Server Registration" for each of the servers found in a text or csv file. This comes in handy when you want to create lots of registrations (groups and/or servers). Basically, to use the script, you create a file (txt or csv) for … Continue reading Creating Registered Servers in SSMS via PowerShell