QuickTip: Comparing installed HotFixes on a two node Cluster

January 12, 2011

We had a Risk and Health Assessment Program (RAP) for SQL Server running in our environment in the last few days and one of the issues in the final report was:   My PowerShell "wheels" started to roll and I suggested our team have a script to check for such inconsistences. So, here's how we can perform a quick check against a two node cluster (or any other pair of computers) using PowerShell and find if the installed hotfixes are not identical. First we use the Get-HotFix cmdlet to retrieve the list of...

HP BladeSystem PowerShell cmdlets

January 6, 2011

In the last few days I was working with Artur Zurawicz (this guy rocks!), Microsoft OpsMgr PFE, on our OpsMgr server. We had a discussion regarding PowerShell and while we were working with the shell I executed the Get-PSSnapin cmdlet and was very intrigued by the output:   For quite some time I have been searching for PowerShell cmdlets for HP blades and couldn't find one , and there it was, right here under my nose! I knew we had the HP BladeSystem Management pack installed but never knew it uses PowerShell scripts to monitor...

Expanding Strings And Environment Variables in PowerShell

January 2, 2011

In PowerShell, when you enclose a string that contains variables (preceded by a dollar sign) in double quotation marks, the variables are replaced with the variable's value. For example: PS > $i = 5 PS > "The value of $i is $i." The value of 5 is 5. When the string is enclosed a string in single-quotation marks, the string is passed as is, no substitution is performed. PS > 'The value of $i is $i.' The value of $i is $i   What...