Red9 Blog

Field notes from senior SQL Server consultants: how-tos for DBAs, numbers for the people who sign off.

Client Results

What we found on real client servers, what we changed, and what it saved.

Browse by Category

Top picks from each category. Open a category to see every article in it.

SQL Server Performance Tuning

Slow queries, blocking, CPU and memory pressure.

Why 64KB beats the 4KB default. A messy pile of tiny cardboard boxes sits next to one big neat box.How to Check SQL Server Disk Formatting: The 4KB Mistake Costing You PerformanceNov 8, 2026 · 11 min

SQL Server Health Check

Settings, alerts, backups and maintenance jobs that keep a server healthy.

The Ola Hallengren maintenance guide. A broom sweeps dust on its own while Ploom relaxes in a deck chair.Ola Hallengren Maintenance for SQL Server [Full Guide]Nov 9, 2026 · 8 min

SQL Server Migrations & Upgrades

Version upgrades, end of support, high availability, moves to Azure and AWS.

SQL Server 2025 drops SSRS. One red report binder falls out of a neat row on a shelf, leaving a gap.SQL Server 2025 Has No SSRS Release. Here’s What That Means for Your MigrationJul 31, 2026 · 19 min

SQL Server Security

Hardening, access control, and attack paths to close.

Bobby Tables: SQL injection, explained. A paper shredder turns records into strips while Ploom watches, startled.Little Bobby Tables and SQL Injection?Jul 12, 2026 · 9 min

SQL Server Tips

What SQL Server really costs, and day-to-day DBA practice.

SSMS 2026: download and setup. An open toolbox with a wrench, screwdriver and pliers next to a download box.Microsoft SQL Server Management Studio (SSMS): Download & InstallJun 26, 2026 · 7 min

Research & Statistics

Market numbers, each dated and sourced.

Data analytics statistics, 2026. A clipboard with a bar chart and a pie chart sits under a magnifying glass.Data Analytics Statistics (2026)Jun 30, 2026 · 8 min

All Articles

Every article, most recently updated first.

Show All Articles

Not Sure What Is Actually Wrong With Your SQL Server?

Get a free Health Check report on waits, configuration and reliability risks, so you know which fix to start with.

Free SQL Server Health Check

Free for now. We pay for every report. We just haven't decided on a cutoff date yet.

or book a free call with a senior DBA