PowerShell for Data Professionals

• PowerShell 2.0 brings a lot of functionality to help you automate interaction with you servers.

• 2.0 itself brings a script editor that was missing. Apparently ripped off from VS 2010 *(in a good way)

Why PowerShell

• PowerShell bring one huge thing to the table (for me): The Pipeline

• Technically the whole ‘relies on the .Net Framework’ thing is pretty big too but for me…

• The second biggest thing is the insainely generous community

PowerShell Bolt-Ons

• In addition to the out of the box PowerShell features there are some ‘expansion packs’ in the form of Snap-Ins.

• The Snap-Ins for SQL Server are SqlServerCmdletSnapin100 SqlServerProviderSnapin100

PowerShell Has Friends

• Here is just a short list of a few products• Idera’s PowerShell Plus• Quest’s PowerGui.org• Saipien’s Primal Script

Application Version Cmdlets Provider Management GUI

Exchange Server 2007 402 Yes Yes

Windows Server 2008 Yes Yes No

Microsoft SQL Server 2008 Yes Yes No

System Center Operations Manager

2007 74 Yes No

System Center Virtual Machine Manager

2007 Yes Yes Yes

System Center Data Protection Manager

2007 Yes No No

Windows Compute Cluster Server

2007 Yes Yes No

Microsoft Transporter Suite for Lotus Domino[37]

08.02.0012 47 No No

Microsoft PowerTools for Open XML[38] 1.0 33 No No

List obtained from Wikipedia

IBM WebSphere MQ[39] 6.0.2.2 44 No No

Quest Management Shell for Active Directory[40]

1.1 40 No No

Special Operations Software Specops Command[41]

1.0 Yes No Yes

VMware Infrastructure Toolkit[42]

1.5 157 No No

Internet Information Services[43]

7.0 54 Yes No

Ensim Unify Enterprise Edition[44]

1.6 Yes No Yes

Windows 7 Troubleshooting Center[45]

6.1 Yes No Yes

Microsoft Deployment Toolkit

2010 Yes No No

Helpful Blogs

• http://blogs.technet.com/HeyScriptingGuy/• http://blogs.msdn.com/powershell/• http://blogs.msdn.com/powershell/• http://chadwickmiller.spaces.live.com/

• http://sqlblog.com/blogs/allen_white/

Books!• Best book on using

PowerShell for SQL

Great but no chapters directly on SQL

More Books

Surprisingly Helpful

Excellent but skip to chapter 7

(2nd Edition)Buy this today!