Join Denny Cherry for an in-depth discussion in this video Download tools, part of PowerShell for SQL Server Administration.
- [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.
Author
Updated
6/24/2019Released
6/21/2019- When PowerShell can be particularly useful
- Connecting to SQL Server from PowerShell
- Closing connections
- Creating objects in PowerShell
- Creating tables, views, and procedures
- Querying data in PowerShell
- Using loops in PowerShell
- Exporting CSV files and XML data
Skill Level Intermediate
Duration
Views
Related Courses
-
Learning PowerShell
with Matt Hester1h 23m Beginner -
SQL Server 2017: What's New
with Adam Wilbert1h 22m Beginner
-
Introduction
-
Download tools1m 35s
-
1. PowerShell in SQL Server
-
When PowerShell is useful2m 35s
-
Open-source solutions1m 47s
-
2. Connecting to SQL Server from PowerShell
-
Declaring objects3m 5s
-
Connecting to SQL Server3m 55s
-
Parameters in PowerShell2m 33s
-
Closing connections1m 22s
-
Disposing connections2m 4s
-
Object reuse2m 46s
-
-
3. Creating Objects in PowerShell
-
Creating databases2m 58s
-
Creating tables4m 9s
-
Creating views3m 44s
-
Creating procedures4m 33s
-
-
4. Querying Data in PowerShell
-
Inserting data into tables3m 48s
-
-
5. Looping Through Servers in PowerShell
-
Loops in PowerShell6m 21s
-
Concepts of threading6m 10s
-
Authentication and threading3m 24s
-
Piping between objects3m 17s
-
Exporting CSV files2m 56s
-
Importing CSV files2m 27s
-
Exporting XML data2m 50s
-
Importing XML data2m 26s
-
-
6. PowerShell Remoting
-
What is remoting?5m 18s
-
Removing over HTTP ports2m 11s
-
Enabling remoting via GPO3m 16s
-
Starting a remote session1m 59s
-
Ending a remote session1m 31s
-
Invoking a remote command2m 48s
-
-
Conclusion
-
Next steps33s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Download tools