Out-GridView always produces a table with one object per line: Get-Process -Id $pid | Out-GridView Occasionally, it would be more helpful to display...
database-tools
Converting Information to Culture-Specific Text
If you’d like to format information to given culture standards, this is really simple by using ToString() and the appropriate target...
Converting Culture-Specific Information
Let’s assume you received data like numbers or date as text. Whenever information is reduced to text, you are challenged with culture-specific...
Diversity within Tech – Community Findings
Diversity is a huge topic of discussion, especially as of late. Rie Irish (@IrishSQL) partnered with the PASS Women in Technology (WIT) Virtual...
Understanding Text Conversions
There are many different ways how objects can be transformed into text. In case you sometimes get confused, here is a quick refresher. Take a look:...
Allowing PowerShell Script Execution – No Matter What
Execution policy can prevent scripts from running. It is designed to be a user preference setting, so you should always be able to change the...
Multi-Application Health measured by Real User Experience
Precise offers the ability to assess application health by transaction SLA compliance and availability. When a problem is detected, Precise...
Comparing String Lists
In a previous example we used HashSets to compare numeric lists, and find out which elements were found in both list, or in just one list. The same...
Monitoring RDS MySQL Performance Metrics
Amazon Web Services (AWS) is a cloud platform that offers a wide variety of services including computing power, database storage, content delivery...
Looking towards 2018 – GDPR Impact
As 2018 quickly approaches, we have a good opportunity to look towards the future. GDPR will go into effect in May and with it we should see...
Comparing Numeric Lists
Often a script needs to find out whether two lists are the same, or which elements are missing from a list. Instead of investing much programming...
Tagging Objects Efficiently
Occasionally you see scripts that use Select-Object to append information to existing objects. This can look similar to the code below: Get-Process...
Creating New Objects Efficiently
Download and Complete our SQL Server Crossword!
This fun puzzle, created by Kenneth Fisher, is primarily focused on SQL Server but also includes some IDERA terms. Up for the challenge? Download...
Adding Single Line Comments in PowerShell ISE
In the previous tip we looked at command extensions for the good old PowerShell ISE. Here is another sample that adds the CTRL+K keyboard shortcut...
Alert Configuration Templates in SQL Diagnostic Manager
Several versions ago, SQL Diagnostic Manager (SQLDM) introduced Alert Configuration Templates, which basically allowed users to preconfigure alert...
Toggling Comments in PowerShell ISE
The good old PowerShell ISE exposes some expandability connectors. If you’d like to toggle comments in selected text by pressing CTRL+K, for...
Converting Hash Tables to JSON
In previous scripts we worked a lot with hash tables, and even loaded them from .psd1 files. If you need the data in a different format, for example...
Reading Data from .PSD1 Files in PowerShell 5+
In a previous tip we introduced Import-LocalizedData to read in data stored in a .psd1 file. Starting in PowerShell 5, there is a new cmdlet named...
Reading Data from .PSD1 Files
There are many ways how a script can store data information. One is especially convenient. Here is the code: Import-LocalizedData -BaseDirectory...
Webinar Highlights: What’s New in Monyog & Roadmap Update
Thank you everyone who attended our webinar on “What’s new in Monyog & Roadmap update”. In this webinar, Shree Nair, Product Manager at Webyog...
Understanding .NET Type Name Variants in PowerShell
PowerShell can use .NET type names, for example to convert values to a given type. Frequently, scripts use a variety of formats to define .NET...
Minimalistic Error Handling
Error handling does not necessarily have to be complex. It can be as simple as checking whether the last command executed successfully: # suppress...
December #SQLChat – A Discussion on Diversity in Tech with WIT
A lot of emphasis has been placed on diversity in tech of late, with good reason. Research has shown that a more diverse team finds more innovative...