Here a real user story and solution. One of our customers would be able to selective restore SharePoint content. Because he has already a great SQL backup strategy he decided for a third party tool from from Metalogix, Selective Restore Manager, which gives him the ability to selective restore from SQL backups or databases. Not a very extra extraordinary scenario. But which backup should he use? Maybe a document or site has been deleted accidently some weeks or months ago. Searching in all backups for the missing item would be very cumbersome. How we can solve this in an agile manner? Sure, with our good old friend PowerShell! The approach is a scheduled PowerShell script querying the SharePoint audit logs for delete events in all site collection from a specific web app and write the log entries in a usual SharePoint list on another web app (central admin). Writing this script has taken less than an hour. Even lunch has taken longer ;) I really love the speed, power and flexibility you gain with PowerShell!
The list looks like this (click to enlarge):