database-tools

Here is a quick and fast way to bulk-rename files like photos, or other files. Have a look: #requires -Version 1.0 $Path = "$home\Pictures" $Filter...

When searching for specific AD accounts, you may have used Get-ADUser in the past, and filtered results with a filter parameter. Such filters can...

PowerShell 5.1 (shipping with Windows 10 and Server 2016) can now natively manage local accounts. In the previous tip you learned how to use...

PowerShell 5.1 finally ships with cmdlets to manage local user accounts. To get a list of local user accounts, use Get-LocalUser and pipe the result...

By default, Get-ADUser (provided by ActiveDirectory module which is part of the free Microsoft RSAT tools) retrieves only a few default properties....

Sometimes, scripts interactively ask for credentials, or passwords. Always be aware that the script author can get to the plain text of all entered...

When PowerShell auto-encrypts a secure string, it uses your identity as secret. Only you can decrypt the secure string. What if you want to encrypt...

In the previous script we showed how you can save a credential object in encrypted form to disk. A similar approach just saves the secret password...

For unattended scripts, it is generally unsafe and not recommended to hard-code secret passwords into a script. As an alternative, you could ask for...

For scripts running unattended, you can create login credentials from code. This requires the secret password to be saved as clear text in a script...

Let’s assume you need to run a script every day that requires credentials. A safe way of storing credentials is to save them encrypted in a...

In the previous tip we illustrated how you can use Select-String to find lines in raw text containing a specific word. It took some effort to...

In the previous tip we explained how you can use Select-String and a regular expression to extract valuable information from raw text results: PS...

Sometimes, you may want to extract valuable information from pure text results. One easy way is the use of Select-String. This example extracts only...

In the previous tip you learned how you can use Show-Command to create simple UIs for text-based commands: #requires -Version 3.0 function...

Function and cmdlet parameters basically are the technique how PowerShell creates „user interfaces“. These text-based interfaces can...

PowerShell can add value to existing commands such as robocopy. Take a look at the below function--it uses robocopy to copy files, and adds the...

When you select code in the PowerShell ISE and copy it to the clipboard, it is copied in RTF format and preserves all color coding and font...

While it is recommended to use the modern WPF technology to create PowerShell user interfaces, you might still want to occasionally use the older...

When a PowerShell script ends, you can run the command “Exit” and submit a numeric value. This has been good practice in the Windows...

If you run PowerShell on Linux, you can combine Linux and PowerShell commands. To take the output of a Linux command and assign it to a PowerShell...

Test-Path can check whether a file or folder exists. If you add -PathType and specify Leaf (for files) or Container (for folders), the result can be...

Sometimes, you’d like to use different units of measurements. The total system memory is reported in bytes, for example. Here are some...