In the previous tip we explained how you can use Select-String and a regular expression to extract valuable information from raw text results: PS...
database-tools
Parsing Raw Text (Part 1)
Sometimes, you may want to extract valuable information from pure text results. One easy way is the use of Select-String. This example extracts only...
Adjusting Simple UIs
In the previous tip you learned how you can use Show-Command to create simple UIs for text-based commands: #requires -Version 3.0 function...
Creating Simple UIs
Function and cmdlet parameters basically are the technique how PowerShell creates „user interfaces“. These text-based interfaces can...
Extending Robocopy
PowerShell can add value to existing commands such as robocopy. Take a look at the below function--it uses robocopy to copy files, and adds the...
Copy Color-Coded Code
When you select code in the PowerShell ISE and copy it to the clipboard, it is copied in RTF format and preserves all color coding and font...
Creating WinForms GUIs in PowerShell
While it is recommended to use the modern WPF technology to create PowerShell user interfaces, you might still want to occasionally use the older...
Run Book, Run!!!
How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains how to execute all your jobs and...
Using “Exit” to Communicate with Linux
When a PowerShell script ends, you can run the command “Exit” and submit a numeric value. This has been good practice in the Windows...
Capturing Linux Output
If you run PowerShell on Linux, you can combine Linux and PowerShell commands. To take the output of a Linux command and assign it to a PowerShell...
Test for File or Folder
Test-Path can check whether a file or folder exists. If you add -PathType and specify Leaf (for files) or Container (for folders), the result can be...
System Memory, Units, and Rounding
Sometimes, you’d like to use different units of measurements. The total system memory is reported in bytes, for example. Here are some...
How Do You Create a Disaster Recovery Plan?
Get 2017 on a healthy start and participate in our January #SQLChat! Our next Twitter Chat will take place Wednesday, January 11th at 11 AM CT with...
Creating Time Spans
You can use New-TimeSpan to define “amounts” of time, and then add or subtract them from dates. Here is an example: $1Day = New-TimeSpan...
RUM – Real User Monitoring & Optimization
Precise can show the real end-user experience from "click to disk" aka RUM | Real User Monitoring. Precise automatically injects (no...
Precise for SQL Server Findings Report | automatic problem identification with recommendations
Precise elevates the IT professional to the next level with automatic problem identification and recommendations. Precise detects everything in SQL...
Waiting for Processes to Exit
Sometimes, a PowerShell script needs to wait for external processes to finish. Here is what some users do: $processNameToWaitForExit =...
DB2 Monitoring and Optimization – Index Recommendations & Modeling
This blog post explores a strategy for improving processing efficiency within IBM’s DB2 on LUW. The Precise product line is designed for...
Using PowerShell Remoting with PIN-enabled Accounts
If you have set up a PIN to log into your computer, PowerShell remoting against your own machine may fail with a weird error message: PS C:\>...
Golden Nugget : Naming Standards Templates
Howdy! Today we will be exploring a feature called Naming Standards Template. In a Naming Standards Template you can define standards for...
Separating Results by Property Value
If you use PowerShell remoting to receive information from remote machines, you can use fan-out simply by specifying more than one computer name....
Analyzing Result Frequencies (without Wasting Memory)
Use Group-Object to group objects based on shared property values, but don’t forget to use –NoElement parameter to discard the actual objects and...
DB2 Monitoring Tools | Precise for DB2
The Precise product line brings its high resolution monitoring to DB2 with Precise for DB2. Precise alerts on availability, displays the top...
Finding Unapproved Verbs
Cmdlets and functions should use only approved verbs to make it easier on user to find commands, and improve consistency. Here is quick audit code...