database-tools

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

When you copy variable content, you may just copy the "reference" (memory address), not the content. Take a look at this example: $a =...

In VBScript there were encoded scripts. Encoding is by no means a safe way of hiding script content, but it makes it a little harder for users to...

If you must run some code before PowerShell should exit, you could simply use a try…finally clause like this: try { # some code Start-Sleep...

Background jobs can help speed up your scripts. If your scripts consist of a number of separate tasks that also could run in parallel, then...

Windows 10 comes with a bunch of preinstalled apps. Fortunately, you can use PowerShell to remove any app you don’t like. You may need...

If you use Invoke-Command to remotely execute PowerShell code, you may have noticed that PowerShell remoting adds a new PSComputerName property that...

This small piece of code prompts for a new registered owner name, then updates the value in the Windows Registry. Note that this requires...