database-tools

Changing PowerShell Priority

All PowerShell versions Maybe you’d like a PowerShell script to work in the background, for example copy some files, but you do not want the...

Reading In PFX-Certificate

All PowerShell versions When you use Get-PfxCertificate, you can read in PFX certificate files and use the certificate to sign scripts. However, the...

Accessing SQLServer Database

All Versions, SQL Server You are running an SQL Server? Then here is a PowerShell script template you could use to run an SQL query and retrieve the...

Creating Colorful HTML Reports

All PowerShell versions To turn results into colorful custom HTML reports, simply define three script blocks: one that writes the start of the HTML...

Controlling Execution of Executables

All PowerShell versions PowerShell treats executables (files with extension EXE) like any other command. You can, however, make sure that PowerShell...

Faking Object Type

PowerShell 3 and later The internal PowerShell ETS is responsible for converting objects to text. To do this, it looks for a property called...

Metadata Integration

The operational culture of the enterprise has gradually shifted towards a more business-centric model, one where business users and front line...

Reading System Logs from File

All PowerShell Versions Sometimes, you may have to evaluate system log files that have been exported to disk, or you want to read a system log file...

WMI Search Tool

All PowerShell Versions WMI is a great and powerful technique: simply specify a WMI class name, and back you get all the instances of that class:...

List All Information

All PowerShell Versions Most of the time, PowerShell will not show you the complete results that you get from cmdlets. Instead, PowerShell limits...

Getting US ZIP Codes

All PowerShell Versions Ever wanted to find out the ZIP code of a city, or vice versa find out the city that belongs to a ZIP code? Then simply ask...

Reading Registry Values with Type

All PowerShell Versions Reading all registry values is simple when you do not need the data type: simply use Get-ItemProperty: Get-ItemProperty...

Finding Files plus Errors

All PowerShell Versions When you use Get-ChildItem to recursively search directory paths for files, you may stumble across subfolders where you do...