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!