Fundamentals of PowerShell for DBAs

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 recorded online 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.

Note that this class is taught with Windows, and uses Windows drive letter & pathing examples. If you’d like to follow along on Mac or Linux, be aware that you’ll need to change the paths as you go.

About the instructor: Drew Furgiuele is a Microsoft MVP who 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.

Your Progress So Far in This Class

This is driven by the mark-as-complete buttons in each module of the class. (Let’s be honest: you’re probably just going to mark them as complete because you’re that kind of student. I feel you.)