database-tools

Select-String can find lines with a specific keyword. It can also include context-relevant lines before and after that line. This will filter the...

When you launch *.exe-applications with arguments, you may get exceptions because PowerShell may misinterpret the arguments. A better way to do this...

If you need to list all cmdlets that deal with file system-related tasks, try this: Get-Command -Noun item*, path Many of these cmdlets have...

To append a CSV file with new data, first of all make sure the type of data you append is the same type of data already in a file (or else column...

ConvertTo-CSV can create comma separated values (CSV) on the fly but it always adds a new header. To create CSV data without columns, take a look at...

In a previous tip we illustrated how -like can work on array. To iterate on that, check out how -like (in contrast to -contains) allows the use of...

If you need to get two random numbers from a given numeric range, and you want to make sure they cannot be the same, simply tell Get-Random to pick...

If you wanted to exclude results with empty (text) columns, you can filter based on $null values. This will get you all processes with a valid...

In a previous tip we showed you how you can add new drives to easily access your desktop, your cookies or media like music and video. However, when...

Use Select-Object to determine which information in a result you are interested in. Here are three easy rules for its parameters: Use -Property *...

In a previous tip we showed how Get-WmiObject can search for WMI class names. Some of the returned WMI class names aren't particularly useful,...

In PowerShell v2, to list only files or only folders you had to do filtering yourself: Get-ChildItem $env:windir | Where-Object { $_.PSIsContainer...

Finally, in PowerShell v3 the cmdlet Export-Csv got a new parameter called -Append! Now you can easily append information to an existing CSV file....

Since Select-String is such a useful cmdlet, the PowerShell decided to add an alias to it in PowerShell v3. The alias is called sls. Try this:...

In a previous tip we illustrated how you can create code snippets for PowerShell ISE v3 script editor using New-ISESnippet. All custom snippets are...

In PowerShell v3, Get-ChildItem now supports sophisticated filtering through its –Attribute parameter. To get all files in your Windows folder...

In PowerShell v3, Restart-Computer now has a number of useful new parameters. For example, you can restart a remote machine and wait for the reboot...

The new PowerShell ISE script editor in PowerShell v3 lets you customize a lot of colors, so if a particular color does not show well on a...

In PowerShell v2, Out-GridView was a useful way of displaying information in a separate window but its functionality was limited because you could...

In PowerShell v3, Get-Content was reading text files line by line. This was great for pipeline processing but could take a long time and also...

In PowerShell v3, the new PowerShell ISE script editor has improved a lot. Yet, it still has no real console but instead sports a useful console...

The new PowerShell ISE script editor that ships with PowerShell v3 has a much improved IntelliSense (code completion) that you can even fine-tune...

In a previous tip we showed you how to add your own little code snippets to the new PowerShell ISE v3 script editor. Here's how you can get rid...

If you'd like to find out whether a given URL goes through a proxy or is accessed directly, you can use this neat little trick: Function...

By default, when you import Microsoft’s ActiveDirectory PowerShell module which ships with Server 2008 R2 and is a part of the free RSAT...

If you already use the new PowerShell ISE v3 script editor, you noticed that the editor now has an almost real console with input and output going...

PowerShell ISE v3 script editor supports code snippets. Press CTRL+J to open a list of built-in snippets. You can add your own snippets, too. For...

With just a couple lines of code, PowerShell can search for Twitter news. If you happen to live in Germany, then this would tell you the latest...