The recording, slides and demo scripts from tonight’s PowerShell and SQL Server session are available as a single zip file for download from
The UK PowerShell group presents a Live Meeting tomorrow on using PowerShell with SQL Server
Tripped over an interesting problem
I want to use the [wmiclass] accelerator because I need to find the key of a WMI class (code borrowed from PowerShell team blog – to be returned when I’ve finished with it)
$t = [WMIClass]$class
Last time we looked at BITS we saw how to transfer a single file. The example in the help file doesn’t work in my environment so this is what I came up with as a work around
An interesting question came up recently. A Powershell user was trying to access an AD attribute so they did something like this
$x = Get-ADUser -Identity usera -Properties * | select useraccountcontrol
When they tried to use $x it didn’t correctly in the rest of...
As well as looking at WMI I thought it was time to branch out a bit and look at other functionality that could administrators The BITS (Background Intelligent Transfer Service) service is used for file transfer. Its normally thought of as being used across the internet but it can also be used...
I stumbled on this class
The useful output is
SettingID : Microsoft...
First reminder for the UG meeting on 28February – PowerShell and SQL Server
I was recently left a comment of a post