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
ETL Process Optimization: A Practical Guide for SQL Server Teams
Case Study: How Red9 Transformed SQL Server Performance and Saved 66+ Minutes of Daily Processing in 6 Weeks
The CTO How-to Guide to SQL Server Migration: A Decision Framework
The SQL Server Software Assurance Guide
SQL Server Monitoring & Alerts and Why Most Companies Are Doing It Wrong
The Complete SQL Server Migration Strategy Guide
Microsoft SQL Server: Definitive Guide
Why SQL Server Backups Fail When You Need Them Most: A 3-Month Bank Outage Case Study
SQL Server Security Best Practices: The 12-Step Hierarchy
What Is MySQL? How It Works and When to Use It
4 Hidden Ways Sales Reps Overcharge You for SQL Server Licensing (Real Restaurant Chain Example)
The SQL Server Memory Setting That Might Be Killing Your Performance
The $4 Million Mistake: True Enterprise Database Downtime Cost in 2025
SQL JOINs Venn Diagram: A Visual Guide
SQL Server End of Life: Avoid Costly Downtime & Security Disasters
Why Shrinking SQL Server Databases Is Almost Always a Terrible Idea
SQL Server Enterprise vs. Standard Edition: When to Downgrade and Save $6,000 Per Core
Enterprise SQL Server Security: Beyond Basic Protection
Comparison of SQL on Virtual Machine (VM) vs Azure Managed Instance (MI) vs Azure SQL Database (DB)
How to Identify and Fix Orphaned Users in SQL Server (And Why It Matters)
How to Copy Large Volumes of Data from One Table to Another Database[Or 18Gb in 5min]
SQL Query Optimization: A Practical Guide for Database Admins and Developers
9 Sample SQL Databases for Practice to Download & Set Up in Minutes
How to Fix SQL Server Recovery Pending Mode
What Is Cursor in SQL Server And Why Is It Used?
Optimal Window’s OS Page File Settings For SQL Server
How to Install DBATools Powershell Module for SQL Server [Full Guide]
[Full Guide] What is SQL Server Heap Table and How to Find Them
[Tried & Tested] SQL Server Disk Configuration Best Practices
How High Virtual Log File (VLF) Count Kills SQL Performance
TempDB Best Practices for Optimal Performance
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.