Today’s Data Base Administrator is responsible for a magnitude more instances of databases and much higher volume of data therein contained. We have always used automation in SQL from saved T-SQL scripts to SQL jobs and more. But now everything is moving to the use of PowerShell and specifically PowerShell for SQL to accomplish automation.
SQL Senior management now sees the ability to automate as a prerequisite for the job of DBA. And PowerShell is moving to the concept of cross platform so skills learned specifically for Microsoft SQL will easily migrate across the world of data storage and retrieval. This RonsNotes is intended to get you going with concept explanation and equally important hands on well laid out and tested labs and exercises.
We include a primer on PowerShell and placed all of the scripts and the build guide on GitHub.