database-tools

If all you need is a beep, then PowerShell can help you easily: $frequency = 800 $durationMS = 2000 [console]::Beep($frequency, $durationMS) If...

When you try and sort IPv4 addresses via Sort-Object, this fails: PS> '10.1.2.3', '2.3.4.5', '1.2.3.4' | Sort-Object 1.2.3.4 10.1.2.3 2.3.4.5...

In the previous tip we published a super-fast function called Test-OnlineFast, and this function was able to ping an entire IP segment in record...

In the previous tip series, we developed a new function called Test-OnlineFast that can ping multiple computers in record time. For some reason, the...

There are a number of useful cmdlets to manage event logs, however one functionality is missing: PS> Get-Command -Noun EventLog CommandType Name...

When you call low level functions from PowerShell, often you get back a numeric return value. If the return value came from a Windows API function,...

When you write events to an event log using Write-EventLog, you must specify a valid source name. However, there is no easy way of finding out which...

Often scripts need to log what they do, and PowerShell scripters invest a lot of thought and time on logging information to text files. As an...

Tiny URLs like “http://bit.ly/e0Mw9w” are short and convenient to use, however they often mask the true origin as well. PowerShell can...

Are you tired of boring wallpapers for your desktop? PowerShell can get you new wallpapers! Here’s the function: function Download-Wallpaper { param...

Occasionally, you may have to update values in an Excel spreadsheet. PowerShell can access the Excel object model however this is quite slow. Here...

Occasionally, you may have to read information from Excel spreadsheets. PowerShell can access the Microsoft Excel object model albeit it is quite...

PowerShell can set environment variables only in its process set, so these changes will not persist and are not visible outside of PowerShell. To...

Here is a line of code that often puzzles PowerShell users: Get-Service | Select-Object -ExcludeProperty Name When you use Select-Object, its...

Here’s a code snippet that forcefully closes all open documents in the PowerShell ISE. Be aware: it closes all documents without asking to...

In the final part of our mini-series, we add pipeline awareness to our super-fast Test-OnlineFast function. You now can pipe computer names into the...