How to learn PowerShell specifically for a DBA?

chrisrdba 276 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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,105 questions

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) 951 Reputation points MVP
    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 276 Reputation points
    2020-12-17T21:42:07.663+00:00

    DBATools is exacatly what I was atfer, thanks

  4. Ben Miller (DBAduck) 951 Reputation points MVP
    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