Power Shell for Data Professionals Power Shell 2
![IBM Web. Sphere MQ[39] 6. 0. 2. 2 44 No No Quest Management Shell](https://slidetodoc.com/presentation_image_h2/3552e8adb3a49ef34aeb8b8597ce077a/image-6.jpg "IBM Web. Sphere MQ[39] 6. 0. 2. 2 44 No No Quest Management Shell")
- Slides: 9
Power. Shell for Data Professionals • Power. Shell 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 Power. Shell • Power. Shell 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
Power. Shell Bolt-Ons • In addition to the out of the box Power. Shell features there are some ‘expansion packs’ in the form of Snap-Ins. • The Snap-Ins for SQL Server are Sql. Server. Cmdlet. Snapin 100 Sql. Server. Provider. Snapin 100
Power. Shell Has Friends • • Here is just a short list of a few products Idera’s Power. Shell Plus Quest’s Power. Gui. org Saipien’s Primal Script
List obtained from Wikipedia Application Version Cmdlets Provider Managem ent GUI Exchange Server 2007 402 Yes Windows Server 2008 Yes No Microsoft SQL Server 2008 Yes No System Center Operations Manager 2007 74 Yes No System Center Virtual Machine Manager 2007 Yes Yes System Center Data Protection Manager 2007 Yes No No Windows Compute Cluster Server 2007 Yes No Microsoft Transporter Suite for Lotus Domino[37] 08. 02. 001 2 47 No No Microsoft Power. Tools for Open XML[38] 1. 0 33 No No
IBM Web. Sphere 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/Hey. Scripting. Guy/ • http: //blogs. msdn. com/powershell/ • http: //chadwickmiller. spaces. live. com/ • http: //sqlblog. com/blogs/allen_white/
Books! • Best book on using Power. Shell for SQL Great but no chapters directly on SQL
More Books (2 nd Edition) Surprisingly Helpful Buy this today! Excellent but skip to chapter 7
