database-tools

Here is a simple function to find out the reserved drive letters: #requires -Version 3 function Get-DriveLetter { (Get-WmiObject -Class...

To quickly (and permanently) set a bunch of environment variables, here is a nice approach: $hashtable = @{ Name = 'Weltner' ID = 12 Ort =...

To quickly locate a PowerShell script anywhere in your MyDocuments folder, take a look at this Find-Script function: #requires -Version 3 function...

When you override the ToString() method of an object you control how this object is displayed. The object content stays untouched, though: $a = 123...

When you retrieve results, you may want to add additional properties to the results so later you know where they came from. Attaching additional...

Maybe you'd like to tag a variable and provide some extra information. In PowerShell, use Add-Member and attach NoteProperties or ScriptProperties...

If you'd like to keep settings outside of your script and store them in a separate config file, then you can use all kinds of data formats for...

Did you ever need to compare two arrays? Compare-Object might help. Check this out: $array1 = 1..100 $array2 = 2,4,80,98 Compare-Object...

You want to quickly get a list of IP addresses for your own computer or a network machine? Here is how: #requires -Version 3 $ComputerName =...

Let's assume you want to chop off some text at the end of a string. This is the traditional approach using string operations: $text = "Some...

While you can still use the old redirection operator to write command output to a file, you should rather use PowerShell cmdlets instead. Here is...

When you need to run code as a PowerShell command in a separate powershell.exe, it is not always safe to submit the code. Depending on from where...

When you need to define multiline text, in PowerShell you typically use here-strings like this: $text = @" I am safe here I can even use...

In PowerShell 1.0 and 2.0, you needed a lot of weird code to find out the current script location: # make sure the script is saved and NOT...

In a previous tip we showed how you find cmdlets that expose dynamic parameters. Let's explore what the dynamic parameters are. The function...

Some cmdlets expose dynamic parameters. They are valid only in certain contexts. Get-ChildItem, for example, exposes -File and -Directory only when...

The PowerShell ISE sports a zoom slider at its lower right edge, and you can control this slider with PowerShell code. So you could set defaults for...

If you do not have PowerShell 5.0 and .NET Framework 4.5 is not available, here is an approach to unzip ZIP files that uses the native Windows shell...

ZIP file support was introduced in PowerShell 5.0, but if you have installed the .NET Framework 4.5 and possibly want more control over the...