Red9 Blog
Field notes from senior SQL Server consultants: how-tos for DBAs, numbers for the people who sign off.
Most Popular
Latest
All Articles- Nov 16, 2026SQL Server Enterprise Edition Is Not a MustGuide · SQL Server Tips
- Nov 15, 2026Optimal Windows OS Page File Settings for SQL ServerGuide · SQL Server Health Check
Client Results
What we found on real client servers, what we changed, and what it saved.
How We Cut SQL Server Costs in Half and Added HA for Free
How We Made a Warehouse Management System 6.5x Faster by Fixing One SQL Server Constraint
VM Snapshots Are Not SQL Server Backups: A Disaster Recovery Story
How We Found the VM Cap Costing Our Client $30K in Wasted SQL Server Spend
How We Saved a Professional Services Firm $117,654 Annually by Right-Sizing Their SQL Server Infrastructure
How We Cut SQL Server Licensing Costs by 75% With Azure Migration for a Client
How We Made T-SQL Queries Run 34,785 Times Faster
How We Made a T-SQL Query Run 17,000x Faster
How Real Workload Testing Cut Azure SQL Hyperscale Costs by 46% and Saved $86,000 a Year
How SQL Tuning Saved Six Figures and Cut Cores by 75%
How We Slashed SQL Query Disk Read Operations by 1,152 Times
Case Study: How Red9 Transformed SQL Server Performance and Saved 66+ Minutes of Daily Processing in 6 Weeks
4 Hidden Ways Sales Reps Overcharge You for SQL Server Licensing (Real Restaurant Chain Example)
SQL Server Emergency Recovery: How We Saved a Corrupted Database Without Backups
How a Simple VMware Misconfiguration Cost Our Client Months of Performance Issues
[Case Study] How to Size Azure Managed Instance & Avoid Overspending
A Client Lost 1.5 Months of Data and It Wasn’t a Cyberattack
Why SQL Server Backups Fail When You Need Them Most: A 3-Month Bank Outage Case Study
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.
How to Check SQL Server Disk Formatting: The 4KB Mistake Costing You PerformanceSQL Server Health Check
Settings, alerts, backups and maintenance jobs that keep a server healthy.
Ola Hallengren Maintenance for SQL Server [Full Guide]SQL Server Migrations & Upgrades
Version upgrades, end of support, high availability, moves to Azure and AWS.
SQL Server 2025 Has No SSRS Release. Here’s What That Means for Your MigrationSQL Server Security
Hardening, access control, and attack paths to close.
Little Bobby Tables and SQL Injection?SQL Server Tips
What SQL Server really costs, and day-to-day DBA practice.
Microsoft SQL Server Management Studio (SSMS): Download & InstallResearch & Statistics
Market numbers, each dated and sourced.
Data Analytics Statistics (2026)All Articles
Every article, most recently updated first.
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 CheckFree 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


