database-tools

All PowerShell Versions Since PowerShell returns anything that commands leave behind, it is particularly important in PowerShell scripts to discard...

All PowerShell Versions Can parameters be optional and mandatory at the same time? They can, based on context. A parameter can be mandatory when...

All PowerShell Versions Here are the four most important Math functions needed by administration scripts: [Math]::Floor(4.9) [Math]::Ceiling(3.2)...

All PowerShell Versions Here are a bunch of useful (and simple to use) system functions for dealing with file paths:...

All PowerShell Versions To find the smallest and largest item in a range of numbers, use Measure-Object: $list = 1,4,3,1,3,12,990 $result = $list |...

All PowerShell Versions Let's assume you want to identify suspicious service states like services that are stopped although their start mode is...

All PowerShell Versions Whether it is a birthday or an important game, you may want PowerShell to tell you just how many hours it is till the event...

All PowerShell Versions Strings enclosed by double-quotes will resolve variables so it is common practice to use code like this: $name = $host.Name...

PowerShell 3.0 or later To play a WAV sound file in a background process, PowerShell can use the built-in SoundPlayer class. It accepts a path to a...

All PowerShell Versions Windows starts a high definition counter each time it boots, and this counter will return the milliseconds the system runs:...

All PowerShell Versions If you'd like to know whether there are currently USB storage devices attached to your computer, WMI can help:...

All PowerShell Versions To test whether a particular service is still responding, use a clever trick. First, ask WMI for the service you want to...

All PowerShell Versions The WMI service can report plenty of details about the computer hardware. Typically, each type of hardware is represented by...

All PowerShell Versions If you want to find out whether a computer is frequently put into sleep or hibernation mode, here is a function that reads...

All PowerShell Versions When you parse text-based log files, or need to filter other types of information, you typically use Where-Object. Here are...

All PowerShell Versions Get-HotFix is a built-in cmdlet that returns the installed hotfixes. It has no parameter to filter on hotfix ID, though....

All PowerShell Versions Windows logs all shutdown events in its System event log. From there, you can extract and analyze the information. Here is a...

All PowerShell versions Get-ChildItem does not support advanced file filtering. While you can use simple wildcards, you cannot use regular...

All PowerShell versions When you use Get-ChildItem to get a list of files, you may have noticed that the -Filter parameter occasionally returns more...

All PowerShell versions When you run a console application inside the ISE editor, non-standard characters such as “ä” or...