From the course: PowerShell for SQL Server Administration
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
When PowerShell is useful - PowerShell Tutorial
From the course: PowerShell for SQL Server Administration
When PowerShell is useful
- [Instructor] Let's look at some examples of when PowerShell would make sense and when it wouldn't. One thing we really want to nail when use PowerShell, when PowerShell's a good option for us, is when we're looking at a repeatable task. If there's a task we have to do over and over and over again, then we want to look at automation, we want to go ahead and create that PowerShell for it to go ahead and make our lives easier when it comes to that repeatable task. If it's something we're doing as a one-off, probably not a good solution for PowerShell. Now when it comes to something like pushing changes out to a bunch of machines, so maybe we need to set a register key on 100 computers, PowerShell's going to be a great way to do that 'cause we can just iterate through that list of 100 computers and push that key out to all those boxes. Obviously connecting to those boxes and actually making that change manually, major pain. If we need to reconfigure a cloud service, maybe we need to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.