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.
• Desired State Configuration and SQL Server: Desired State Configuration is a new Powershell feature that can allow for consistent SQL Server builds and deployments.

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.

Speaker Bio:

Mike Fal is a musician turned SQL Server DBA, with 13+ years of experience as a database administrator. He has worked for several different industries, including healthcare, software development, marketing, and manufacturing and has experience supporting databases from 1 GB to 4 TB in size. You can find his blog at http://MikeFal.net, where he blogs about career development, Powershell, and automating SQL Server.  Mike received his Bachelor's Degree from the University of Colorado at Boulder in 1996 and has been caught playing trombone in public on more than one occasion.