Self-Destruct
Sometimes we need want to play secret agents, sometimes we just want to remove our trail. Remote execution is one thing and …
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 …
Convert value in CSV file
Someone asked me recently how to convert a field value in a CSV file before to process the file with Log Parser. …
Enhanced profile – Display my custom functions
Somehow, I can be compared to a goldfish : my memory is really, really poor… And I do eat fish! But no, I can’t help…
Sometimes I wrote a usefull function that I embed in my profile and some weeks after (ok, even the very next day) I forget about it… So, here’s my solution: list these functions in a MOTD way. Each time I open a PowerShell console, the list is displayed and my memory gets refreshed.
Check-PasswordExpiration
Because ‘Password never expires’ is a really bad option for an administrator…
For those who use their Active Directory account (the administrative one…) to connect to remote server roles through an MMC, this script can be very useful. Indeed, it allows you to be notified by email one week before the expiration of the password (by default, configurable).
Because if you do not connect directly to any server, you will never have the information about the expiration of your password, only a message stating that your account is restricted, but whitout telling you why.
Mirror-Database
Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model.
Database mirroring setup is a pretty easy thing. The point here is not really to make a complicated process easier but to standadize the way we can set this up.
SQL Server PowerShell | Use the Database Engine cmdlets | Mirror-Database
Create-NLBCluster
Network Load Balancing (NLB) didn’t get a chance to have a new mmc to manage it in Windows 2008; we still have to use the old one inherited from Windows 2003. No way! Now we have a complete set of cmdlets, let’s use them.
Network Load Balancing cmdlets in Windows PowerShell | Create-NLBCluster
Working in and with Temporary Folders
Sometimes, we have to create a (totally random named) temporary folder, do some stuff in it and then delete everything. Here’s the way
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)
Check-SSL
How-to get a SSL certificate expiration date and send an email alert if a defined threshold is exceeded, from a remote place.
Check-SSL | Add-SSLCertificate | Create a self signed SSL certificate
Check-BrokenLinks
Tired of using ‘System.Net.WebClient’ as I am? Upgrade to PowerShell v3 and use Invoke-WebRequest instead!
My first application of Invoke-WebRequest is to create a broken links checker for my website. Choose a webpage URI to scan, it will get all the links in it, and make a hit for each one.
Check-BrokenLinks | HTTP Status codes | Monitor-Website
Restart computer if…
I like to find new needs to fill… Once again, I found one today on LinkedIn: Sambasiva Rao K. asked for some help on the “PowerShell Power Users” LinkedIn discussion group:
I have a requirement where i wanted to monitor the last modified time of a .MDB file and compare it with local system time and if it differences more than 1hour, i want my system to be restarted.
Let’s see!
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.