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
Fail-Safe Operator For SQL Server Agent
SQL Server Log File Too Big
Improve Your SQL Server Transaction Log Performance Using Delayed Durability
Using PowerShell To Monitor Disk Usage
How Triggers Affect Your SQL Server Performance
SQL Server Max Memory Parameter
Best Practices For SQL Server Statistics
How to Configure Antivirus for SQL Server (and Improve Performance)
Main Differences Between MS SQL Server Native Backups And 3rd Party Tools
Comparing Performance of Two SQL Servers: Part 1
Azure SQL And Security Best Practices
Trace Flags In SQL Server
Choosing the Right Azure SQL Service Database: A Complete Guide
Why Should You Enable SQL Server Database Backup Compression By Default?
How to Check MaxDOP in SQL Server and Set it for Optimal Performance
SQL Server Performance Tuning Using Indexes
How To Re-Initialize SQL Server Merge Replication Publication
The Risks Of SQL Server Differential Backups
Top 10 SQL Server Performance Tuning Mistakes
Microsoft SQL Server License Guide: Complete Breakdown
SQL Server Index Tuning for Performance
Methods for Performance Tuning on Azure SQL Database
Amazon SQL RDS vs Azure SQL – [Ultimate Showdown]
How Can You Find The SQL Server Jobs That Start Simultaneously?
Why the Database Compatibility Level Matters in SQL Server?
Why Should You Care About Users With Elevated Permissions In SQL Server?
Database Blogs – Top 18 List
SQL Server – Priority Boost Option
Enabling Lock Pages In Memory For SQL Server
Database Engine Tuning Advisor (DTA) in Microsoft SQL Server
Microsoft SQL Server Management Studio (SSMS): Download & Install
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.