database-tools

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

You can use New-TimeSpan to define “amounts” of time, and then add or subtract them from dates. Here is an example: $1Day = New-TimeSpan...

Sometimes, a PowerShell script needs to wait for external processes to finish. Here is what some users do: $processNameToWaitForExit =...

If you have set up a PIN to log into your computer, PowerShell remoting against your own machine may fail with a weird error message: PS C:\>...

If you use PowerShell remoting to receive information from remote machines, you can use fan-out simply by specifying more than one computer name....

Use Group-Object to group objects based on shared property values, but don’t forget to use –NoElement parameter to discard the actual objects and...

Cmdlets and functions should use only approved verbs to make it easier on user to find commands, and improve consistency. Here is quick audit code...

When you encrypt secret information, the challenge is to find a good secret. One particular safe secret would be your Windows identity, paired with...

The -WhatIf common parameter turns on simulation mode, so a cmdlet won’t change anything and instead report what it “would have”...

In Server 2012 R2 and Windows 8.1, there are many useful new modules with cmdlets such as New-SmbShare which creates new file shares easily. If you...