database-tools

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?...

In a previous tip, you learned how to add custom properties to objects. Today, we want to show you how to add custom methods and also give an...

You may have heard that PowerShell can add custom properties to objects. While we are not going into much detail about this here, we'd like to...

In a previous tip, you learned that CSV files use different separators, depending on your culture. While you were unable to select a separator in...

In PowerShell V1, creating CSVs wasn't very flexible because PowerShell was limited to the comma as separator. In many cultures, different...

In the previous tip, you learned that Export/Import-CSV does not persist property types. Instead, all properties are converted to string. To...

Export-CSV and Import-CSV are great ways of persisting data in a structured way. There are some limitations, though. Take a look. This line saves a...

If you start experimenting with PowerShell V2 ISE (editor), you may notice that all scripts you create are saved in Unicode by default. This was...

Alias names are shortcuts for other commands, and you probably know that. In PowerShell V1, the only way to retrieve all aliases for a given target...

You can run classic cmd commands from within PowerShell and store the results in variables. All you need to do is invoke cmd.exe with the /c switch...

Since both PowerShell and the classic cmd.exe are console-based, it is very easy to switch between both of them. If you must use a classic shell...

Moving the cursor in long input lines is not very convenient. You cannot use the mouse and have to use arrow keys to move backwards and forward....

Maybe you have noticed that some PowerShell consoles have a nice blueish background while others default to black. Actually, the blueish background...

Well, ok, Consolas wasn't specifically designed for PowerShell but rather as an enhancement for all consoles. It is a new Microsoft font that...

Each PowerShell console has a small icon at the left of its title bar, and when you right-click this icon and choose Properties, you open the...