SQL Server Configuration with dbatools & dbachecks
summary
Shows how to automate SQL Server configuration using PowerShell with the dbatools module and validate settings with dbachecks to PowerBI. Demonstrates installing modules (avoid Pester v5), sets a standard config (DB mail, operators, alerts), installs maintenance scripts and jobs, and runs dbachecks audits that drop failures from 126→22 failures while fixing Agent alerts, backups, schedules, trace flags and enabling query store; includes custom test guidance, sample scripts, and a live cumulative update install that completes successfully.
AI-written summary · about
chapters (15)
- 0:00Start
- 2:12install the module for dba
- 8:18show you a couple of basic things about using powershell
- 8:47use the criteria in the grid
- 9:39basic commands in in powershell
- 10:47set up a mail account
- 11:34pull in a connection to the server
- 12:03add a database mail account
- 18:38set our integrity checks to run
- 19:35set my recovery mode on my msdb to full
- 24:07run powershell in sql agent
- 25:05optimized for ad-hoc workloads
- 26:31run glen allen various diagnostic queries
- 30:05run database compression using dba tools
- 32:13write your own custom test
related talks
44mAnthony's Favorite dbatools cmdlets and Use Cases
20mSQL Server 2022 migrations with dbatools
44mContinuously deploying SQL code using Powershell
46mLift and Shift with dbatools - Azure SQL Managed Instance edition
39mPowerShell with SQL Statement Data Gathering
48mManaging replication with dbatools
47mAutomating Active Directory Health Checks
20mExcellent Database Adventure: From Code Errors to Reliable Releases