Blog
Analyses de performance SQL Server, études de cas réelles et conseils pratiques pour les DBA.
Nobody Teaches You How to Run SQL Server in Production
You can mass-produce developers who know SELECT and JOIN. But the gap between writing queries and keeping a production SQL Server healthy is enormous — and almost nobody talks about it.
We Built a Free SQL Server Knowledge Base (256 Articles and Counting)
Wait types, DMVs, error codes, and troubleshooting guides — all with diagnostic queries you can copy and run. Here's why we made it and what's in it.
AutoDBA – SQL Server Diagnostics
Free Scan in 60 Seconds
Find missing indexes, blocking queries & performance issues instantly. No agent install. Upload a snapshot and get actionable recommendations.
Your Indexes Are Lying to You: What Missing Index DMVs Won't Tell You
Every DBA checks sys.dm_db_missing_index_details. But blindly following its recommendations can make your performance worse, not better.
The SQL Server Defaults That Still Ship Wrong in 2026
SQL Server has been around for 30 years. Some of its default settings have been wrong for most of that time. Here are the ones that still bite people.
What Happens When You Let AI Review Your SQL Server (A DBA's Honest Take)
I've been a DBA for 15 years. I recently let an AI analyse my own production servers. Here's what it got right, what it got wrong, and what surprised me.
Expert Database Administration
Samix Technology – DBA Services
Professional SQL Server & database administration services. Performance tuning, migration, high availability & 24/7 monitoring by certified DBAs.
We Analysed a Production SQL Server and Found 27 Issues in 60 Seconds
Last week we pointed AutoDBA at a real production SQL Server. 16 CPUs, 127GB RAM, Developer Edition 2022. Here is what happened.
The 5 Most Common SQL Server Misconfigurations (and How to Fix Them)
After scanning hundreds of SQL Server instances, these same 5 issues keep showing up. Most of them take less than a minute to fix.
Why Your DBA is Spending 80% of Their Time on Things AI Can Do
Most DBA work is pattern matching against known best practices. That's exactly what AI is good at. Here's what should change.
The Hidden Cost of Parameter Sniffing (And Why OPTION (RECOMPILE) Is Not the Answer)
Parameter sniffing gets blamed for half the performance problems in SQL Server. The usual fix is OPTION (RECOMPILE). But that fix has a cost most people never measure.
I Stopped Rebuilding Indexes Every Sunday Night (Here's What Happened)
Every SQL Server shop has the sacred Sunday night index rebuild job. I turned mine off. The results might change how you think about index maintenance.
The Wait Stats Everyone Ignores (And the Ones That Get Too Much Attention)
Every DBA checks wait stats. Most of us focus on the wrong ones. Here's which waits actually tell you something useful and which are noise.
Essayez AutoDBA sur votre SQL Server
Scan de diagnostic gratuit. Aucune carte de crédit requise. Résultats en 60 secondes.
Commencer gratuitement