database-tools

All PowerShell versions Try and avoid Invoke-Expression in your scripts. This cmdlet takes a string and executes it as if it was a command. In most...

All PowerShell Versions In the PowerShell console (not the PowerShell ISE), you can open a list with the last commands you entered, simply by...

All PowerShell versions To programmatically load a certificate from a file and install it in a specific location inside the certificate store, have...

All PowerShell versions To print a text-based file with the Notepad, try using this line (replace the path to the text file with some path that is...

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

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

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

All PowerShell versions PowerShell can be restricted in many ways. One is to set the language mode from “FullLanguage” to...

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

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