Today I needed to get a PowerShell script scheduled as a task in SQL Agent for SQL Server 2005. SQL 2008 natively supports running PowerShell, but all 2005 can do is run either T-SQL or CmdExec.
My first approach was to copy the path of the PowerShell executable from the start menu shortcut - "%SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe"
That refused to work giving a really helpful "The step failed" error message.
Trying a few variations I eventually figured out that CmdExec does not expand environment variables. So either rely on the fact that PowerShell.exe is probably in the path, or specify the full path. My working version is:
c:\windows\system32\WindowsPowerShell\v1.0\powershell.exe -file "c:\tmp\test1.ps1" -ExecutionPolicy Unrestricted
If you need PowerShell to talk to Analysis Services, then Darren Gosbell's powerSSAS (with versions for SSAS 2005 and 2008) might be useful too.
Some updates on options for online backup of Windows Home Server
- For a brief period it looked like Mozy would be releasing a WHS client but that turns out not to be the case. I'd let my free trial with KeepVault lapse in anticipation of the Mozy product being released. Oh well :-(
- Found Backblaze - ($US5/month unlimited) but doubt they work with WHS. Casey from the Backblaze team responded to an email query saying "..don't have any plans for supporting Server OS like Windows Home Server"
- Others have recommended CrashPlan, and certainly their prices are competitive with Mozy and Carbonite. Whilst it isn't officially supported with WHS, at least it gets a mention on their support site. Poster "Scott" goes into more detail on how he got it working with WHS.
Last night the Adelaide SQL Server User Group had Adam Cogan visit us from Sydney to talk about Microsoft PerformancePoint 2010. Adam is Chief Architect of SSW, a Microsoft Regional Director and a Microsoft MVP (Visual Studio Team System).
Usually the meetings are at lunchtime, but the group were asked to move to the evening timeslot this month (something about a Windows Phone 7 series talk). The other difference was that we got KFC supplied for supper.
Adam stepped through the features of PerformancePoint 2010 and showed some of the new additions. Probably the most significant is that it ceases to be a separate (expensive) product and now will ship as part of SharePoint Server 2010.
It was an entertaining evening, with a lively discussion between Adam and the audience. At the end of the night I think it's fair to say we'd all learned a lot (even Adam!)
Adam thought readers might find these resources useful:
How do you combine exercise, family and consulting work?
I'm trying to figure out how I can squeeze in the occasional ride to work, whilst still retaining that degree of separation that is appropriate as a consultant (eg. not using client's shower facilities!)
My requirements are relatively simple. Somewhere to:
- securely to store my bike
- shower and change
- leave bike clothes/towel to dry
Rob had a good suggestion of checking out local gyms in the Adelaide CBD – maybe they might offer a cheap "change facilities only" membership deal. I read that Melbourne now have a dedicated "Bike Pod" for their cyclists to use. Wouldn't it be great if Adelaide had something similar!
I'd be interested to hear of other suggestions and/or solutions.
Whilst I do like the idea of a "LobsterPot Solutions" branded bike top and knicks (the red claw would be very eye catching!) I'm not sure that our clients would be happy with me wearing that around the office all day :-)