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 Performance Tuning

How We Made T-SQL Queries Run 51 Times Faster

SQL Server Health Check

Review Your Windows Task Scheduler: It Can Impact Your SQL Server Performance

SQL Server Migrations & Upgrades

Two Most Important Decisions In Disaster Recovery – RPO And RTO

SQL Server Performance Tuning

[Case Study] How to Size Azure Managed Instance & Avoid Overspending

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

SQL Server Database Assessments

SQL Server Security

SQL Server Migration To Amazon RDS

SQL Server Health Check

Disabling Windows “Visual Effects” To Boost Performance

SQL Server Tips

Never Use The Full Recovery Model Without A Backup

SQL Server Performance Tuning

SQL Server Performance Has Been Tuned, But What I Got Is “I Cant Feel It!” Wait! What??

SQL Server Performance Tuning

How We Made T-SQL Queries Run 11 Times Faster

SQL Server Security

SQL Server Data Encryption And Your Options

SQL Server Migrations & Upgrades

[Step-by-Step] Migrating SQL Server to Azure SQL Database

SQL Server Performance Tuning

Best Practices For Performance Counters In Microsoft SQL Server

SQL Server Migrations & Upgrades

SQL Server Migration To Amazon RDS Strategies

SQL Server Performance Tuning

How We Made T-SQL Query Run 17,000x Faster

SQL Server Health Check

Improve SQL Server Performance By Enabling Instant File Initialization

SQL Server Performance Tuning

How We Boosted SQL Performance by 40x

SQL Server Migrations & Upgrades

Should I Migrate My SQL Server To Linux?

SQL Server Performance Tuning

Wasting CPU For Implicit Conversions In SQL Server

SQL Server Health Check

Finding User Tables In SQL Server System Databases

SQL Server Tips

Managing SQL Server Objects with SET Options

SQL Server Performance Tuning

How We Made T-SQL Queries Run 34,785 Times Faster

SQL Server Performance Tuning

Forcing Index, Order, And Join Hints And Being Careful

SQL Server Migrations & Upgrades

Microsoft SQL Server Migration Strategies To AWS

SQL Server Performance Tuning

How We Slashed SQL Query Disk Read Operations by 1,152 Times

SQL Server Tips

SQL Server Monitoring Software Tools

SQL Server Performance Tuning

How We Made T-SQL Query 9 Times Faster

SQL Server Security

Unlock the Secrets: How to Choose the Best Encryption Feature for SQL Server

SQL Server Performance Tuning

Improve Your SQL Server Performance Enabling Data Compression

SQL Server Migrations & Upgrades

Migrating Microsoft SQL Server To Amazon AWS RDS

SQL Server Performance Tuning

How We Made T-SQL Queries 4 Times Faster

SQL Server Tips

Azure Stack On-Premises & How It’ll Blow Your Mind

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 ➜