{"repo":"dataplat/dbachecks","free":true,"listed":false,"github":"https://github.com/dataplat/dbachecks","clone":"git clone https://github.com/dataplat/dbachecks.git","description":"✔ SQL Server Environmental Validation","language":"PowerShell","stars":483,"topics":["sqlserver","pester","powershell","dba","database","dbatools","validation"],"license":"MIT","category":"databases-storage","readme_excerpt":"dbachecks Please note - development on v2 has stopped and all efforts are focused on the v3 improvements to use Pester v5 and improve performance. You are welcome to help by picking something from the project https://github.com/orgs/dataplat/projects/2 or by contacting @SQLDBAWithABeard @jpomfret @ClaudioESSilva or @shaneis dbachecks is a framework created by and for SQL Server pros who need to validate their environments. Basically, we all share similar checklists and mostly just the server names and RPO/RTO/etc change. This open source module allows us to crowd-source our checklists using Pester tests. Such checks include: Backups are being performed Identity columns are not about to max out Servers have access to backup paths Database integrity checks are being performed and corruption does not exist Disk space is not about to run out All enabled jobs have succeeded Interactive dbachecks PowerShell Notebooks for Azure Data Studio You can find a set of interactive PowerShell Notebooks which will introduce you to all of the core concepts in Robs GitHub. There is a set of .NET interactive Jupyter Notebooks https://github.com/SQLDBAWithABeard/JupyterNotebooks/tree/main/notebooks/dotNETNotebooks/dbachecks and a set of Jupyter Notebooks that will run in Azure Data Studio https://github.com/SQLDBAWithABeard/JupyterNotebooks/tree/main/notebooks/NotDotNet/dbachecks Both will use a docker container to show you how dbachecks works. There is a zip file containing the Notebooks here ht","default_branch":null,"files":null,"tree":[],"storefront":"/r/dataplat","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/dataplat/dbachecks/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}