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

Using PowerShell To Monitor Disk Usage

SQL Server Performance Tuning

How Triggers Affect Your SQL Server Performance

SQL Server Health Check

SQL Server Max Memory Parameter

SQL Server Performance Tuning

Best Practices For SQL Server Statistics

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

How to Configure Antivirus for SQL Server (and Improve Performance)

SQL Server Tips

Main Differences Between MS SQL Server Native Backups And 3rd Party Tools

SQL Server Performance Tuning

Comparing Performance of Two SQL Servers: Part 1

SQL Server Security

Azure SQL And Security Best Practices

SQL Server Health Check

Trace Flags In SQL Server

SQL Server Tips

Choosing the Right Azure SQL Service Database: A Complete Guide

SQL Server Health Check

Why Should You Enable SQL Server Database Backup Compression By Default?

SQL Server Health Check

How to Check MaxDOP in SQL Server and Set it for Optimal Performance

SQL Server Performance Tuning

SQL Server Performance Tuning Using Indexes

SQL Server Tips

How To Re-Initialize SQL Server Merge Replication Publication

SQL Server Tips

The Risks Of SQL Server Differential Backups

SQL Server Performance Tuning

Top 10 SQL Server Performance Tuning Mistakes

SQL Server Tips

Microsoft SQL Server License Guide: Complete Breakdown

SQL Server Performance Tuning

SQL Server Index Tuning for Performance

SQL Server Performance Tuning

Methods for Performance Tuning on Azure SQL Database

SQL Server Migrations & Upgrades

Amazon SQL RDS vs Azure SQL – [Ultimate Showdown]

SQL Server Performance Tuning

How Can You Find The SQL Server Jobs That Start Simultaneously?

SQL Server Tips

Why the Database Compatibility Level Matters in SQL Server?

SQL Server Security

Why Should You Care About Users With Elevated Permissions In SQL Server?

SQL Server Tips

Database Blogs – Top 18 List

SQL Server Health Check

SQL Server – Priority Boost Option

SQL Server Health Check

Enabling Lock Pages In Memory For SQL Server

SQL Server Performance Tuning

Database Engine Tuning Advisor (DTA) in Microsoft SQL Server

SQL Server Tips

Microsoft SQL Server Management Studio (SSMS)

SQL Server Tips

Easy Guide: Download and Install SQL Server Data Tools 2019 (SSDT 2019)

SQL Server Performance Tuning

How To Eliminate SQL Server Migrations Performance Degradation Risks With Distributed Replay (DReplay)

SQL Server Migrations & Upgrades

SQL Server Installation Configuration Guide

SQL Server Performance Tuning

Monitoring Deadlocks In The SQL Server

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 ➜