database-tools

Challenge Accepted

My life for the last 2 years has been a constant battle of putting out fires with system performance; finally user complaints have moved getting...

Saving PowerShell User Defaults

We are about to enter “Color Week” with plenty of tips how you can choose better colors for the PowerShell ISE editor and the console....

Finding ASCII Codes

Here is an easy way to find the ASCII code for any character you may have scraped from a website, or found in a script that you copied from the...

Enabling Remote Administration

PowerShell 2+ Many older DCOM-based commands require a “Remote Administration Firewall Exception” to access remote systems. This...

Finding Auto Starts

PowerShell 3+ If you’d like to know which programs start automatically on your machine, WMI may help: PS C:\> Get-CimInstance -ClassName...

Replacing CSV File Headers

PowerShell 2+ When you read in CSV data and would like to rename the CSV headers, here is a simple approach: just read in the text line by line, and...

Receiving Input via Pipeline

In the previous tip we illustrated how Convert-Umlaut was able to convert special characters in a string. This becomes even more useful if a...

The Role of DBA in Data Protection

IDERA recently released a Database Management Report Survey with interesting industry trends such as “nearly 90% of enterprise IT respondents...

Using Friendly Robocopy

PowerShell 2+ Robocopy is a tool of choice to copy files, and that does not change with PowerShell. You can, however, use PowerShell to embed...

Beware of Changes to PSModulePath

PowerShell 3+ PowerShell examines the $env:PSModulePath environment variable to find out the locations where it searches for extension modules. A...

The Truth About WinRM

PowerShell 3+ The popular winrm command to manage and configure PowerShell Remoting is really just a batch and a VBS file: PS> Get-Command winrm...

Listening to Music in the Background

PowerShell 3+ In the previous tip we presented to you a “Dancing Rick ASCII”, created by Lee Holmes. Lee uses music stored on his server...

Smuggling In PowerShell Code

PowerShell 2 There is a good reason why Invoke-Expression is considered risky. This cmdlet executes whatever string it gets, and attackers can...

This Idera ACE Has Been Busy

This year has been a whirlwind so far, thanks to the Idera ACE program. For those that don’t know what that is … What is an Idera ACE? (According to...

Display Windows

PowerShell 3+ It is fairly easy to use WPF (Windows Presentation Foundation) to create and show simple dialog windows in PowerShell. If you’d...

1 78 79 80 81 82 159