slides - SQLvariant.com blog by Aaron Nelson

triangledriprockInternet και Εφαρμογές Web

7 Αυγ 2012 (πριν από 5 χρόνια και 2 μήνες)

334 εμφανίσεις

PowerShell for Data Professionals


By Aaron Nelson *(Mostly)




SQL
variant
.com
My Blog


SQLPowerShell.com
PowerShell specific blog posts


I’m not a PowerShell Expert. Just a
PowerShell
enthusiast
.

Copyright 2010 By Aaron Nelson

PowerShell for Data Professionals


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



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

Copyright 2010 By Aaron Nelson

Why PowerShell?


PowerShell brings 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 insanely
generous community


#
PoShHelp

on twitter!


Copyright 2010 By Aaron Nelson

PowerShell Bolt
-
Ons


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

and
Modules
.


The Snap
-
Ins for SQL Server are

SqlServerCmdletSnapin100

SqlServerProviderSnapin100

Copyright 2010 By Aaron Nelson

More PowerShell Bolt
-
Ons


In addition to the Snap
-
Ins are several
Codeplex projects


The Codeplex
projects
include

SQL


SQLPSX


SSAS PowerShell Provider


SSRS PowerShell Provider


TFS


Copyright 2010 By Aaron Nelson

PowerShell Has Friends


Here is just a short list of a few products


Idera’s

Quest’s


Sapien’s

Copyright 2010 By Aaron Nelson

Application

Version

Cmdlets

Provider

Managemen
t 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

Copyright 2010 By Aaron Nelson

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

Copyright 2010 By Aaron Nelson

Helpful Blogs


http://blogs.technet.com/HeyScriptingGuy/


http://blogs.msdn.com/powershell/


http://thepowershellguy.com
/


http://sev17.com/


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


http
://
powerscripting.net/

Copyright 2010 By Aaron Nelson

Books!


Best book on using
PowerShell for SQL






Only one chapter on SQL
but still helpful


Great

and even has
lots of scripts on the
CD but no chapters
directly on SQL

Copyright 2010 By Aaron Nelson

More Books

Surprisingly

Helpful

Excellent but
skip

to chapter 7

(2
nd

Edition, several
new chapters)

Buy this today!


Copyright 2010 By Aaron Nelson

PowerShell for Data Professionals


Aaron Nelson


SQL
variant
.com
My Blog


SQLPowerShell.com
PowerShell specific blog posts

Copyright 2010 By Aaron Nelson