database-tools

To quickly open all files of a kind, such as all text or script files found in a folder, you should try the  Open-File function. It will accept...

You should probably use Get-Childitem with its -filter parameter to list specific files because it is much faster than -include. This line will...

In Windows Vista/Server 2008, Microsoft introduced many new service and application specific log files. PowerShell can access those with...

You may be surprised that you cannot filter Help texts by keywords: Get-Help Dir | Select-String "File" This will not return...

Stop-Process can very easily kill all instances of Excel or another program. So this line will kill all instances of Excel: Stop-Process excel...

You should first access the file using Get-Item to encrypt a file with EFS: $file = Get-Item c:\somefile.txt Next, call its Encrypt() method....

PowerShell’s new –split operator can split text into parts. Usually, you will submit a delimiter character to tell –split where to...

You can use Hash Tables to translate individual return values to clear text. This example shows you how to convert return codes 0 and 5 to some...

Operators are an important part of the PowerShell language. Try this to learn more about them: Help operators This will list all the different kinds...

Take a look at this simple filter called grep: filter grep($keyword) { if ( ($_ | Out-String) -like "*$keyword*") { $_ } } And here are...

This line of code will sort system DLLs based on file version. However, it turns out that it sorts incorrectly: dir $env:windir\system32 -filter...

When you pipe results to Write-Host to output them in color, you may be in for a surprise: Get-Process | Write-Host -ForegroundColor Yellow The...

This one-liner accepts one or more IP-addresses and will try to resolve the address. If DNS returns valid information, you will receive the host...

You will discover that PowerShell is production-oriented. So, if you specify object properties that do not exist, you will simply get back...

Sometimes, the column names you see when you run cmdlets do not really correspond with the true object property names. For example, Get-Process will...

You should use Start-Process and its -Wait parameter if you want to force PowerShell to wait for a program to finish before it continues:...

Beginning with Windows Vista/Server 2008, you can get rich information about your machine from the new additional application and service logs that...

You can always use Where-Object when you need to filter results. This cmdlet expects a filter script to determine the results you want. Here are...

On client operating systems, such as Windows 7, there are some Support libraries missing that you will need  to display terminal server...

Use the provider name instead of a drive name when you need to get a list of all registry hives:   Dir Registry::   ReTweet this Tip!

If you need to set the default value for a registry key, you can  use either of these approaches:   Set-ItemProperty -Path...

You can start by dumping all Help information into a file to learn more about a PowerShell cmdlet. You can then read all details about the cmdlet...

Out-GridView is a great way to present results in a “mini-Excel” sheet: Get-Process | Out-GridView However, Out-GridView has two...

Inside the PowerShell console, you can hold CTRL while pressing the arrow key to move the cursor word-by-word. This way, you can move the cursor...