Browse by Tags

All Tags » PowerShell (RSS)

PowerShell and a bit of the Task Parallel Library as a replacement for SSIS

I gave a presentation at today’s SQL Saturday in NY on replacing SSIS with PowerShell. You can view the presentation , or see below for the two second summary: SSIS is a terrible development tool Many SSIS features can be built with out much effort with...

When Add(ing)-Type, choose your method signatures wisely

  Powershell V2 has some great new features, in particular Add-Type and Remoting features are likely to be quite popular and work together without much issue. That said, there are edge cases which illustrate how the types returned from remoting calls...
Posted by Scott Weinstein | 2 comment(s)
Filed under: , , ,

CPU Monitoring and Alerting via Performance counters, Coral8, and PowerShell

The PowerShell team has a short post on using V2 cmdlets to Monitor performance counters. Building on that, and the prior work with the PoShAdapter, here’s a sample with Coral8 and PowerShell to alert you via SMS when the rolling 30 seconds average CPU...
Posted by Scott Weinstein | with no comments
Filed under: , , ,

Using Coral8 and PowerShell to receive eventing data

I’ve updated the PowerShell Coral8 adapter so it can be used to receive input. Rather than demonstrate input from a database or an RSS stream, both of which can are supported by the native Coral8 adapters, I have a demo with WMI events. In this case allowing...
Posted by Scott Weinstein | 1 comment(s)
Filed under: , , ,

Stream transforms in Coral8 via .Net

In the first post on integrating PowerShell and Coral8 I showed how to create a message sink. In C#ish pseudocode we did the following: OutputStream<T> => Action<T> where the Action<T> was a PowerShell block to send a message via...
Posted by Scott Weinstein | 2 comment(s)
Filed under: , , , , ,

Automatic properties in PowerShell… and how you can almost have them for your custom types

For certain types, PowerShell has automatic properties, by this I mean PowerShell is able to inspect the object and then expose properties where normally you would need to use a string indexer. Like so: $xbooks = [xml]"<Books><Book><Title>PowerShell...
Posted by Scott Weinstein | 1 comment(s)
Filed under: ,

In-process PowerShell adapter for Coral8

A few days ago a thought crept into my head; wouldn’t it be nice if I could have a Coral8 in-process adapter to run PowerShell code? If it worked it could potentially be a “universal” adapter, limiting the need for custom one-off adapters. Coral8, out...
Posted by Scott Weinstein | 1 comment(s)
Filed under: , , , ,

Adding users to a distribution list, in bulk

If you've every had to add more then two users to a distribution list in outlook you know just how painful the modal dialogs can be. Doing it in bulk is easy, if you have the right tools (and assuming you are the owner or co-owner of the group). PowerShell...
Posted by Scott Weinstein | 3 comment(s)
Filed under: ,

Scheduling PowerShell tasks without a console window

Have you every wanted to use Windows Task Scheduler to run a PowerShell script on a frequent schedule, but hated how the console window would flash on the screen every time the script ran? Yeah, me too. Apparently the task scheduler API supports hiding...

Powershell provider for Coral8 - update and code release

I've released updates for the Coral8 PowerShell provider . Get the code and binary at http://code.google.com/p/coral8shell/ Two primary changes Pure C# - using PowerShell to do some of the heavy lifting around XML was somewhat fun to write, but it was...
Posted by Scott Weinstein | with no comments
Filed under: , , ,
More Posts Next page »