How To Get the Auditors Off Your Butt with dbachecks

on YouTube ↗40m

" summary

dbachecks is an open source PowerShell module that runs ~200 configuration tests (CIS included) using DBAtools and Pester, claiming to verify actual compliance rather than noisy false positives. installation requires Pester 4 requirement for now and the module can run centrally against an estate. configs are saved as JSON, you can enable/disable specific checks and set per-environment values, output results to a SQL table for historical reporting via SQL+Power BI, and write new tests by copying provided custom check templates.

AI-written summary · about

" chapters (10)

1. 0:00Introduction and motivation
2. 3:36What is dbachecks
3. 7:24Installation and setup
4. 10:18Running basic checks
5. 13:24Output and reporting options
6. 17:18Configuring compliance checks
7. 23:11Exporting and importing configs
8. 28:14Writing custom checks
9. 33:34Demo of custom check creation
10. 38:55Resources and Q&A

" related talks

• 21mWhat you can do to protect your SQL Server and why it mattersGethyn Ellis, David Postlethwaite · SQLBits 2019
• 31mHow to Prepare for an Audit AKA Make Audits Suck LessSeth Thoenen · ChefConf 2018
• 36mImproving Security while Reducing Toil with DevSecOpsPaul C Czarkowski · KubeCon + CloudNativeCon + Open Source Summit China 2019
• 21mWhat you can do to protect your SQL Server and why it mattersGethyn Ellis, David Postlethwaite · SQLBits 2022
• 42mSolving for DevOps Auditors with Automated ComplianceShannon Lietz, Michelle Nikulshin · RSA Conference 2020 DevSecOps & Application Security
• 15mDevopsec: Rapid Security in the Cloud with AWS and CISMikhail, Tamhane · Agile India 2017
• 38mKick Starting our DevOps Transition with Chef ComplianceGary Bright · ChefConf 2017
• 32mIntroduction to CDD and Security Centric System DesignDmitry Didovicher · SpringOne Platform 2017