We are pleased to announce the general availability of SQL Diagnostic Manager 12.0. Existing users may upgrade to this version through the Idera...
SQL Diagnostic Manager 12.0 General Availability
read more
database-tools
Take Advantage of Your Profile
When PowerShell launches, it automatically looks for a special autostart script. It does not exist by default and is different for each PowerShell...
Beware of -match
The -match operator is frequently used in scripts however not everyone seems to understand how it really works. It can be a really dangerous filter...
Avoid Add-Member (Part 3)
In the previous tip we looked at a number of clever alternatives to avoid Add-Member when creating your own new objects. While using hash tables to...
Avoid Add-Member (Part 2)
In the previous tip we looked at creating simple data objects, and it became evident that instead of using Add-Member, you can cast a hash table to...
Avoid Add-Member (Part 1)
Often the cmdlet Add-Member is used to create simple objects like this: $user = New-Object -TypeName psobject | Add-Member -MemberType NoteProperty...
Important Keyboard Shortcuts
Two of the most important keyboard shortcuts in any PowerShell environment – whether console, ISE, or VSCode – are TAB and CTRL+SPACE. TAB triggers...
Using Sysinternals Console Tools via PowerShell (Part 4)
In our previous tips we showed how you can use PowerShell to download, unblock, unzip and then run the Sysinternals console tools from...
Using Sysinternals Console Tools via PowerShell (Part 3)
In our previous tips we showed how you can use PowerShell to download, unblock, unzip and then run the Sysinternals console tools from PowerShell....
Using Sysinternals Console Tools via PowerShell (Part 2)
In our previous tip we used PowerShell to download and set up the Sysinternals suite of console commands. Here is what we did: $destinationZipPath =...
Announcing General Availability of DB PowerStudio, version 18.2
IDERA’s DB PowerStudio provides a powerful cross-platform toolset for database development, tuning and database management. What's new in DB...
Outputting Color
Occasionally, PowerShell code is supposed to output warnings and reports, so colors can add more readability to it. Traditionally, PowerShell...
Better PowerShell Prompts (Part 2)
In the previous tip we illustrated how you can define your own “prompt” function to customize the PowerShell prompt. One useful item could be to...
Better PowerShell Prompts (Part 1)
I know today’s tip isn’t brand new but considering how many people start using PowerShell, it’s worth mentioning again. By default, the PowerShell...
Reading Recently Installed Software (Improvement #3)
When reading event log data with Get-WinEvent, in the previous tip we explained how you can use the “Properties” property to extract the...
Reading Recently Installed Software (Improvement #2)
In the previous tip we used Get-WinEvent to read the Windows event log system and get a list of recently installed software, then used Select-Object...
Reading Recently Installed Software (Improvement #1)
In the previous tip we used Get-WinEvent to read the Windows event log system and get a list of recently installed software, similar to this:...
Reading Recently Installed Software
The MSI installer logs all successful software installation to the Windows event log system. Here is a one-liner that can read back that...
Gathering Forensic Process Info
In order to better understand the processes that run on a server, and possibly identify traces of unwanted processes, PowerShell can dump forensic...
Announcing General Availability of SQL Inventory Manager 2.6.3
We’re excited to announce the release of SQL Inventory Manager 2.6.3 Database administrators need a simple, efficient way to discover,...
Announcing the GA of SQL Enterprise Job Manager 2.4
We’re excited to announce the release of SQL Enterprise Job Manager 2.4 SQL Enterprise Job Manager is an industry leading monitoring, scheduling and...
Announcing the General Availability of SQL Secure 4.1
We are pleased to announce the general availability of SQL Secure 4.1 SQL Secure is the industry-leading, state of the art auditing and security...
Logging Variable Types
As part of your debugging and quality control you may want to log the data that gets assigned to individual variables. For example, you may want to...
Converting Language IDs in Language Names
In our previous mini series we showed different approaches to get to the names of installed OS languages using different PowerShell methods. The...