Recently I was invited to talk about beginning SMO on the SQL Undercover podcast. So I put together a tutorial to teach SMO in PowerShell from the very beginning.
This isn’t a PowerShell tutorial; it’s an SMO tutorial. So if you need to know how to use SMO to manage SQL Server, here’s a 2hr beginning.
Here’s the code used in the demos.
BeginningSMO.zip
I’m finally starting to learn powershell and this has helped me greatly. I suspect it will help even more once I do more complext tasks as my first few attempts before this didn’t go so well. I’ve got a better idea why now.