Reduce incidents, create your own configuration drift scanner with Powershell
Are you counting on your monitoring system to alert you when things fail? What if it was misconfigured and will never run so you won't see a warning? Preventing incidents or even large outages that your monitoring system didn't even warn you for can be done by continuously checking the configuration of your systems. Tracking them agains best practices, or your own set of rules. In this session I'll build some very simple Powershell from scratch to prove my point. You will be able to use my examples at work right away, and I'll also show a more complete open source Powershell library with many pre-configured checks.
Schwierigkeitsgrad des Vortrags (Einführung, Fortgeschritten, Experte): Fortgeschritten
Das Video von dem Vortrag auf der cim lingen 2018 finden Sie hier
Referent: André Kamman
André is a DBA and SQL Server Solutions Architect for Data Masterminds. 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). He also likes to work with MPP platforms APS and AzureDW, and is learning more and more about Azure each day. André is a Data Platform MVP, Dutch SQL Server User Group Leader and organiser of SQL Saturday Holland.al.