A selection of the things I’ve built, fixed and run as a SQL Server DBA.
DBA Sentinel and Athena
An on-premises AI operations assistant I designed and built. DBA Sentinel ingests SQL Server alert emails, triages them by severity and produces a prioritised morning briefing, cutting the time spent sifting through alerts. Athena, a voice-driven orchestrator, coordinates the agents and brings briefings, alerts and industry news together on a single operations dashboard, with notifications pushed to mobile. Its knowledge base is my own SQL Server DBA Handbook, and a second briefing monitors SQL Server releases and security CVEs from a whitelist of trusted sources. Everything runs locally, so no operational data leaves the network.
Power Automate Alerting
Flows that pick up SQL Server alert emails for disk space, blocking and availability, then post them straight into the right Teams chats, so problems reach the people who need to see them in real time.
Automation and Scripting
An unattended SQL Server installation script with configurable collation, file paths and authentication. Alongside it is a project to consolidate a large library of PowerShell scripts into one config-driven tool that can be deployed to any server.
SQL Server DBA Handbook
A 300 to 400 page handbook I wrote and keep current. It covers the practical side of SQL Server administration and doubles as the knowledge base behind Athena.
Personal DBA Website
My own site, cliveroberts.net, which I built and run myself. DNS sits on Cloudflare and it’s hosted on Plesk. It publishes SQL Server news, patch tracking, an audit guide and technical articles.
Multi-Domain SQL Server Estate
Looking after an estate of around 15 SQL Server instances spread across multiple domains, covering availability groups, auditing, Database Mail and server provisioning. Day to day that means keeping production healthy, secure and patched, from a three-node availability group with tuned memory settings to failover planning and testing in maintenance windows.
Clive Roberts DBA