database-tools

Saving Credentials

Here is a safe way of saving credentials to a file: $CredPath = "$home\Desktop\mycred.xml" Get-Credential | Export-Clixml -Path $CredPath...

read more

Clearing the Recycle Bin

A much awaited new cmdlet surfaced in PowerShell 5.0: Clear-RecycleBin! You can clear the recycle bin on a particular drive, or on all drives. This...

read more

Using Enumerations

Beginning with PowerShell 5.0, you can use the new keyword "enum" to create enumerations. They can be useful for parameter validation:...

read more

Reading Excel Cells

The fastest way to read data from an Excel spreadsheet is to export the data to CSV, then use Import-CSV. However, sometimes the data in an Excel...

read more

Accessing API Methods

PowerShell can use C# to define new .NET types that access the internal Windows API methods. Here is some code that makes accessible the...

read more

PSGet is Evil!

If you have played with the early releases of PowerShellGet and the PowerShell Gallery (www.powershellgallery.com), you may still have a module...

read more