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 …
Challenge your Database – Oracle (part. 2)
How-to check how many SQL queries can be runned during a defined time on your Oracle server? Let’s see
Challenge your Database – MS SQL (part. 1) | Challenge your Database – Oracle (part. 2)
Challenge your Database – MS SQL (part. 1)
How-to check how many SQL queries can be runned during a defined time on your MS SQL server? Let’s see
Challenge your Database – MS SQL (part. 1) | Challenge your Database – Oracle (part. 2)
SQL Server Databases Backup
Based on Olaf Helper‘s work (http://social.technet.microsoft.com/wiki/contents/articles/900.how-to-sql-server-databases-backup-with-powershell-en-us.aspx), here’s the script to back up all non-system databases for SQL Server, with error handling and logging function.
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
LogCentralizer
Today, I lacked inspiration; or rather I lacked needs to fill … So I found one: Sudhakaran B. asked for some help on the “PowerShell Power Users” LinkedIn discussion group:
we need to get the iis and event logs from production servers, then we need to zip those files to someother location on a daily basis
EventsToExcel
Here’s an example working on the automation of Excel worksheet filling. For this example, data comes from the eventlog, but obviously any …
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 …