database-tools

Persisting Comparison Snapshots

Whenever you'd like to compare long-time results or compare data on different machines, you want to use persisted result sets. Persisted result...

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...

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...

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...

Setting Properties on AD Users

If you'd like to find Users in your Active Directory and bulk-change certain properties, you may not need 3rd party extensions. Here is an...

Calculating Space Consumption

If you ever wanted to find out which folder in your profile consumes the most space (or want to check user profiles to make sure people do not...

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...

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...

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?...

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...

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)