From the course: PowerShell for SQL Server Administration

Download tools - PowerShell Tutorial

From the course: PowerShell for SQL Server Administration

Start my 1-month free trial

Download tools

“

- [Instructor] If you want to follow along with the demo files, you're going to need to download three things. You're going to need to download SQL Server, the SQL Server Management Studio, and the SQL Server plug-in for PowerShell. For SQL Server, open up a web browser and go to microsoft.com/sql. This will take you to the Microsoft SQL Server homepage. From here, click on the Try SQL Server 2017 button. When the next page opens, click on Download free trial. Fill out the form. Pay close attention to the phone number field. It does not accept dashes, or hyphens, or parentheses. So you're not going to be able to put anything in but the actual set of numbers for your phone number. Set your company, your job role, and the country you reside in, and then click Submit. It'll take a second for the next page to open. But from here, you can click Download now and that'll let you download SQL Server. To download SQL Server Management Studio, go to aka.ms/ssms, SQL Server Management Studio, and click okay. This will take you to the SQL Server Management Studio download page. From here, click on the most recent version of SQL Server Management Studio, which is currently version 18.0, which just released a few days ago. The last thing you're going to need is the SQL Server plugin for PowerShell. To install that, open a PowerShell window in administrator mode. Run the command install-module SQLSERVER. Click enter. If you get an error message, run the same command with the AllowClobber command. This will allow the module to install over an installation that's half done.

Contents