The Red9 blog
Our most popular post
SQL SERVER HEALTH CHECK
[2026] 145 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 Database Assessments
SQL Server Installation Configuration Guide
Monitoring Deadlocks In The SQL Server
How We Made T-SQL Queries Run 11 Times Faster
Review Your Windows Task Scheduler: It Can Impact Your SQL Server Performance
Two Most Important Decisions In Disaster Recovery – RPO And RTO
How We Made T-SQL Query Run 17,000x Faster
SQL Server Migration To Amazon RDS
Disabling Windows “Visual Effects” To Boost Performance
Never Use The Full Recovery Model Without A Backup
SQL Server Performance Has Been Tuned, But What I Got Is “I Cant Feel It!” Wait! What??
How We Boosted SQL Performance by 40x
SQL Server Data Encryption And Your Options
[Step-by-Step] Migrating SQL Server to Azure SQL Database
Best Practices For Performance Counters In Microsoft SQL Server
SQL Server Migration To Amazon RDS Strategies
How We Made T-SQL Queries Run 34,785 Times Faster
Improve SQL Server Performance By Enabling Instant File Initialization
How We Slashed SQL Query Disk Read Operations by 1,152 Times
Should I Migrate My SQL Server To Linux?
Wasting CPU For Implicit Conversions In SQL Server
Finding User Tables In SQL Server System Databases
Managing SQL Server Objects with SET Options
How We Made T-SQL Query 9 Times Faster
Forcing Index, Order, And Join Hints And Being Careful
Microsoft SQL Server Migration Strategies To AWS
How We Made T-SQL Queries 4 Times Faster
SQL Server Monitoring Software Tools
How We Made T-SQL Queries Run 589 Times Faster
Unlock the Secrets: How to Choose the Best Encryption Feature for SQL Server
Improve Your SQL Server Performance Enabling Data Compression
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 StaatsCloud EngineerMetalToad
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.