André is a Data Platform MVP. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, Azure DevOps, Python, Azure DW and Databricks. He loves to tinker with 100TB+ databases.
How to write professional Powershell scripts
It's time to take your ad-hoc Powershell scripts turn them into your very own module. And while we're at it we will add proper error handling, parameterization & pipeline support. I will also demonstrate how to build help, force and whatif support.
You probably have a few Powershell scripts sitting around, perhaps written from scratch but most likely you borrowed the idea from a blog somewhere, and then used those as templates to achieve your goal. It's time to take those ad-hoc scripts turn them into your very own module. And while we're at it we might as well add proper error handling, parameterization and pipeline support. I will also demonstrate how to build help, force and whatif support. This is a demo rich session and all demos will be covering practical SQL Server related solutions.