database-tools

In PowerShell 5.0, there is a new cmdlet that can unzip ZIP files: #requires -Version 5 $Source = 'C:\somezipfile.zip' $Destination =...

In a previous tip we showed how you can test the network port of a computer. When you have installed the free RSAT tools from Microsoft, you could...

To see whether you can access a remote computer via a given network port, here is a test function called Test-Port; it takes a remote computer name...

In a previous tip we explained how you find the physically logged on user. In this tip you will see how you can list the current logon sessions,...

There can always be only one physically logged on user on a machine. The physically logged on user is the one sitting right at the machine. Here is...

In a previous tip we explained how you can construct the connection string to a SQL database. Whether you use this to create the connection string,...

If you’d like to contact an SQL Server database via PowerShell, you need a connection string. The connection string contains all pieces of...

If you have installed the free RSAT tools from Microsoft, you can use PowerShell to update information stored in your AD user account, for example...

If you’d like to add custom attributes to an AD object, simply use a hash table, and add the desired attribute names and their values. Then...

Whenever you add delegation rights to an AD object (i.e. allow a user to manage the members of an organizational unit), you really invoke a change...

The built-in PowerShell ISE editor that ships with PowerShell 3.0 or better can be customized, and you can add your own menu items. When you run the...

Provided you have downloaded and installed Microsoft’s free RSAT tools, managing AD groups and group members is very simple. Here are some...

To access the full PowerShell help, you first need to download help information from the Internet. Simply launch a PowerShell console with full...

To safely use temporary AD accounts, for example for guests or consultants, always make sure to set an expiration date. Here is some sample code...

By default, AD objects are protected from accidental deletion. To remove this protection for all objects in a given scope (i.e. all objects in an...

When you download the free RSAT tools from Microsoft, these include the ActiveDirectory module. It contains a rich set of cmdlets to manage Active...

To access local user accounts and assign a new password, you can use the low-level WinNT: namespace. Note: you do need Administrator privileges to...

There are many ways to encrypt text. Here is an approach that does not use an explicit “secret”. Instead, the secret is defined as your...