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:
- 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
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é!