database-tools

PowerShell comes with support for progress bars. Here is a very simple example: 1..100 | ForEach-Object { Write-Progress -Activity...

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