database-tools

Resolve-Path is an excellent cmdlet to find paths that have the same nesting level. For example, here's a really short script that creates a text...

If you'd like to quickly select and copy results from the Console Pane of the PowerShell 3.0 ISE editor into your blog or favorite word...

Whenever you run Get-WmiObject against a remote system, it will create a new connection. So if you query different WMI classes, each query will use...

Are you familiar with the PowerShell Survival Guide? It's the ultimate PowerShell Wiki page, including videos, modules, and information about...

Get-WmiObject provides no IntelliSense for WMI classes, so you either need to know the WMI class name off hand, or use the parameter -List to search...

WMI can provide lots of information about a system, but sometimes it is just a bit too much. So when you query for logical disks, you often get back...

PowerShell 3.0 will auto-load modules as you have seen in a previous tip. However, with some modules, this technique may fail. Their cmdlets will...

Beginning with PowerShell 3.0, PowerShell is smart enough to know which cmdlets are exported by which extension module. So you no longer have to...

If you want to turn a Server 2012 (or Server 2008 R2) into a workstation machine and have it behave like Windows 8 (including the ability to burn...

Here is an easy way to get the MAC address, even from a remote machine: Simply replace the IP address with the one you are interested in. You may...

Once you pin PowerShell to your taskbar, you can always right-click the pinned PowerShell icon to open a jump list and launch PowerShell or the ISE...

Beginning in PowerShell 3.0, it is easy to monitor text-based log files in real-time. Try this: $Path = "$home\Desktop\testfile.txt"...

To get extensive help for all kinds of PowerShell operators in the PowerShell 3.0 ISE editor, first list all the different help topics about...

In the PowerShell ISE 4.0 command pane, when you hold CTRL, you can then use ArrowUp to move out of the command line into the results area. ReTweet...

LDAP queries are extremely powerful and can help find accounts that are missing information. This code would return all Active Directory users that...

Tired of inventing lame excuses yourself? Then here's a script that gets you a new excuse any time you call Get-Excuse! All you need is Internet...

PowerShell keeps a list of all commands you enter, but once you close PowerShell, the list is lost. Here is a simple one-liner that saves the...

To correctly capitalize words (making sure the first character is capitalized), you can either use regular expressions or a little system function....

PowerShell can access COM objects like Outlook Application. These two simple lines return the current Outlook profile: $outlookApplication =...

Beginning with PowerShell 4.0, method names may come from variables. Here's a simple example: $method = 'ToUpper'...

In PowerShell, you can use variables in place of properties. This sample script defines the four property names that return profile paths, then...

If you just need to replace characters anywhere in a text, you are easy off. This would capitalize every "l" in a text: "Hello...

Check out this code and try to find the problem: $desc = Get-Process -Id $pid | Select-Object -Property Description "PowerShell process...

Get-Service lists all services on a computer, but the information returned is very sparse. You cannot easily see what a service does, whether it is...

By default, Active Directory returns only the first 1000 search results when you use an ADSISearcher. This is a security mechanism designed to...

Beginning with PowerShell 4.0, a script author can decide to hide function parameters from IntelliSense. This way, less frequently used parameters...

The more specific your LDAP query is the faster and less resource intense the query is, and the more precise are the results as well. For example,...

If you know the SID and would like to find the corresponding Active Directory account, then LDAP queries won't work well. For them to work, you...