database-tools

Sometimes cmdlets take some time, and unless they emit data, the user gets no feedback. Here are three examples for calls that take a long time...

You can use a background thread to monitor how long a script is running, and then kill that script if it takes too long. You can even write to an...

Get-Process can list processes but does not provide information about who is running the process. Here, WMI can help. Get-ProcessEx is a clever...

In a previous tip, we showed how you can export a scheduled task to an XML file. Now, it's time to see how you can re-import that XML file to...

Here's an easy way how you can export and dump a task that you created in "Scheduled Tasks" to XML: function Export-ScheduledTask {...

If you want PowerShell to use the same proxy settings that are set in your Internet Explorer browser, then here's the code you need: $proxy =...

If you need a new icon and have no icon editor at hand, then you can take a bitmap file (create one with MS Paint if you must) and have PowerShell...

Regular Expressions are a great help in identifying and extracting data from text. Here's an example that finds and extracts a number that ends...

In a previous tip you discovered driverquery.exe to list driver information. This tool sports a /V switch for even more verbose information....

To make a list of items or names unique, you could use grouping and then, when a group has more than one item, append a numbered suffix to these...

Some months ago we introduced to you the driverquery.exe tool and how to convert its output to PowerShell objects. Here's now an amazing...

In a previous tip you learned how to use the string method EndsWith() to check whether a text ends with certain characters. This method does not...

You can always use the String method EndsWith(). Just make sure you convert the text to lower-case first to avoid case-sensitive comparison. This...

In a previous tip you learned how to use Group-Object to analyze text-based log files. Here's a refined snippet. It will count on which days...

Did you know that Group-Object can analyze text-based log files for you? Here's sample code that tells you how many log entries on a given day a...

Many file-related .NET Framework methods fail when the overall path length exceeds a certain length. Use low-level methods to convert lengthy paths...

To assign results to a variable and at the same time view these results in your console, place the assignment operation into parenthesis: ($result =...

In a previous tip, you learned how to use the Bitconverter type to convert hexadecimals to signed integers. Here is another way that uses type...

If you convert a hex number to a decimal, the result may not be what you want: PS> 0xFFFF 65535 PowerShell converts it to an unsigned number...

Here's a low level call that returns all time zones: PS> [System.TimeZoneInfo]::GetSystemTimeZones() Id : Dateline Standard Time DisplayName...