database-tools

In the previous tip we looked at how to efficiently count items like files in a folder. Here are some more examples. Counting the number of files in...

A quick and dirty approach for counting files could be this: (Get-ChildItem -Path c:\windows).Count However, it would produce some memory load...

URL shortening is great for Twitter messages but hides the origin. Would you really trust http://bit.ly/e0Mw9w? Here is a simple approach that lets...

In the previous tip we explained how you can retrieve weather forecast data using Invoke-WebRequest. This was pure black-and-white text. To get a...

Invoke-WebRequest can easily retrieve web page content for you. If you run it without the –UseBasicParsing parameter, the HTML is even parsed...

Do you use Read-Host to receive user input? If you do, rethink. Read-Host always prompts a user, and there is no way to automate scripts that use...

PowerShell does not ship with help files, and installing help files locally requires Administrator privileges. A much easier approach can often be...

In the previous tip we talked about logging script results, and how you can assign values and at the same time output the assigned values by using...

There are numerous ways to log script output but one especially lazy technique is to run Start-Transcript. In PowerShell 5, this cmdlet is supported...

When you’d like to install modules for all users from the PowerShellGet repository, you need Administrator privileges. On PowerShell Core on...

Here is a little secret that applies to powershell.exe when it is called from within PowerShell or PowerShell Core: when you run powershell.exe and...

Distinguished names are strings, and strings contain powerful ways of parsing data. The most powerful yet simple approach is the Split() method....

Have you ever wondered whether someone has logged into your PC while you were away? In a previous tip we explained how you can examine the rich...

The Windows “Security” log contains rich audit information. By default, it logs all requests for privilege elevation which occurs when...

Whenever a PowerShell function needs to return more than one kind of information, it is important to wrap them as objects. Only then will the caller...

Get-WmiObject and Get-CimInstance both can provide you with a lot of valuable information, provided you know the name of WMI classes to query. Here...

If you use the PowerShellGet module (which ships by default on Windows 10 and Server 2016), you can easily download and install shared PowerShell...

Most installed software registers itself in one of four places inside the Windows Registry. Here is a quick PowerShell function called...