database-tools

Today's tip is using the programmable CommandNotFoundHandler to have PowerShell talk with you once you enter an unknown command:...

One of the easiest ways of getting your operating system version is this one line of code: PS> [Environment]::OSVersion Platform ServicePack...

When you receive a red error message from PowerShell, you can always encapsulate the code in a try…catch block and handle the error yourself:...

The default PowerShell prompt displays the current location. When you are deep inside nested folders, this steals room for your actual input, and...

Rather than ranting about things that don't work as expected, or things you feel are missing, be constructive! The PowerShell team takes great...

In the PowerShell ISE, there are two key shortcuts that can help you. Pressing TAB works just like in the console, and each time you press TAB, you...

Whenever PowerShell comes across a command name that it does not know, you see a red error message. However, starting with PowerShell 3.0, there is...

Often when you write PowerShell scripts, you may not have used the correct casing, used only partial parameter names, or used aliases instead of...

To dump all .NET assemblies that are loaded in a PowerShell session, try this: System.AppDomain]::CurrentDomain.GetAssemblies() | Where-Object...

PowerShell cmdlets and functions can have parameters, and these parameters can have (shorter) alias names. One prominent example is the...

If all of your systems run PowerShell 3.0 or better, you can start shortening function parameter attributes. Boolean attributes now all default to...

Some may have come across a .NET call that is supposed to generate random temporary file names: $path = [System.IO.Path]::GetTempFileName() $path...

When you run PowerShell code outside a PowerShell console, you need to submit the code to powershell.exe. To make sure your code does not conflict...

If you'd like to apply a numeric range of legal values to a variable, you can add a ValidateRange attribute to the variable, pretty much like...

If you try and increase your maximum command history, you may run into some limitations: PS C:\> $MaximumHistoryCount = 100000 The variable...

Command history can be a great help when you work for a while in a PowerShell session. Each session stores the commands you issued, and you can...

In PowerShell 3.0 and better, it's trivial to get back real DateTime information from WMI using Get-CimInstance. This would tell you when your...

In a previous tip we explained how you can safely "clone" an array using Clone() method. This will copy the content of an array to a new...