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.