database-tools

When you divide numbers and just want the decimals before the decimal point, you could cast the result to integer. However, this would also round...

The -match operator can be extremely useful because it accepts regular expression patterns and extracts the information that matches the pattern:...

In an Active Directory environment, PowerShell can easily find the currently logged on user and retrieve AD information about that user, for...

Unfortunately, the Start-Process cmdlet has no -ComputerName parameter so you cannot use it to launch processes on remote machines. Use WMI instead!...

When you use PowerShell Remoting (like the Enter-PSSession cmdlet) to connect to another machine and then start a program using Start-Process, the...

When you want to publish PowerShell code, you may want to make sure that all TAB characters are converted to one or more spaces to save space....

Removing multiple white spaces from text is easy in PowerShell. Simply use -replace operator and look for whitespaces ("\s") that occur...

In a previous tip we showed how you can remove options from a command line text using -replace. Here is a more versatile approach. It will remove...

Let's assume you'd like to remove all options from a raw text command such as this one: xcopy "C:\Some Folder" "C:\Some New...

By default, all variables created in functions are local, so they only exist within that function and all functions that are called from within this...

In forums, people often get confused with error handling. For example, this code does not call the error handler. Instead, the red PowerShell error...

In a previous tip we showed how to use Get-EventLog to extract all events related to system reboots. In PowerShell v2, a new cmdlet called...

To find out when a system restarted and why, use the below code to extract the relevant information from the System event log: Get-EventLog -LogName...

In a previous tip we showed how to use the Send-MailMessage cmdlet to send off emails and preserve special characters by using UTF8 encoding. When...

PowerShell has built-in support for sending emails: Send-MailMessage! All you need is an SMTP server. However, with standard encoding you may run...

If your machine is connected to the Internet more than once, let's say cabled and wireless at the same time, which connection is used?...

WMI is a great information resource, and Get-WmiObject makes it easy to retrieve WMI instances. First, use -List parameter to find WMI class names....

Whenever PowerShell asks for user input or reads text file content, the results are text strings. If you expect numbers and want to calculate, make...

Occasionally, you may want to act on every 2nd or 3rd file in a folder (or line in a file). The easiest way to identify every x. element is to use...

Ever wondered what Internet sites store inside cookies when you visit them? This line will dump all cookies: PS> dir...

Thanks to Peter Bishop, here's an enhancement to one of our earlier tips. It turns the command line output delivered by driverquery.exe into a...

To read in a text file and skip blank lines, try this: $file = 'c:\sometextfile.txt' Get-Content $file | Where-Object { $_.Trim() -ne...

To remove text at the beginning of a sentence rather than somewhere inside the sentence, use the operator -replace and the anchor '^'. Check...

In a previous tip you learned how WMI can deliver system profile information. Let's take this data and turn it into a HTML report. Here's a...

WMI can retrieve a lot more object instances than you might think. If you submit a parent class, Get-WmiObject returns all instances of all derived...

If you need up-to-date exchange rates, try loading the rates via XML from the European Central Bank. This sample gets you the latest exchange rates...

To convert a whole folder full of MS Word documents to PDF, here's a function that might help:/p> function Export-WordToPDF { param(...

What if you wanted to paste information from the clipboard? No sweat, here is a Get-Clipboard function that outputs any text held by the clipboard:...

In a previous tip you learned how to use clip.exe to send results to the clipboard. But what if you don't have clip.exe (let's say on...