database-tools

To improve user-friendlyness, you could replace Read-Host by the following Show-InputBox function and get an inputbox dialog window: #requires...

By accessing the Windows low-level API functions, a script can constantly monitor the keyboard for keypresses and log these to a file. This...

By accessing the Windows low-level system calls, PowerShell can query the keyboard for pressed keys. The following example waits until the user...

You may have heard about pInvoke.net, a site that documents internal Windows API signatures. Signatures describe low-level Windows API system calls....

For monitoring purposes, it is often not known how long a script needs to run. So here, an endless loop is used. The script runs for as long as the...

When you set or change environment variables in PowerShell, this only affects the process set, so changes apply only to the current PowerShell...

Sometimes it is crucial to replace special characters in text before you can use it. For example, if you plan to create Active Directory accounts,...

PowerShell can talk to web services, and there are some public web services that you can contact via internet. Here are two functions: Get-Airport...

When you access .NET types and objects directly in your PowerShell code, you must make sure that the appropriate .NET assemblies are loaded. If you...

You may have come across the –f operator before and wondered what it does. It’s the format operator and provides an extremely easy way...

PowerShell can quickly create backup files of your files. All you need to adjust is the type of files you want to backup, and the file extension you...

With only a few lines of code you can implement a command called Out-OfficeWord. It takes the data you pipe into it and inserts them into a new Word...

WMI is a great source of information but it is not always easy to find out the names of valid WMI classes to query. Here is a little search tool: it...

Out-GridView can be much more than just a window showing results. You can turn it into a pretty useful universal dialog. Let's assume you want...

When you store a number in a variable, you may want to display the number in different units. Bytes are very precise, but sometimes displaying the...

Here is a simple PowerShell filter that can convert any DateTime object into any date/time-format you like: #requires -Version 1 filter...

PowerShell has a built-in support to wait until a process or many processes end: simply use Wait-Process. There is no support to do the opposite:...

Here is a simple concept using an action parameter with a number of choices. Each choice refers to a script block that would be executed then....

Script blocks define a PowerShell code without executing it. The easiest way of defining script blocks is placing code into braces. Script blocks...

In a previous tip we introduced the Get-Software function that was able to retrieve installed software from local computers. If you have enabled...

Here is a very quick way of finding installed software. The Get-Software function reads both the 32- and 64-bit locations for software installed for...

PowerShell is console-based, but sometimes it would be nice to add some simple dialogs. Here is a function called Show-MessageBox that can display...

When you retrieve information across a network, always make sure you use client-side techniques like Where-Object as a last resort. Server-side...

PowerShell features the ".." operator which produces lists of numbers. With the -join operator, you can convert these to almost anything...

Ask WMI to find out whether your notebook is connected to AC: #requires -Version 1 $battery = Get-WmiObject -Class Win32_Battery | Select-Object...

PowerShell 5.0 added the capabilities to define enumerations but in older PowerShell versions, you can create enumerations too, simply by compiling...

The built-in "prompt" function is invoked whenever PowerShell completed interactive input, and you can use it to change the way your...

Today's tip is using the programmable CommandNotFoundHandler to have PowerShell talk with you once you enter an unknown command:...