SQL Saturday 194 Exeter Pre-Con – PowerShell 3.0 for SQL Server Administrators and Developers

OK, Yes, it’s (yet) another post pimping a SQL Saturday 194 Exeter Pre-Con session. This time, André Kamman (blog|twitter)and his day of PowerShell.

I’ve seen André perform at a SQLBits conference, where he gave a session “RoboDBA” about PowerShell, and the joys of administering a SQL Server environment of several hundred instances. My entire collection of notes from the session is as follows:

Takeaways

  • Learn PowerShell
  • Build own environment to test / play, using:
    • HP MicroServer
    • MS TechNet
    • vmWare or MS HyperV
  • Learn to use LogParser
  • Do as much as possible with scripting rather than GUIs

“There are production DBAs who will be outsourced by PowerShell scripts” – AK

Helpful.

Fortunately, the video for his session *is* available on the link above.

His views on PowerShell have been instrumental in getting me started with learning it (albeit slowly). If you’re starting out, or still learning, you could do worse than start with a day with André!

Advertisements
This entry was posted in SQLServerPedia Syndication and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s