database-tools

Ordered hash tables are new in PowerShell 3.0 and great for creating new objects. Unlike regular hash tables, ordered hash tables keep the order in...

Getting relative dates (like yesterday or one week ahead) is easy once you know the Add…() methods every DateTime object supports. This would...

PowerShell is amazing. It will let you search YouTube videos for keywords you select, then offer the videos to you, and upon selection play the...

Windows 8.1 ships with a new module called "Defender". The cmdlets found inside enable you to manage, view and change all aspects of the...

Did you know that you can actually search for local user accounts, much like you can search for domain accounts? Here is an example code that...

In PowerShell, local accounts and groups can be managed in an object-oriented way thanks to .NET Framework 3.51 and above. This will list local...

Windows 8.1 still offers the old cmd.exe command window in some of its context menus. To change that and replace cmd.exe with powershell.exe, in...

Did you know that you can manage your Office365 accounts with PowerShell, too? Provided you have an Office365 account, try this: $OfficeSession =...

The environment variable $env:Path lists all paths that are included in the Windows search path when you launch an application. Likewise,...

To view disk partitioning information, use WMI: Get-WmiObject -Class Win32_DiskPartition | Select-Object -Property * Next, pick the properties you...

Scripting Active Directory does not necessarily require additional modules. With simple .NET Framework methods, you can achieve amazing things. In...

With WPF, PowerShell can create windows in just a couple of lines of code. Here's a funny example of a transparent screen overlay. You can call...

Here's a chunk of code that creates random passwords of different lengths for you: $length = 8 $characters = [Char[]]((31..50) + (65..90) +...

How can you securely embed confidential passwords in a PowerShell script? You can't. But you can make it harder for people to discover the...

To add a little glamour to your scripts, here are a few lines of code that display a folder selector dialog. When a user selects a folder, your...

Did you know that Group-Object can easily group elements by custom criteria? Here's a line that groups folders by their first three letters:...

Did you know that Windows maintains a list of all USB storage devices ever hooked up to your machine? And it's simple to dump that list: $Path =...

Ever needed a list of DLL files and their versions? Get-ChildItem can get this information for you. You just need to unpack some properties like so:...

In a domain environment, PowerShell remoting is working almost out of the box. All you might have to do is enable Remoting on target machines...

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...