database-tools

PowerShell can access COM-Objects as there are many useful objects present on a system. For example, WIA.Image can return all kinds of useful...

In PowerShell V2, Get-Random retrieves as many random numbers as you like, allowing you to use this random number generator in many scenarios. A...

When you move onto PowerShell V2, most of your V1 scripts will hopefully continue to work. There are only few bug fixes that could affect...

You may want to occasionally restart a single-instance process. However, shutting down a process does not necessarily mean it is killed in that...

PowerShell has an extremely flexible way of submitting return values. Instead of explicitly setting the return value of a function, PowerShell...

Working with event logs has become a lot easier in PowerShell v.2, and you have seen how you create and maintain your own logs. So, if you'd...

In PowerShell v.2, it is very easy to create and maintain your very own event logs to track errors in your scripts or other automation solutions....

In PowerShell v.2, Get-WinEvent provides access to events written to the numerous Windows event logs. In addition, you can also examine event...

There are numerous Windows event logs and you now have full control using Get-WinEvent in PowerShell v.2. Instead of searching for specific event...

In PowerShell v.1, Get-Eventlog would retrieve standard event log entries from event logs like "System" or "Application," but...

It isn't always easy to pick the right process because the process ID or process name may not be known or ambiguous. If the process has a window...

Get-Process retrieves all running processes and a wealth of information attached to them. One especially useful property is mainWindowTitle which...

Windows 7 comes with a bunch of modules that are not loaded by default. Use this to see which modules are available: Get-Module -listAvailable For...

Modules in PowerShell v.2 can declare which functions, variables, aliases etc. are public and visible to the caller and which ones are hidden. With...

In PowerShell v.2, all new modules work like libraries and can be loaded using Import-Module to gain access to all public functions, variables,...

In a previous tip, you learned about the new modules in PowerShell v.2, which can be loaded using Import-Module. Once you have loaded a module, it...

In PowerShell v.2, there is a new feature called "module," which is a file with the extension .psm1 and behaves almost exactly like a...

Trap, which has been around since PowerShell v.1, is designed to catch errors and works like this: trap { Write-Host -foregroundcolor Yellow `...

As PowerShell v.2 becomes more common , you may want to check which PowerShell version a machine is running. Use this to differentiate between v.1...

As PowerShell becomes more important, you may want to automatically check whether it is available on a machine. To determine whether any PowerShell...

In the previous tip, you used a hash table to translate input values. However, unlike Switch-statements, Hash Tables have no "default" so...

You may have already used Switch to translate input and output values like this: function Get-Name($number) { switch ($number) { 1 { "One"...

You probably know that the Switch statement checks against a value and returns whatever you have defined for this condition like so: function...

There is scripting expertise built-in to PowerShell v.2 that can be activated like this: set-strictmode -version 1set-strictmode -version 2 Use the...

If you'd like to determine a system's uptime, you should use WMI and convert the WMI date into a more readable format: function...

Up for some fun with your prompt? Make it a bit shorter, display the minutes (or hours) you have been working so far, and show the current path in...

Each process stores its start time, so it is fairly easy to find out when the process was launched. If you'd like to know when you started your...

If you ever want to access the process that is executing your current PowerShell session, use the $pid automatic variable which tells you the...

In a previous tip, we have added a new script method to a string called Words() which would split the string into words. But is it worth the effort?...