Share via

How to learn PowerShell specifically for a DBA?

chrisrdba 471 Reputation points
2020-12-11T18:23:17.847+00:00

Greetings. I'm a long time DBA that knows no PowerShell at all.

I was looking online and there doesn't seem to be live classes geared towards this. There's PS classes, but not DBA specific. I'm concerned they may leave a lot to be desired for what I'm after. There's also video classes, which I think may be a tough way to learn.

All said how has everyone else went about this?

Thanks!

SQL Server Other
Accepted answer
  1. Olaf Helper 47,436 Reputation points
    2020-12-14T11:56:28.587+00:00

    There is a powerfull PowerShell CmdLet for DBAs available at https://dbatools.io/

    2 people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Veloco 1 Reputation point
    2020-12-11T19:47:56.607+00:00
  2. Ben Miller (DBAduck) 966 Reputation points
    2020-12-12T00:27:36.957+00:00

    I teach a PowerShell class specifically for DBAs. https://dbaduck.com.

    You are right, it is a little different thing to use PowerShell as a DBA than just PowerShell.

    But I would start with PowerShell in a Month of Lunches by Don Jones to get you started with PowerShell basics. Then you can tackle the DBA side of things.

  3. chrisrdba 471 Reputation points
    2020-12-17T21:42:07.663+00:00

    DBATools is exacatly what I was atfer, thanks

    0 comments
  4. Ben Miller (DBAduck) 966 Reputation points
    2020-12-18T04:49:13.047+00:00

    And just for more references:

    Learn from the SQL PowerShell Stairway (old but still valid) stairway-to-sql-powershell

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.