PowerShell for Data Professionals

sweetleafapartInternet and Web Development

Aug 7, 2012 (5 years and 12 days ago)

332 views

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

Managem
ent GUI

2007

402

Yes

Yes

2008

Yes

Yes

No

2008

Yes

Yes

No

2007

74

Yes

No

2007

Yes

Yes

Yes

2007

Yes

No

No

2007

Yes

Yes

No

08.02.001
2

47

No

No

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

(2
nd

Edition)

Buy this today!