Mike Wilbur's Blog

Powershell Template Engine

A template engine that allows you to have powershell expressions in your templates is a very powerful thing: http://weblogs.asp.net/soever/archive/2006/12/31/a-templating-engine-using-powershell-expressions.aspx Example Input: Multi Line Expression: [[

get-SHA256

Get the SHA256 hash in one line of powershell: function get-sha256 { param($file);[system.bitconverter]::tostring([System.Security.Cryptography.sha256]::create().computehash([system.io.file]::openread((resolve-path $file)))) -replace "-","" }

get-datatable.ps1

get-datatable.ps1 is an improvement on the get-dataset.ps1 from an earlier post . Instead of returning a dataset it returns a DataTable; and a UpdateSql method is added to the object returned, so you don't need a separate script to send the changes back

Managing Performance Counters via Command Line

When it comes to scripting the setup of performance counters Logman is your friend; and Relog comes in really handy for converting a binary log to SQL log.