Announcing the General Availability of IDERA SQL Compliance Manager 7.0

In a previous tip we illustrated how in PowerShell 3.0, you can now use validators to restrict the data that can be assigned to a variable. Here is another example. It assigns the data type "Int32" to a variable, so it only accepts numeric values. In...

In a previous tip we explained how you can enumerate who is connected to your machine via PowerShell Remoting, and how you can terminate individual remote shells. If you want to simply kill all remote PowerShell sessions running on your machine, you can restart the...

To kill a remote PowerShell session that runs on your machine, you could kill the wsmprovhost.exe task associated with it, but identifying the correct process and killing it is not a robust and recommended way. A better way uses this approach: $URI =...

Ever wanted to find out who is running a (hidden) remote PowerShell on your machine? Here's a simple one-liner: Get-WSManInstance -ConnectionURI ('http://{0}:5985/wsman' -f $env:computername) `-ResourceURI shell -Enumerate It will return anyone connecting...

When you assign a mandatory data type to a variable, then this will improve script robustness: whenever a value is (accidentally) assigned to that variable that does not match the expected type, an error is raised. In PowerShell 3.0, this concept can be further...

An often overlooked feature in PowerShell is the ability to make a function parameter both optional and mandatory - at the same time. Let's for example assume you want a function that has two parameters: ComputerName and Credential. Both should be optional, but if the...

When you use Windows Forms dialogs and windows, you may have noticed that they show differently, depending on whether you launched your script from within the ISE editor or from the powershell.exe console. This is because the ISE editor enables visual styles by...

PowerShell modules extend functionality by adding more cmdlets and/or providers. Modules support copy-and-paste deployment ("XCopy-deployment", if you like), so theoretically, you can copy any module from one computer to another and use it there (use...

PowerShell can validate parameters using regular expressions. This example accepts only computer names that start with "PC" followed by three digits: function Get-PCInfo { param ( [ValidatePattern( '^PC\d{3}$' )] [String] $ComputerName )...

Sometimes you may want to create a script block dynamically from a string. This could be necessary to include local variable content, for example. To turn a string into a script block, you cannot cast the string. Instead, use this approach: $folder =...

Script blocks are simply pieces of PowerShell code. You probably use them all the time in scripts and functions. A script block is defined by braces and could be as simple as this: $a = { Get-ChildItem C:\ } Now, the variable $a holds code that can be handed over to...

PowerShell can display custom dialogs easily. So if you're not satisfied with the dialog buttons available in a standard MsgBox dialog, simply create your own. Here's the raw code for a very simplistic two-button dialog that appears centered on screen above...

Ever needed to know the current screen resolution or related screen information? Here's an easy way of getting that information: Add-Type -AssemblyName System.Windows.Forms [System.Windows.Forms.Screen]::AllScreens [System.Windows.Forms.Screen]::PrimaryScreen Note...

Adam Driscoll, another PowerShell MVP, has published a function called Get-MemberBody to PoshCode: http://poshcode.org/4127. In conjunction with the free tool "ILSpy", you now can easily disassemble and look at source codes for .NET functions. After you...

Whenever you want PowerShell to configure or execute code automatically on launch, the code needs to go into one of four profile scripts. They really work pretty much like autoexec.bat for Windows in old days, and execute whenever PowerShell starts. You can find the...

Here is a snippet that verifies a local user account. Simply submit a username and a password. You get back either $true or $false: $username = 'Administrator' $password = 'P@ssw0rd' $computer = $env:COMPUTERNAME Add-Type -AssemblyName...

In a previous tip we talked about using PowerShell Remoting to execute code on a remote machine, and how to use "using:" to carry over local variables to the remotely executed script. However, this only works in PowerShell 3.0. If you must still use...