Maybe you’ve only heard of Powershell. Maybe you’ve seen a little bit of Powershell code, but still don’t understand how it works. You’ve been telling yourself for months now that you need to learn it. Why wait? The time to get started with Powershell is now.

This full day session will help build your foundation for learning and using Powershell. While we will be focusing on using Powershell as a SQL Server Database Administrator (or Developer), much of the material will also review general use for system administrators. By attending this training, you will gain an understanding of what Powershell is, how you can use it in your day to day management of your environments, and what specific things can be done using Powershell in a SQL Server environment.

The session will cover the following areas:

Powershell Basics: What it is, where it came from, how to write it.

Powershell and SQL Server: How can we interact with SQL Server using Powershell.

Common Administrative Tasks made easier: We will look at specific use cases from day-to-day database administration and how they can be automated using Powershell. Some of these tasks include backups and restores, environment inventories, and database migrations.

Powershell, SQL Server, and Server Core: Server Core is a strong alternative for running SQL Server and Powershell is a requirement to manage it. Setup and administration of this through Powershell will be covered.

Powershell and Azure: Powershell is a critical management tool for Azure. We will talk about some of the cmdlets used to manage Azure SQL Databases and other Azure components.

This session is targeted towards IT Professionals of all levels who have minimal experience with Powershell, focusing primarily on its use with SQL Server. While Powershell itself is a deep and wide topic, attendees will leave this session with a solid understanding of Powershell basics, examples of tasks that can be automated using Powershell, and ideas for how Powershell can be used in their own environments.

About Mike Fal: Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently. Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He currently works as a Database Solutions Engineer for Rubrik, Inc. and has been caught playing trombone in public on more than one occasion.