How to become PowerDBA - PowerShell for SQL Server DBA?

Are you a busy DBA who spends most of the time fixing ad-hoc issues and working on unexpected incidents? Do you wish you have more time to focus on fixing your environment, so there is less unplanned work? Or maybe you do not even have time to know exactly where your estate is hurting? We have been there and that is why we want to share our hands-on experience with you. During this training session, you will learn about the following modules: - dbatools - open-source, community maintained tool that servers as SQL Server Management Studio in the command line. The actual SSMS will feel like an old rusty car in comparison to a robust PowerShell module. - Pester - a module that helps you to write custom tests to make sure your PowerShell code is always working. You will start writing custom Pester tests even on your home PC. - dbachecks - Pester wrapper to validate and keep an eye on your estate and track if it follows the best practice. The same stable as dbatools. The same excellent quality. - AZ.Sql - Authored by Microsoft, alternative way to manage the cloud resources. There is a good chance you won't even open the Azure Portal after this training. - ImportExcel - Have you ever had to deal with Microsoft Excel spreadsheets but felt like there is too much clicking around? This open-source and free module will help you to create and manage workbooks without Microsoft Office on your machine. This session is designed to be demo-heavy with PowerPoint slides reduced to a minimum. The goal is that attendees learn about useful tools and why and how to apply them in their environment. Most of the time we will be working with VS Code. Prior PowerShell knowledge is not required although it will not hurt. Most of these modules can be used with some basic understanding of scripting languages. This is a session for database administrators who are busy fighting with fires and more efficient tools to be able to work on preventing those in the future. Primary the attendee works with the on-premises estate and works hard on upgrading, migrating the servers to newer versions.