database-tools

PowerShell supports a number of #requires statements. Technically they are comments but PowerShell checks the requirements, and if they are not met,...

If you do output completely different objects, you may lose information. Take a look at this example: #requires -Version 2 $hash = @{ Name =...

Here is a quick way of getting a good excuse - provided you have Internet access: #requires -Version 3 function Get-Excuse { $url =...

If you run at least Windows 8 or Windows Server 2012, you can use Get-NetTcpConnection to find out which network ports are in use, and who is...

The good oldfashioned netstat.exe can tell you the ports that applications listen on. The result is plain-text, though. PowerShell can use regular...

In a previous tip we showed how you can send text to a fresh Notepad instance. Today, you get an enhanced version of Out-Notepad: you can pipe...

Notepad can be used to display text results. Typically, you would need to save text results to file, then have Notepad open that file. There is a...

Here is a very special (and very underdocumented) way to use PowerShell parameters. Have a look at this function: #requires -Version 2 function...

PowerShell is an extremely powerful language and can access web services and web pages. If you combine that with dynamic parameters, you get a...

Let's assume you have a bunch of Word files and would like to know how much pages they contain. Here is a function that takes the path to one...

PowerShell can use Add-Type to access internal Windows API functions. This way, it is easy to bring any process window into the foreground. Here is...

In parts 1 and 2, you learned how a PowerShell function can process information that was submitted to parameters or piped via the pipeline. In our...

In part 1 we showed how a PowerShell function can receive input both from a parameter and via the pipeline, and process it in real-time. This is the...

This is the first of the three tips showing you how a PowerShell function can accept data via pipeline or parameter. In part 1, the function...

PowerShell can use UIAutomation calls to find out useful UI information about any process. You can find out whether a process accepts keyboard...

In PowerShell 5.0, Compress-Archive can easily compress files and folders to a ZIP file: PS C:\> Compress-Archive -Path c:\sourcefolder...

If you have Windows Defender installed on your machine, you can use this PowerShell command to run a quick scan on a drive of your choice: PS>...

By default, the Telnet client is disabled on Windows systems. You can easily enable it with a one liner in PowerShell, though. Just launch a...

By default, PowerShell remoting uses Kerberos authentication and works only in domain environments, and only when you specify computer names, not IP...

Beginning in PowerShell 4.0, you can use validators for variable assignments. This gives you a quick and easy way of validating user input, too. The...

To restore custom settings in PowerShell ISE to factory defaults, try running these lines: $PSise.Options.RestoreDefaults()...

Have you ever tried to enable PowerShell remoting with Enable-PSRemoting, and just got an error complaining about not being able to check the...

Sometimes, Windows Explorer does not show correct icons. When you update to PowerShell 5.0, for example, both PowerShell and PowerShell ISE got new...