Daily maintenance tasks got you down? Ever wanted to automate your busy work away, but you weren’t sure where to start? If so, then PowerShell is a tool to help you do just that. Whether you want to configure your physical or virtual servers, work with your file systems, and yes, even administer SQL Server, PowerShell can do all of those things very easily and efficiently.
In this two day class, you’ll learn the basics of PowerShell: we’ll start out with what it is, how the syntax works, and how you can do some essential and routine work by writing scripts. From there, we’ll focus on using PowerShell to administer SQL Server: how we can connect to SQL Server with PowerShell and how to get information about your instances. We’ll also write scripts together during the class for more complex tasks such as working with database objects, exporting and importing data, and even doing permissions audits with both SQL Server and Active Directory.
This class will feature a lot of interactive code examples that you’ll write with me so we can step through the logic and execution to help you build your own scripts for your daily work.
You’ll do the class exercises in a VM – each student gets their own lab VM in the cloud so they can work alongside Drew, building and testing a library of PowerShell scripts.
About the instructor: Drew Furgiuele has been working with SQL Server for over 15 years. He loves automation with T-SQL and PowerShell, and in his spare time, launches SQL Server into space with balloons.
This is an online class – Drew hosts it in GoToWebinar, live on webcam, taking questions as we go through the material together. Audio can come through either your computer audio, or by dialing into a US phone number – headset recommended either way. For more information, check out the Training Logistics PDF for our online classes.
Online class times:
- January 18-19, 2018 9AM-5PM Eastern (click to view in your own time zone)