About DBA Virtuoso

DBA Virtuoso is a free video course for people who run Microsoft SQL Server on premises. It doesn’t teach you to write a query. It teaches you to do the job.

Who it’s for

New DBAs on their first SQL Server job, working DBAs who want a calmer week, and the sysadmins and developers who end up looking after SQL Server anyway.

What’s in the course

Nine episodes, 56 minutes. Watch them in order.

  1. 1
    SQL Server DBA Orientation: Your First Day on the JobYour first day as a SQL Server DBA. Nobody tells you what your job is; they tell you what’s broken. Before you start fixing, figure out who does what, who you work for, and who works for you.
  2. 2
    SQL Server Firefighting: Prove It’s the Database FirstSomething is broken, the bridge call has fourteen people on it, and everybody is looking at you. How a SQL Server DBA handles production incidents and on-call without making the fire worse.
  3. 3
    DBA Pushback & Project Kickoffs: Say What It CostsDBAs get invited to projects at the end, after every decision that matters is made. How to get invited early, what to ask at the kickoff, and how to push back by saying what it costs.
  4. 4
    SQL Server Licensing & Inventory: Find Every ServerYou can’t back up, patch, secure or license a server you don’t know exists, and there’s always one under Brad’s desk. How to find every SQL Server, and the licensing basics that cost real money when they’re wrong.
  5. 5
    SQL Server Monitoring: What Should Wake a DBA UpMonitoring is the only way out of firefighting. What a SQL Server DBA should alert on, what makes a ticket, what belongs on a dashboard, and what not to look at.
  6. 6
    SQL Server HA & DR: RTO, RPO and RestoresHigh availability and disaster recovery for SQL Server in plain English: RTO and RPO, what each option really protects you from, and why your restores matter more than your backups.
  7. 7
    SQL Server Security: CIS Benchmarks, TDE and TLSIt’s war: the black hats are always trying to stay ahead. Where a SQL Server DBA starts with security, from the CIS Benchmark to encryption, patching and role-based access.
  8. 8
    SQL Server Life Cycle, Documentation & TuningOnce the fires are out, things grow, get old, and change. Standardization, automation, server life cycles, documentation, cross training, and predictive tuning for storage, CPU and RAM.
  9. 9
    DBA Burnout: Work Fewer Hours, Get More DoneThe four causes of DBA burnout, a trench story about dehumanization, and the schedule that gets more done in 11 focused hours than most DBAs get done in 60.

What’s next

Season 2 is about DBAs surviving AI. Season 3 is about migrating on-prem to GCP. Both are coming soon.

Who makes it

I’m Richard, a working SQL Server DBA. I wrote every episode. The rules are firm on purpose, and the trench stories are mine.

How it’s made

Each episode is a whiteboard animation, about five to ten minutes long, built from my script. The narration is a synthetic voice reading that script. Every episode has captions on YouTube, and a page here with chapters and the full transcript.