From the course: SQL Server 2012: Designing Database Solutions
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Introduction to Windows PowerShell - SQL Server Tutorial
From the course: SQL Server 2012: Designing Database Solutions
Introduction to Windows PowerShell
- In this section, we're going to talk about using PowerShell to administer SQL Server 2012. PowerShell is a command line tool from Microsoft that's used across many of its products. Microsoft Windows and Microsoft Exchange both heavily rely on PowerShell. Doing SQL Server administration through PowerShell isn't quite as common, but is still certainly a valuable skill. Being PowerShell is a command line language, it becomes very easy to create scripts. Any time you know the commands, all you have to do is put the series of commands into a text file, and now you have a script. There's a few different ways to open the PowerShell interface on SQL Server. Here inside of Management Studio there's several places that I can right click, such as if I highlight Adventureworks database, right click, one of the options will be Start PowerShell. This will open up a new window. You may or may not get a warning about having an active Instance of Analysis Services. The warning's really not a problem…
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.