Quick Start

Clone the repo and run the setup script. It checks prerequisites, installs the SqlServer module if missing, and verifies the connection. Pass or fail, it tells you exactly what to do next.

git clone https://github.com/peterwhyte-lgtm/dba-tools
cd dba-tools
.\Initialize-Environment.ps1

To target a remote or named instance instead:

.\Initialize-Environment.ps1 -ServerInstance PROD01\SQL2025

Once setup passes, the server is saved for the session and every script picks it up automatically. Everything is read-only by default, and every script header states the permissions it needs and what it touches.

Three commands take a server from no idea to a written assessment:

# 1. Collect
.\powershell\reporting\Invoke-HealthCheckCollection.ps1 -ServerInstance PROD01\SQL2025
# 2. Rules review
.\powershell\reporting\Review-HealthCheckOutput.ps1
# 3. AI assessment
.\powershell\reporting\Invoke-AiAssessment.ps1

What’s Inside

Three Ways to Run It

Script Articles

The scripts worth explaining get their own articles: what the script returns, when to use it, and the full script ready to copy. Organized into eight areas of the job, each one opening onto its own pillar page or pages: