Powershell White Paper

June 14, 2009 at 7:14 am (PowerShell, SQLServerPedia Syndication) (, )

Allen White, who introduced me to the wonders of PowerShell at last year’s PASS Summit, has published a white paper on using PowerShell within SQL Server 2008 with Microsoft. This is great news. If you’re, as Brent Ozar so nicely put it, a noob like me in working with Powershell, this is going to be a great resource.

Congratulations Allen, and thanks.


  1. brento said,

    I used that as a term of endearment, by the way. ;-)

  2. scarydba said,

    I teese. I am a noob, especially around PowerShell.

  3. Steve said,

    Excellent write up. Do you know of an easy way to script out all the jobs using powershell into a file?


  4. scarydba said,

    From SQL Agent? I haven’t done it, no, but it shouldn’t be too difficult to walk the Jobs collection and output to a string or a table with calls to SMO.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: