database-tools

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