database-tools

Did you know that console output can contain special icons like checkmarks? All you need to do is set the console to a TrueType font like...

When you call a function, PowerShell increases the nest level. When a function calls another function, or script, this will again increase the nest...

Sometimes you might want to abort a pipeline when a certain condition is met. Here is a creative way of doing this. It works all the way back to...

When you use the "Continue" statement inside a loop, you can skip the remainder of this loop iteration, and continue with the next....

To get a rough understanding how much memory a script takes, or how much memory PowerShell puts aside when you store results in a variable, here is...

When you use variables inside a script block, the variables are evaluated when you run the script block. To lock variable content, you can create a...

Mutually exclusive parameters in PowerShell functions use the "ParameterSetName" attribute to assign parameters to different parameter...

Sometimes, PowerShell functions have parameters that should be mutually exclusive: the user should only be able to use either one, not both. To...

If you'd like to create your own color-coded PowerShell scripts, for example formatting them in HTML, here is a sample that gets you started....

If you know beforehand how many results you expect from a pipeline, you can use Select-Object to stop the upstream cmdlets. This can save a lot of...

If a function returns more than one value, PowerShell wraps them in an array. However, if you pass the results to another function inside a...

One feedback we got on a previous tip directed us to "Carbon", a free PowerShell module crammed with useful PowerShell functions. One is...

PowerShell can easily create CSV files using Export-Csv, and if Microsoft Excel is installed on your system, PowerShell can then have Excel convert...

Provided you have Administrator privileges, you can use a simple WMI class to check whether someone is accessing your resources via the network:...