Is PowerShell just for admins, or is it a full-fledged developer tool? In this episode of the M65 podcast, automation architect Matthew Rost breaks down why PowerShell remains the ultimate superpower for anyone managing Microsoft 365 and Azure environments. Discover how to transition from a basic script user to an advanced automation expert by focusing on logic and scalability.

Matthew joins the show to discuss the evolution of the Microsoft ecosystem, from the early days of System Center to the modern Microsoft Graph API. We explore why the GUI often fails at enterprise scale, how to handle complex reporting across multiple tenants, and the best ways to structure your scripts for maximum reliability. Whether you are dealing with critical security vulnerabilities like Log4j or just trying to clean up a massive DevOps backlog, this conversation provides the roadmap for modern IT automation.

We also dive into the financial side of automation, discussing the low costs of Azure Automation and why every admin should be prioritizing code over clicks. Matthew shares his philosophy on automating the right processes and explains why Microsoft Graph is actually making PowerShell more powerful rather than replacing it.

Chapters
0:00 Introduction to Matthew Rost
2:45 PowerShell: Admin tool or developer tool
5:15 The impact of Microsoft Graph modules
9:30 Balancing PowerShell vs direct API usage
12:45 Why the GUI fails at enterprise scale
15:20 The hidden costs of PowerShell and FinOps
18:10 Governance and reporting across tenants
21:45 Real world examples: Solving Log4j with automation
25:30 Basic scripting vs advanced thought processes
29:00 Designing for safety and scalability
32:15 Common automation mistakes to avoid
36:00 Testing scripts in changing environments
39:15 Advice for new admins and learners
41:00 Hot takes and the future of PowerShell

If you enjoyed this deep dive into automation, make sure to subscribe for more expert insights on Microsoft 365. Check out the links in the description to find Matthew's blog and the PowerShell Weekly newsletter to stay ahead of the curve.

#powershell #microsoft365 #azure #automation #devops