database-tools Archives

Accessing Windows Credential Manager

If you need to access credentials (saved passwords) stored by the Windows Credential Manager, the “CredentialManager” module may be helpful for you....

Using HTML to create PDF Reports (Part 3)

by ps1

HTML can be a simple way of formatting data for output reports. In this last part we illustrate how you convert the final HTML report to PDF...

Using HTML to create PDF Reports (Part 2)

by ps1

HTML can be a simple way of formatting data for output reports. In this second part we illustrate how you convert properties that contain arrays to...

Using HTML to create PDF Reports (Part 1)

by ps1

HTML can be a simple way of formatting data for output reports. In this 3-part series, we first illustrate how you compose HTML reports, then show a...

Announcing the General Availability of SQL Workload Analysis 1.7.1

by David Owen

We’re excited to announce the release of SQL Workload Analysis 1.7.1 Problematic SQL queries can severely reduce the performance of SQL...

SQL Diagnostic Manager 12.0 General Availability

by Scott Stone

We are pleased to announce the general availability of SQL Diagnostic Manager 12.0. Existing users may upgrade to this version through the Idera...

Take Advantage of Your Profile

by ps1

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

by ps1

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)

by ps1

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)

by ps1

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)

by ps1

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

by ps1

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)

by ps1

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)

by ps1

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)

by ps1

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

by Lisa

IDERA’s DB PowerStudio provides a powerful cross-platform toolset for database development, tuning and database management. What's new in DB...

Outputting Color

by ps1

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)

by ps1

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)

by ps1

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)

by ps1

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)

by ps1

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...