database-tools

There are plenty of free webservices around, and provided you have direct Internet access (no proxy), you can use New-WebServiceProxy to access...

Let's assume you want to set up a restricted PowerShell v3 console that just provides access to Microsoft cmdlets with the verb Get. One way to...

Beginning with Server 2008 R2, there is a PowerShell module called ServerManager that you can use to manage server features and optional components....

Finding printers that have been published in your Active Directory becomes trivial with Windows 8 or Server 2012. PS> Get-Printer -ComputerName...

Calculating time differences is easy - provided you can convert the date and time information into a DateTime type. If the date is in a custom...

To get the average total CPU load for your local system or a remote system, use Get-Counter. The example below returns the average total CPU load...

It can be very useful to call WMI methods, for example to create new shares, but in PowerShell v2 you had to know the names and exact order of...

It may be useful to automatically and temporarily switch to a "high performance" power plan from inside a script. Maybe you know that a...

There is a somewhat hidden WMI namespace that holds WMI classes you can use to manage power plans. The code below lists all power plans on your...

Using the new CIM cmdlets in PowerShell v3, you can run remote WMI queries against multiple computers using multiple remoting protocols. The sample...

In PowerShell v3, you can use a new simplified syntax for Where-Object. Both lines below list all files in your Windows folder that are larger than...

Leading "0" in IP addresses can cause confusion because many network commands interpret octets with leading "0" as octal...

The new CIM cmdlets require PowerShell v3, but you can still remotely target older boxes without PowerShell v3 or PowerShell at all. By default, CIM...

In PowerShell v3, to work with WMI you can still use the old WMI cmdlets like Get-WmiObject. There is a new set of CIM cmdlets, though, that pretty...

You can use WMI to quickly find all details about your mouse and keyboard: PS> Get-WmiObject win32_PointingDevice | Where-Object { $_.Description...

In a previous tip we featured a piece of undocumented code that works in PowerShell v3 to list all built-in variables. Here is another approach that...

If you must make sure that a text has a fixed length and is neither shorter nor longer, here is the code to pad and cut the text to the desired...

Finding Built-In Variables...

In a previous tip you learned how to load additional .NET assemblies. This enables you to display dialog boxes like a MsgBox, pretty much like in...

When you want to load additional .NET assemblies to extend the types of object you can use, there are two ways of loading them: the direct .NET...

To spice up your scripts, PowerShell can use the system open file dialog, so users could easily select files to open or to parse. Here's the...