database-tools

Monthly Capacity Reporting

Monthly Capacity Reporting I need to provide server by server (Wintel) some preety management pictures that show CPU both peaks and average with a...

read more

Finding Folder Changes

Compare-Object can help you monitor folder content and find changes. To monitor, first create an initial snapshot. At a later time, you can then...

read more

Comparing Results

PowerShell makes it easy to compare results and find only things that changed. For example, you may want to list only processes that started after a...

read more

Write-Protected Arrays

Arrays are by default read/write so you cannot lock down arrays and make them read-only. To create a read-only array, you can "upgrade" it...

read more

Turbo-Charging Arrays

Simple arrays have no built-in mechanism to insert new elements or extract elements at given positions. For example, to extract the 5. element from...

read more

Creating Numeric Ranges

There is a clever trick in PowerShell to create numeric ranges that you probably know: 1..10 But did you know you can use variables with this trick?...

read more

Creating Random Numbers

Ever wanted to create an electronic dice (or needed random numbers for other purposes)? With PowerShell, simply instantiate a Random object and call...

read more

Creating Lists of Letters

The easiest way to create an array of letters is to convert an array of numbers into an array of characters like this: $letters = [char[]](97..122)

read more

Sorting Arrays

Let's assume you have an array of items which you would like to sort. Here is the PowerShell way: $array = 1,5,32,5,7$array | Sort-Object$array...

read more

Analyzing URLs

URLs contain a lot of information which can be automatically parsed by PowerShell. Simply convert a URL to the System.URI type. Once you did this,...

read more

Escaping Text Strings

HTML on web pages uses tags and other special characters to define the page. To make sure text is not misinterpreted as HTML tags, you may want to...

read more

Checking Host Name Type

To check whether a string contains a valid host name, you can use the CheckHostName() method provided by the System.URI type. It will return...

read more

Validating a URL

To make sure user input is a valid URL, you can use the System.URI type. Try to convert the raw string into this type. If it works, the string is a...

read more

Reversing Array Order

To reverse the order of elements in an array, the most efficient way is to use the [Array] type and its static method Reverse(): # Create an array...

read more

Validating IP-Addresses

To check for a valid IP-address, use the .NET Framework type System.Net.IPAddress and test whether the data can be converted into this format:...

read more

Validating Email-Addresses

To check for valid email addresses, you can use the .NET Framework type System.Net.Mail.MailAddress and test whether the data can be converted into...

read more

Exiting a Function

To exit a function immediately, use the return statement. The next function expects a name (including wildcards) and lists all matching processes....

read more

Quick Drive Info

Want to quickly get a number of interesting details for any drive? Use the .NET System.IO.DriveInfo class like this: New-Object System.io.DriveInfo...

read more

Ping and Range Ping

In PowerShell, you can access .NET methods directly so it is easy to add a ping functionality: $object = New-Object...

read more

Validating User Input

When writing a function that accepts parameters, you can strongly-type parameters so that an exception occurs when the user submits the wrong...

read more