Sitemap
Every page on red9.com in one place: our SQL Server services, company info, client results, free tools, and the full article library.
Services 12 links
Back to topAbout Red9 5 links
Back to topTools & Resources 30 links
Back to top- SQL Server Health Check Tool
- Instant SQL Formatter & Beautifier
- Database Popularity Ranking
- SQL Server Builds
DB Comparisons: AWS vs. Azure vs. On-Premises
- Amazon RDS vs EC2
- AWS EC2 vs Azure SQL DB
- AWS EC2 vs Azure SQL Managed Instance
- AWS EC2 vs SQL Server on Azure VM
- AWS EC2 vs SQL Server On-Premises
- AWS RDS for SQL Server
- AWS RDS vs Azure SQL DB vs SQL Server On-Premises
- Azure SQL Database
- Azure SQL Database vs Amazon RDS
- Azure SQL Database vs SQL Server On-Premises
- Azure SQL DB vs SQL MI vs AWS RDS
- Azure SQL Managed Instance
- Azure SQL Managed Instance vs AWS RDS
- Azure SQL Managed Instance vs Azure SQL Database
- Azure SQL Managed Instance vs SQL Server On-Premises
- Azure VM vs AWS EC2 vs Azure SQL MI
- Azure VM vs Azure SQL Database
- Azure VM vs Azure SQL MI
- Azure VM vs SQL Server On-Premises
- EC2 vs Azure VM vs On-Premises
- SQL Server on AWS EC2
- SQL Server on Azure VM
- SQL Server on Azure VM vs AWS RDS
- SQL Server On-Premises
- SQL Server On-Premises vs AWS RDS
Case Studies 22 links
Back to topMore client results 18
- How We Found the VM Cap Costing Our Client $30K in Wasted SQL Server Spend
- How SQL Tuning Saved Six Figures and Cut Cores by 75%
- How We Cut SQL Server Costs in Half and Added HA for Free
- VM Snapshots Are Not SQL Server Backups: A Disaster Recovery Story
- A Client Lost 1.5 Months of Data and It Wasn’t a Cyberattack
- How a Simple VMware Misconfiguration Cost Our Client Months of Performance Issues
- How We Cut SQL Server Licensing Costs by 75% With Azure Migration For a Client
- How We Made a Warehouse Management System 6.5x Faster by Fixing One SQL Server Constraint
- How We Saved a Professional Services Firm $117,654 Annually by Right-Sizing Their SQL Server Infrastructure
- SQL Server Emergency Recovery: How We Saved a Corrupted Database Without Backups
- How Real Workload Testing Cut Azure SQL Hyperscale Costs by 46% and Saved $86,000 a Year
- Case Study: How Red9 Transformed SQL Server Performance and Saved 66+ Minutes of Daily Processing in 6 Weeks
- Why SQL Server Backups Fail When You Need Them Most: A 3-Month Bank Outage Case Study
- 4 Hidden Ways Sales Reps Overcharge You for SQL Server Licensing (Real Restaurant Chain Example)
- [Case Study] How to Size Azure Managed Instance & Avoid Overspending
- How We Slashed SQL Query Disk Read Operations by 1,152 Times
- How We Made T-SQL Queries Run 34,785 Times Faster
- How We Made a T-SQL Query Run 17,000x Faster
Consulting Locations 46 links
Back to topSQL Server consultants in:
- SQL Server Consultants in Arlington, TX
- SQL Server Consultants in Atlanta, GA
- SQL Server Consultants in Austin, TX
- SQL Server Consultants in Boston, MA
- SQL Server Consultants in Buffalo, NY
- SQL Server Consultants in Charlotte, NC
- SQL Server Consultants in Chicago, IL
- SQL Server Consultants in Cleveland, OH
- SQL Server Consultants in Colorado Springs, CO
- SQL Server Consultants in Columbus, OH
- SQL Server Consultants in Dallas, TX
- SQL Server Consultants in Denver, CO
- SQL Server Consultants in Detroit, MI
- SQL Server Consultants in El Paso, TX
- SQL Server Consultants in Fort Worth, TX
- SQL Server Consultants in Fresno, CA
- SQL Server Consultants in Honolulu, HI
- SQL Server Consultants in Houston, TX
- SQL Server Consultants in Indianapolis, IN
- SQL Server Consultants in Jacksonville, FL
- SQL Server Consultants in Kansas City, MO
- SQL Server Consultants in Las Vegas, NV
- SQL Server Consultants in Memphis, TN
- SQL Server Consultants in Miami, FL
- SQL Server Consultants in Milwaukee, WI
- SQL Server Consultants in Minneapolis, MN
- SQL Server Consultants in New York, NY
- SQL Server Consultants in Oklahoma City, OK
- SQL Server Consultants in Omaha, NE
- SQL Server Consultants in Orlando, FL
- SQL Server Consultants in Philadelphia, PA
- SQL Server Consultants in Phoenix, AZ
- SQL Server Consultants in Pittsburgh, PA
- SQL Server Consultants in Portland, OR
- SQL Server Consultants in Raleigh, NC
- SQL Server Consultants in Richmond, VA
- SQL Server Consultants in Sacramento, CA
- SQL Server Consultants in San Antonio, TX
- SQL Server Consultants in San Diego, CA
- SQL Server Consultants in San Jose, CA
- SQL Server Consultants in Seattle, WA
- SQL Server Consultants in St. Louis, MO
- SQL Server Consultants in Tampa, FL
- SQL Server Consultants in Tucson, AZ
- SQL Server Consultants in Virginia Beach, VA
Blog & Articles 179 links
Back to top- SQL Server Migrations & Upgrades
- SQL Server Performance Tuning
- SQL Server Security
- SQL Server Tips
- SQL Server Health Check Articles
All articles, newest first 173
2026
- SQL Server NOLOCK: Faster Reads, Wrong Answers, and What to Use Instead
- SQL Server Always On Availability Groups: What They Protect, What They Cost, Where They Break
- Cloud Computing Statistics (2026)
- Data Analytics Statistics (2026)
- 40+ Big Data Statistics for 2026: Market Size, Volume, and Where the Data Goes
- 50+ Outsourcing Statistics for 2026: Market Size, AI, and Where the Money Goes
- SQL Server DBA Cost 2026: The 8 Budget Lines Most IT Teams Miss
- SQL Server 2025 Has No SSRS Release. Here’s What That Means for Your Migration
- Why Your App Got Slow After Migrating SQL Server to Azure
- ETL Process Optimization: A Practical Guide for SQL Server Teams
- SQL Server 2016 End of Support: It Ended July 14, 2026. Here’s What to Do Now
- You Scaled Your VM to 32 Cores. Your TempDB Configuration Didn’t
- How to Spend $10k on SQL Monitoring and Still Fix Nothing
- Restarting SQL Server? You’re Destroying the Evidence.
- SQL Server Enterprise Edition Is Not a Must
- Stop Running Other Applications on Your SQL Server
- AI Won’t Replace Your Senior DBAs. Here’s What It Actually Does.
- Your SQL Server Is Logging Deadlocks – Are You Reading Them?
- Why Your SQL Server Column Design Could Be Costing You 20% of Your CPU Power
2025
- How to Check SQL Server Disk Formatting: The 4KB Mistake Costing You Performance
- Oracle Database (19c 23ai): A C-Level Overview for 2025
- SQL Server xp_cmdshell: executive guide to risk, governance, and safer alternatives
- What To Do When Your SQL Server Critical Report Starts Timing Out on Friday Evening
- SQL Server Monitoring & Alerts and Why Most Companies Are Doing It Wrong
- The CTO How-to Guide to SQL Server Migration: A Decision Framework
- SQL Server 2025 Released: AI Integration, Developer Features, and Performance Gains
- The SQL Server Software Assurance Guide
- SQL Server Security Best Practices: The 12-Step Hierarchy
- What Is MySQL? How It Works and When to Use It
- Microsoft SQL Server: Definitive Guide
- The Complete SQL Server Migration Strategy Guide
- The $4 Million Mistake: True Enterprise Database Downtime Cost in 2025
- The SQL Server Memory Setting That Might Be Killing Your Performance
- SQL Server End of Life Dates: Every Version from 2012 to 2025
- SQL Server Enterprise vs. Standard Edition: When to Downgrade and Save $6,000 Per Core
- Enterprise SQL Server Security: Beyond Basic Protection
- SQL JOINs Venn Diagram: A Visual Guide
- Why Shrinking SQL Server Databases Is Almost Always a Terrible Idea
- How to Identify and Fix Orphaned Users in SQL Server (And Why It Matters)
2024
- Comparison of SQL on Virtual Machine (VM) vs Azure Managed Instance (MI) vs Azure SQL Database (DB)
- 9 Sample SQL Databases for Practice to Download & Set Up in Minutes
- 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
- Why Setting Up Right SQL Job Owner Matters?
- SQL Server Database Assessments
- Easy Guide: Download and Install SQL Server Data Tools 2019 (SSDT 2019)
- How To Eliminate SQL Server Migrations Performance Degradation Risks With Distributed Replay (DReplay)
- How to Fix SQL Server Recovery Pending Mode
- Why Disk Operations Matter The Most When Tuning T-SQL Calls For Performance
- Why Should You Care About CLR Integration In SQL Server?
- Methods for Performance Tuning on Azure SQL Database
- SQL Server Parameter Sniffing: What It Is and How to Fix It
- Top 10 SQL Server Performance Tuning Mistakes
- How to Check MaxDOP in SQL Server and Set it for Optimal Performance
- Two Most Important Decisions In Disaster Recovery – RPO And RTO
- Using PowerShell To Monitor Disk Usage
- Wasting CPU For Implicit Conversions In SQL Server
- When Was The Last Time Your SQL Server Wait Stats Were Cleared?
- [Step-by-Step Guide] Configure Azure Managed Instance Replication to On-Premises SQL Server
- Stored Procedures and RECOMPILE Option: When and Why to Use It
- The Risks Of SQL Server Differential Backups
- Untrusted Foreign Keys And Constraints Can Degrade Your SQL Server Performance
- Why Should You Care About Users With Elevated Permissions In SQL Server?
- Why the Database Compatibility Level Matters in SQL Server?
- SQL Server Performance Has Been Tuned, But What I Got Is “I Cant Feel It!” Wait! What??
- The Proper Way To Set Up SQL Server Alerts
- Trace Flags In SQL Server
- Best Practices For SQL Server Statistics
- SQL Server Startup Parameters
- SQL Server Shrink: Best Practices
- Best Practices for SQL Server Availability on Amazon RDS
- SQL Server Monitoring Software Tools
- SQL Server On Amazon RDS
- SQL Server Page Verification CHECKSUM
- SQL Server Remote Dedicated Admin Connection (DAC)
- Main Differences Between MS SQL Server Native Backups And 3rd Party Tools
- Managing SQL Server Objects with SET Options
- SQL Server Log File Too Big
- SQL Server Max Memory Parameter
- SQL Server Migration To Amazon RDS Strategies
- SQL Server High Availability – All You Need To Know
- SQL Server High Availability (HA)
- SQL Server Change Tracking: Benefits, Limitations, and When to Use
- SQL Server Index Tuning for Performance
- Why Picking the Right Data Types in SQL Server Matters
- Why Should You Enable SQL Server Database Backup Compression By Default?
- Page Life Expectancy & Why Should You Care?
- Removing Offline Databases And Orphaned Data Files From Your SQL Server
- Review Your Windows Task Scheduler: It Can Impact Your SQL Server Performance
- Should I Migrate My SQL Server To Linux?
- SQL Server Data Encryption And Your Options
- New Microsoft Software Assurance Benefits For SQL Server High Availability And Disaster Recovery
- Optimal Windows OS Page File Settings For SQL Server
- Simple Recovery Model In SQL Server
- SQL Server AlwaysOn Cluster Patching Windows OS: Step-by-Step Guide
- Best Windows Power Plan for Optimizing SQL Server Performance
- Microsoft SQL Server Migration Strategies To AWS
- Migrating Microsoft SQL Server To Amazon AWS RDS
- Microsoft SQL Server Management Studio (SSMS): Download & Install
- Monitoring Deadlocks In The SQL Server
- Never Use The Full Recovery Model Without A Backup
- SQL Server – Priority Boost Option
- [7 Tips] How to Improve T-SQL Query Performance
- How To Prevent SQL Injections
- How To Re-Initialize SQL Server Merge Replication Publication
- How To Test SQL Server Migrations Using Log Shipping
- How To Troubleshoot A Slow-Running Query Using Wait Stats In SQL Server?
- [3 step process] How to Check for Updates in SQL Server Management Studio (SSMS)
- 7 Essential SQL Server DMV Queries Every Admin Should Know
- Encrypting Drives on Live SQL Server with AlwaysOn
- How To Identify Deprecated Features In Use On A SQL Server Instance?
- Keep Your Jobs Safe Using SQL Agent Notifications
- Little Bobby Tables And SQL Injection?
- Microsoft Dynamics 365
- [4 ways] How To Check SQL Server Error Log Location?
- How Many CPUs Is Your SQL Server Able To Use?
- How to Configure Antivirus for SQL Server (and Improve Performance)
- How To Enable SQL Server Query Store [Best Practices]
- Increasing Cost Threshold For Parallelism May Improve Your SQL Server Performance
- Is Your SQL Server Generating Dump Files?
- Keep SQL Server Backups Safe: Best Practices
- Forcing Index, Order, And Join Hints And Being Careful
- Hardware And Performance Tuning In SQL Server
- How Can You Find The SQL Server Jobs That Start Simultaneously?
- How High Virtual Log File (VLF) Count Kills SQL Performance
- Improve SQL Server Performance By Enabling Instant File Initialization
- Improve Your SQL Server Performance Enabling Data Compression
- Improve Your SQL Server Transaction Log Performance Using Delayed Durability
- Dangerous SQL Server Builds
- Database Blogs – Top 18 List
- Database Engine Tuning Advisor (DTA) in Microsoft SQL Server
- Disable Unnecessary SQL Server Instances And Services
- Disabling Windows “Visual Effects” To Boost Performance
- Ola Hallengren Maintenance for SQL Server [Full Guide]
- SQL Server Agent Job History Retention
- TempDB Best Practices for Optimal Performance
- Best Practices For Performance Counters In Microsoft SQL Server
- Best Practices For The SQL Server Error Log
- Disabling Windows Automatic Updates
- Enabling Lock Pages In Memory For SQL Server
- Fail-Safe Operator For SQL Server Agent
- Finding User Tables In SQL Server System Databases
- [Full Guide] What Are SQL Server Heap Tables and How to Find Them
- [Tried & Tested] SQL Server Disk Configuration Best Practices
- [Security Best Practices] SQL Server On Amazon RDS
- Top Tips for Optimal Performance After SQL Server Installation
- Azure Stack On-Premises & How It’ll Blow Your Mind
- Choosing the Right Azure SQL Service Database: A Complete Guide
- How to Install DBATools Powershell Module for SQL Server [Full Guide]
- How Triggers Affect Your SQL Server Performance
- [Pros & Cons] Azure SQL Managed Instances
- [Quick Guide] Autogrowth in SQL Server: Best Practices
- [Complete Guide] Amazon RDS Managed Instance
- 7 T-SQL Development Tips For Faster Queries
- How To Use SQL Server FILESTREAM Feature For Large Databases
- Performance Tuning Techniques For SQL Server Replication
- Selecting the Right Database for Your Application
- Unlock the Secrets: How to Choose the Best Encryption Feature for SQL Server
- 54-Step SQL Server Setup Checklist
- Azure SQL And Security Best Practices
- SQL Server Installation Configuration Guide
- SQL Server Migration To Amazon RDS
- AWS Storage Types Comparison: A Complete Overview (S3, EBS, EFS)
- “Optimize For Ad Hoc Workloads” Option And SQL Performance
- Comparing Performance of Two SQL Servers: Part 2
- Amazon SQL RDS vs Azure SQL – [Ultimate Showdown]
- Microsoft SQL Server License Guide: Complete Breakdown
- SQL Server Performance Tuning Using Indexes
- [Step-by-Step] Migrating SQL Server to Azure SQL Database
- What Is Cursor in SQL Server And Why Is It Used?
- Comparing Performance of Two SQL Servers: Part 1
- Resources To Microsoft SQL Server