database-tools

In a previous tip we illustrated that ISE code snippets (press CTRL+J to view them) are plain ps1xml-files that you can manage in File Explorer. By...

By default, the PowerShell 3.0 ISE editor loads code snippets automatically, and you can then select and insert any of these by pressing CTRL+J....

The PowerShell 3.0 ISE editor ships with a number of default code snippets that you can see (and insert) by pressing CTRL+J. Once you start to...

In a previous tip, we showed how you can use New-IseSnippet to add new code snippets to the ISE editor in PowerShell 3.0. These custom snippets stay...

The new PowerShell 3.0 ISE editor features a snippet menu that lets you easily insert predefined code snippets. Simply press CTRL+J to open the...

Whenever you need to assign multi-line text to a variable, you can use so-called here-string. This is a sample: $myCodeSnippet=@' function...

PowerShell 3.0 ISE editor creates collapsible regions automatically, so you can collapse a function body or an IF statement. In addition, you can...

Sometimes you may just be interested in the last couple of entries in a log file. Here’s a simple yet fast way of outputting only the last x...

In a previous tip we illustrated how you can use web services to retrieve information such as public holidays or the location of an IP address....

Whenever a machine is connected to the Internet, it gets a public IP address (typically assigned by the ISP), and this public IP address is not...

In PowerShell 3.0, WPF is a great (and easy) way of creating GUIs. If you have a touch-enabled machine, check out how easily you can open a drawing...

Whenever you change a file, the file system automatically updates the LastWriteTime property. If you'd like to change a file without leaving...

Ed Wilson from the Scripting Guys demonstrated how PowerShell can use free web services to find out holidays. You do need direct (non-proxy)...

Aliases are shortcuts for commands and useful in interactive PowerShell. Once you write scripts, however, you should no longer use aliases and...

Ever wondered how a website knew which country you are from? That's because there are IP address segments assigned to certain regions. And...

Get-Process can easily return the CPU load for each running process, but this information by itself is not very useful: Get-Process | Select-Object...

PowerShell 3.0 uses .NET Framework 4.x so it has WPF (Windows Presentation Foundation) capabilities built-in. This way, it only takes a few lines of...

Often, when you start writing a PowerShell script, you use temporary (dirty) variable names that later you'd like to polish. Renaming script...

ISE 3.0 features automatic outlining, so structures like braces can be collapsed or expanded by clicking the small "+" or "-"...

PowerShell can automatically find and list all variables that you use in a script. This way, you can easily create variable documentation for your...

A lot of products come with their own PowerShell consoles. There are special PowerShell consoles for Exchange, for SQL Server, for Active Directory,...

ISE has a simple yet effective debugger built-in that you can use to step through your code. The debugger does require that you save your script...

In ISE 3.0, you can easily switch focus between the interactive console pane and the editor script pane by pressing CTRL+D (to go to the console)...