Dynamic Management Views
I’ve used DMVs in PowerShell and SQL Server demos a few times but hadn’t really dug into them. There isn’t a lot of information available on DMVs but that will change early next year when SQL Server DMVs in Action is published - http://www.manning.com/stirk/
I’ve recently read the early access version and it is well worth investing in a copy if you are responsible for administering SQL Server.
The book doesn’t say so but it is very easy to run the scripts in the book from PowerShell