aDBA: The Automated SQL Server DBA
30 health checks across 14 domains. Tiered auto-remediation. ITSM change control. Full audit trail. Licensed FSL-1.1-MIT — free for internal use.
What is aDBA?
aDBA is SQLOPTIMISE's own automated database administration tool — not a wrapper around third-party utilities. It gives your SQL Server estate continuous health visibility, structured auto-remediation with human-approval gates, and a complete audit trail of every action taken.
Health Visibility
30 checks across 14 domains run on schedule — configuration, performance, security, maintenance, and more.
Automated Remediation
Three tiers: check-only, auto-fix inside approved windows, or Boss Mode. You choose how much autonomy aDBA gets.
Full Audit Trail
Every check result, approval, and remediation action is recorded — who approved what, when, and what changed.
What aDBA Does
Six core capabilities — verified from the aDBA codebase.
30 Health Checks, 14 Domains
Automated assessments covering configuration, performance, security, backup integrity, index health, and more — running on your own SQL Server, on your own schedule.
Tiered Auto-Remediation
Check-only alerts, auto-fix inside approved maintenance windows, or full Boss Mode. Configured per check so your critical systems stay under human control.
ITSM Change Control
Remediation actions requiring approval generate a magic-link request. A single click from the DBA gates the change — no separate ticketing system required.
Full Audit Trail
Every check run, approval decision, and remediation action is logged with timestamp, operator identity, and outcome. Built for compliance from the ground up.
Scheduled Maintenance
Index rebuild, statistics update, database backups, and integrity checks — all scheduled as SQL Agent jobs with configurable windows and alert thresholds.
Notification Fabric
Alerts delivered to Discord, email, Teams, or Slack. Magic-link approval requests delivered directly to your channel — no portal login required to approve a change.
How It Works
Deploy
Run Install-aDBA.ps1 against your SQL Server instance with a JSON configuration file. One command, no manual scripts.
Monitor
30 health checks run on schedule via SQL Agent. Findings are sent to your configured notification channel — Discord, email, or Teams.
Remediate
Approve fixes with a single magic-link click in your channel, or configure auto-fix windows for low-risk remediations. Every action is logged.
Interested in aDBA?
Register your interest and we'll be in touch when aDBA is available for download. Early registrants receive priority access.
Request a Solution Review
aDBA is currently in private development. The GitHub repository (FSL-1.1-MIT) will be published at launch — a link will be added here at that time.