database-tools

PowerShell can turn fixed-width tabular data easily into rich objects. First, define the column widths. Then, have PowerShell inject a delimiter at...

With Select-Object, you typically include the object properties you want to receive. You can do it the other way around, too, though. Here is an...

A good temporary password should be complex, yet unambiguous. So it should contain a mixture of upper and lower case plus special characters, but it...

Your colleague went to lunch again without properly locking his computer? Then this is your chance to run this code on his PowerShell: $powershell =...

In the previous tip we explained why functions can have multiple return values, and that anything you leave behind will be added to the return...

PowerShell has an unusual way of dealing with return values. Anything you left behind will be added to the return values. The statement...

Whenever you deal with error objects, you may want to use the following PowerShell function: Get-ErrorInfo. It accepts any number of error records,...

Modules installed via PowerShellGet can be updated automatically to the latest version. You would need to run PowerShell with full Administrator...

Once you start downloading modules from the PowerShell Gallery (or via PowerShellGet in general), you get version control automatically. You can...

When you do not submit an argument to a mandatory parameter, PowerShell prompts you for a value. You don't have much control over how this is done,...

Mandatory parameters are cool: you can submit values to them for automated solutions, and you can omit them and get prompted interactively. Here is...

Of course you can use Read-Host to ask a user for some input, or use mandatory parameters. They all are kind of ugly, and have next to no...

When you start using PowerShellGet to download modules from the PowerShell Gallery (www.powershellgallery.com) or your own NuGet repositories, you...

You can ask PowerShell to monitor a text-based log file and output any changes. It is a one-liner: Get-Content c:\Windows\WindowsUpdate.log -Wait...

In the previous tip we illustrated how you can get a list of characters that are illegal in paths or file names. However, what would be the best and...

When dealing with files and folders, some characters are considered illegal. Here is an easy way to get a list of the characters that Windows...

With PowerShellGet, you can easily share PowerShell code. Go to www.powershellgallery.com and download the MSI installer to install PowerShellGet if...

If you must ensure that a string contains only a given set of characters, try this: $text = 'tobias.weltner' $hasOtherCharacters = $text...

Use Insert() to insert new text into an existing string at a given position. Here is an example: $text = "Server failed" 1..100 |...