database-tools

Out-GridView with Custom Columns

Out-GridView can be a universal dialog when you use the -OutputMode or -PassThru parameters. When you do, a grid view window displays additional...

Converting Ticks to DateTime

Occasionally, date and time information are stored as “Ticks” in the format of a so-called “FileTime”. Ticks are 100-nanosecond units since...

Converting File Paths to 8.3 (Part 1)

Why Short Path Names Still Matter Many years ago, file and folder names had a maximum of 8 characters, and these short path names still exist. They...

Updating Help without Admin Privileges

In Windows PowerShell, updating help used to require Administrator privileges due to a design flaw: help had to be stored in the location where the...

Setting and Clearing Trusted Hosts

PowerShell remoting maintains a list of trusted IP addresses and/or machine names on the client side (the machine that issues the command and...

Identifying Antivirus Engine State

In the previous tip you learned how you can query WMI to find out the antivirus product present on your Windows machine: $info = Get-CimInstance...

Speeding Up PowerShell Remoting

PowerShell remoting is insanely powerful: with Invoke-Command, you can send arbitrary PowerShell code to one or many remote machines and execute it...