PowerShell can use UIAutomation calls to find out useful UI information about any process. You can find out whether a process accepts keyboard...
database-tools
Compressing to ZIP Files
In PowerShell 5.0, Compress-Archive can easily compress files and folders to a ZIP file: PS C:\> Compress-Archive -Path c:\sourcefolder...
Quickly Scanning for Malware
If you have Windows Defender installed on your machine, you can use this PowerShell command to run a quick scan on a drive of your choice: PS>...
Enabling Telnet Client and Watching Star Wars
By default, the Telnet client is disabled on Windows systems. You can easily enable it with a one liner in PowerShell, though. Just launch a...
Enabling PowerShell Remoting with NTLM
By default, PowerShell remoting uses Kerberos authentication and works only in domain environments, and only when you specify computer names, not IP...
February #SQLChat – “Automating Your Environment”
It’s that time again! IDERA’s next Twitter Chat will be held on Wednesday, February 17 from 11 AM to 12 PM (CST). This chat will revolve around...
Validate Read-Host Input
Beginning in PowerShell 4.0, you can use validators for variable assignments. This gives you a quick and easy way of validating user input, too. The...
Embarcadero and the Object/Relational Mismatch – by Robin Bloor
The introduction of object-oriented (OO) programming languages provoked an unfortunate schism in the world of software development. Relational...
January #SQLChat Wrap-Up
A new year means new beginnings! And, what a better way to celebrate than with a Twitter Chat centered around SQL Server and starting a new job....
Restore PowerShell ISE Defaults
To restore custom settings in PowerShell ISE to factory defaults, try running these lines: $PSise.Options.RestoreDefaults()...
Fixing Remoting Bug
Have you ever tried to enable PowerShell remoting with Enable-PSRemoting, and just got an error complaining about not being able to check the...
Refreshing Icon Cache
Sometimes, Windows Explorer does not show correct icons. When you update to PowerShell 5.0, for example, both PowerShell and PowerShell ISE got new...
Cost Threshold and Max Degree of Parallelism
SQL Server has many options for configuring a database system. Most do not become apparent until some part of the system does not function...
Formatting Text Output
If you need to return multiple items in a nicely formatted text report, here is a simple trick: get yourself an ordered hash table (supported in...
Pinging Multiple Systems Fast
Test-Connection can ping multiple computers only sequentially, and it does not let you specify a timeout. So when you need to check a large number...
Test-Connection with Timeout
The Test-Connection cmdlet implements a simple ping to check whether a system responds to an ICMP request. Unfortunately, you cannot specify a...
Correct Encoding with PowerShell Remoting
When you run a native console command via PowerShell remoting, special characters like German Umlauts will be damaged because remoting uses a rather...
Finding Current File System Path
PowerShell supports not just the file system, so you can set the current path to a different provider (Set-Location). Here is a trick that always...
Creating New Objects by Hash Table Conversion
Beginning in PowerShell 3.0, you can create pre-initialized objects by using a hash table. Simply add the properties you want to preinitialize, then...
Use Get-CimInstance with DCOM
PowerShell 3.0 added an alternative to Get-WmiObject: Get-CimInstance seems to work very similar and can retrieve information from the internal WMI...
Loading a Base64-encoded Picture into WPF Window
In a previous tip we illustrated how you can convert any picture into a Base64-encoded string. Today, we'd like to show how you can load a...
National Rubber Ducky Day
What does IDERA love as much as our customers? Rubber Ducks! National Rubber Ducky Day is Wednesday, January 13. To help celebrate this holiday we...
Encoding Pictures
If your script needs resources such as icons or pictures, you do not have to ship these resources separately. They can be Base64-encoded and added...
Encode and Decode Text as Base64
Here is a simple way to encode text as a Base64 string: #requires -Version 1 $text = 'Hello World!'...