YAWPU
YAW what!? No, I’m not trying to learn some Iroquoian language. That’s just the acronym of the useless script I just wrote …
Test Your SQL Server Backups with PowerShell
The best way of checking SQL Server backups is to restore them and run DBCC CHECKDB on the restored database. To do this regularly means that you need to automate the task. Allen White
That’s right. But it’s also a great example on how to work with MS SQL databases (connect, backup, restore, remote, SQLPS Module and more!)
Test Your SQL Server Backups with PowerShell | SQL Server Databases Backup | Challenge your Database – MS SQL (part. 1)
MonitorWP
Here’s an example of how monitor CPU usage for a specific worker process and send an alert if a defined threshold is exceeded.
MonitorWP | Worker Process CPU usage
Windows Server 2003 Inventory & BPA (Webserver)
Here’s an example of HTML configuration report generation with PowerShell. The script scans a fews WMI classes to build the report, and act like a Best Practices Analyzer.
Windows Server 2003 Inventory | Webserver Best Practices Analyzer
Get-Uptime
Here’s a simple function to get a “readable” value of the uptime for the local computer (by default, but there’s a ‘Server’ parameter), and the last boot date/time.
Get-UptimeDays | Get-Uptime
Monitor Services (Active!)
Here’s a one-liner solution script to actively monitor services. The script gets all services with a startup mode ‘Automatic’ and if some are stopped, starts them.
Monitor your services | Restart automatically stopped services
Get-PerfGraphs
Perfmon is a powerfull tool, for sysadmins… But to provide nice (and especially readable for them!) graphs for your managers, here’s a …