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.

PowerShell won't solve all problems

PowerShell won't solve all problems - PowerShell Tutorial

From the course: PowerShell for SQL Server Administration

Start my 1-month free trial

PowerShell won't solve all problems

- [Narrator] Hi, everyone, and let's go ahead and take a look at PowerShell, how we can use PowerShell within our SQL server environments. One of the reasons we would use PowerShell is for the automation of tasks. PowerShell is really not built for one-off kinds of tasks. It's used for those repetitive tasks where we're going to be doing the same thing multiple times, we're going to do the same thing over and over and over again. Say we need to create a database. I want you to create the same database in multiple environments with the same set of parameters. We might do that through PowerShell. PowerShell has features that are added to it all the time. Occasionally things get taken away from it, but for the most part that doesn't happen and when that does happen, Microsoft lets us know well in advance that something's going to be removed from PowerShell. PowerShell can be used to automate and manage a large part of your real estate within your environment. So things like Active…

Contents