How to learn PowerShell specifically for a DBA?

chrisrdba 361 Reputation points

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?


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,080 questions
{count} votes

4 additional answers

Sort by: Most helpful
  1. Veloco 1 Reputation point

  2. Ben Miller (DBAduck) 951 Reputation points

    I teach a PowerShell class specifically for DBAs.

    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 361 Reputation points

    DBATools is exacatly what I was atfer, thanks

    0 comments No comments

  4. Ben Miller (DBAduck) 951 Reputation points

    And just for more references:

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

    0 comments No comments