database-tools

To run gpupdate.exe remotely, you could use a script like this: function Start-GPUpdate { param ( [String[]] $ComputerName ) $code = { $rv = 1 |...

Have you ever been puzzled just what the connection string would look like for a given database? When you create a new data source in Control Panel,...

Splatting is a great way of forwarding parameters to another cmdlet. Here is an example that can be used to encapsulate WMI calls and make them...

Splatting was introduced in PowerShell 3.0, but many users still never heard of this. It is a technique to programmatically submit parameters to a...

If you need to find out the Active Directory groups your user account is in, typically you would query the Active Directory, and you would have to...

Setting permissions for Registry keys isn't trivial. With a little trick, though, it is no big deal anymore. First, open REGEDIT and create a...

If you know that your script requires Administrator privileges, then you should add this to the top of your script: #requires -runasadministrator...

Maybe you need to remove some permission settings from NTFS permissions. Let's assume you want to remove all permissions for a specific user...

Before you can run a PowerShell script, the execution policy needs to allow this. Typically, you would use this line to enable script execution:...

To check all installed updates on a Windows box, there is a COM library you can use. Unfortunately, this library isn't very intuitive to use,...

There are two great sources for PowerShell cheat sheets. One is the set of cheat sheets created by powershellmagazine.com which was just updated to...

Desired State Configuration (DSC) is a new feature in PowerShell 4.0. With DSC, you can write simple configuration scripts and apply them to the...

PowerShell functions can mimick all the features found in a true binary cmdlet--but PowerShell functions are plain PowerShell code, so anyone can...

Whether you want to add a new NTFS access rule to a file or turn off inheritance and add new rules, here is a sample script that illustrates the...

Occasionally, text from a text file needs to be read and processed by other commands. Typically, you would use Get-Content to read the text file...

There is an obscure bug in the PowerShell ISE that may dead-lock the debugger. It affects PowerShell version 3.0 and 4.0. Here is a test script:...

Occasionally, it may become necessary to bulk rename object properties to create better reports. For example, if you retrieve process objects, you...

When you send information to Microsoft Excel, it is converted to text using the built-in .NET ToString() method. This method typically does not...

PowerShell objects can easily be opened in Microsoft Excel. Simply export the objects to CSV, then open the CSV file with the associated program...

By default, any object created from JSON uses String as a data type: $json = @" { "Name": "Weltner", "ID" :...

JSON is describing objects, similar to XML--but a lot easier. JSON allows for nested object properties, so you can retrieve information from various...

If you define variables in a function, then these variables live in function scope. To find out what the value of the variable is in the parent...

Windows 8.1 comes with a ton of new cmdlets. One of them can automatically download and install the latest antivirus signatures for Windows...

Occasionally, the only way of automating processes is to send keystrokes or mouse clicks to UI elements. A good and free PowerShell extension is...

WPF (Windows Presentation Foundation) is a technology that enables you to create windows and dialogs. The advantage of WPF is that the window design...

Of course you can send emails directly via SMTP server using Send-MailMessage. But if you want to prefill an email form in your default MAPI client,...