The Red9 blog

Get our new tips before anyone else.

Enter your email below to subscribe!

This field is for validation purposes and should be left unchanged.

Our most popular post

SQL SERVER HEALTH CHECK

[2026] 110 Point SQL Server Database Health Checklist

Our full SQL Server Health Check covers a complete SQL Server health checklist of items on-premises and cloud-based Database Management Systems (DBMS) services.

All posts

SQL Server Tips

SQL Server DBA Cost 2026: The 8 Budget Lines Most IT Teams Miss

SQL Server Performance Tuning

How We Found the VM Cap Costing Our Client $30K in Wasted SQL Server Spend

SQL Server Tips

How to Spend $10k on SQL Monitoring and Still Fix Nothing

SQL Server Performance Tuning

Restarting SQL Server? You’re Destroying the Evidence.

Elevate your SQL Servers with our managed services, performance tuning, and consulting services.
Let's Talk!
SQL Server Performance Tuning

How We Cut SQL Server Costs in Half and Added HA for Free

SQL Server Performance Tuning

Why Your SQL Server Column Design Could Be Costing You 20% of Your CPU Power 

SQL Server Migrations & Upgrades

SQL Server 2016 End of Life: The Breaking Changes Nobody’s Auditing

SQL Server Migrations & Upgrades

How We Cut SQL Server Licensing Costs by 75% With Azure Migration For a Client

SQL Server Performance Tuning

How We Made a Warehouse Management System 6.5x Faster by Fixing One SQL Server Constraint

SQL Server Performance Tuning

Your SQL Server Is Logging Deadlocks – Are You Reading Them?

SQL Server Performance Tuning

How a Simple VMware Misconfiguration Cost Our Client Months of Performance Issues

SQL Server Performance Tuning

Why Your App Got Slow After Migrating SQL Server to Azure

SQL Server Performance Tuning

You Scaled Your VM to 32 Cores. Your TempDB Configuration Didn’t

SQL Server Tips

AI Won’t Replace Your Senior DBAs. Here’s What It Actually Does.

SQL Server Performance Tuning

How SQL Tuning Saved Six Figures and Cut Cores by 75%

SQL Server Tips

A Client Lost 1.5 Months of Data and It Wasn’t a Cyberattack

SQL Server Migrations & Upgrades

SQL Server 2025 Has No SSRS Release. Here’s What That Means for Your Migration

SQL Server Tips

SQL Server Enterprise Edition Is Not a Must

SQL Server Performance Tuning

Page Life Expectancy & Why Should You Care?

SQL Server Tips

Stop Running Other Applications on Your SQL Server

SQL Server Health Check

VM Snapshots Are Not SQL Server Backups: A Disaster Recovery Story

SQL Server Migrations & Upgrades

How Real Workload Testing Cut Azure SQL Hyperscale Costs by 46% and Saved $86,000 a Year

SQL Server Performance Tuning

What To Do When Your SQL Server Critical Report Starts Timing Out on Friday Evening

SQL Server Security

SQL Server xp_cmdshell: executive guide to risk, governance, and safer alternatives

SQL Server Migrations & Upgrades

How We Saved a Professional Services Firm $117,654 Annually by Right-Sizing Their SQL Server Infrastructure

SQL Server Performance Tuning

How to Check SQL Server Disk Formatting: The 4KB Mistake Costing You Performance

SQL Server Migrations & Upgrades

SQL Server 2025 Released: AI Integration, Developer Features, and Performance Gains

SQL Server Tips

SQL Server Emergency Recovery: How We Saved a Corrupted Database Without Backups 

SQL Server Tips

Oracle Database (19c → 23ai): A C-Level Overview for 2025

SQL Server Performance Tuning

ETL Process Optimization: A Practical Guide for SQL Server Teams

SQL Server Performance Tuning

Case Study: How Red9 Transformed SQL Server Performance and Saved 66+ Minutes of Daily Processing in 6 Weeks

SQL Server Migrations & Upgrades

The CTO How-to Guide to SQL Server Migration: A Decision Framework

Discover what clients are saying about Red9

Red9 has incredible expertise both in SQL migration and performance tuning.

The biggest benefit has been performance gains and tuning associated with migrating to AWS and a newer version of SQL Server with Always On clustering. Red9 was integral to this process. The deep knowledge of MSSQL and combined experience of Red9 have been a huge asset during a difficult migration. Red9 found inefficient indexes and performance bottlenecks that improved latency by over 400%.

Rich Staats 5 stars
Rich Staats
Cloud Engineer
MetalToad

Always willing to go an extra mile

Working with Red9 DBAs has been a pleasure. They are great team players and have an expert knowledge of SQL Server database administration. And are always willing to go the extra mile to get the project done.
5 stars
Evelyn A.
Sr. Database Administrator

Boosts server health and efficiency for enhanced customer satisfaction

Since adding Red9 to the reporting and DataWarehousing team, Red9 has done a good job coming up to speed on our environments and helping ensure we continue to meet our customer's needs. Red9 has taken ownership of our servers ensuring they remain healthy by monitoring and tuning inefficient queries.
5 stars
Andrew F.
Datawarehousing Manager
See more testimonials

Speak With a SQL Server Expert

In just 30 minutes, we will show you how we can eliminate your SQL Server headaches and provide 
operational peace of mind

Schedule My Call Now ➜