How to write professional Powershell scripts
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.
André is a DBA and SQL Server Solutions architecht for CloudDBA.nl. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML), and even implementing PDW.
André is a Data Platform MPV, Dutch PASS Chapter Leader and organiser of SQL Saturday Holland