I want to point out a set of 4 postings by Matthew Geddes, a Hyper-V architect, on Automation and Private Cloud.
- Part 1: sets the stage: a number of production SQL Server instances where some nightly reporting jobs are run. These reporting jobs are quite heavyweight and impact other users during their large processing window. What we want to do is to have the reporting jobs run on non-production VMs with that day’s production data.
- Part 2: shows how how to use syncVM from Tintri’s PowerShell Toolkit. Matt breaks down usage of the PowerShell cmdlet, Sync-TintriVDisk; and then shows how to integrate it into a small script.
- Part 3: adds more code to the small script and wraps it into a function so that it can be used for multiple reports.
- Part 4: adds more automation with by showing how to parameterize the reports. Matt summarizes and gives you some homework.
I like the way Matt goes through presents the use case, and then goes through the code step by step.
Until next time,
– Rick –