database-tools

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

The Windows file system often has issues with file paths longer than 256 characters. Provided you followed our tips and installed PowerShellGet, you...

In PowerShell 5.0, when you enter code into the PowerShell console, the tokens get colorized, much similar to the PowerShell ISE interactive...