database-tools

With PowerShell, it can be a piece of cake to read out Registry values. Here is your simple code template: $RegPath =...

When you want to use error handlers with errors that occur inside a cmdlet, then you can only catch such exceptions when you set the -ErrorAction of...

You can use the -split operator to easily split a path in its components. The result is always an array. Simply use comparison operators to exclude...

Maybe you'd like to be able to occasionally skip certain parts of your profile script. For example, in the ISE editor, simply add this...

You probably know that PowerShell supports profile scripts. Simply make sure the file found in $profile exists. It's a plain script that gets...

There are plenty of low level system functions that PowerShell can use. This one, for example, creates a temporary file name:...

Let's assume you have a bunch of scripts (or pictures or log files or whatever) in a folder, and you'd like to rename all files. The new file name...

If you'd like to reorganize your picture archive, then here is a piece of code that reads the "DateTaken" information from picture...

Most software registers itself in the Registry. Here is a piece of code that reads all installed software from the 32-bit and 64-bit hive and works...

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