database-tools

Sometimes you might want to check the digits of an integer, i.e. to validate user input. Here is a really simple way using regular expressions: #...

A quick way of opening PowerShell is to launch Windows Explorer, navigate to the folder with your data, then click into the navigation bar. The...

Some cmdlets and scripts use progress bars to indicate progress. As you learned in the previous tip, progress bars cause delays, so if you...

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