Article Library, Page 3
Every Red9 article in one place, most recently updated first. Written by the senior DBAs who do the work.
- articles
- 220
- categories
- 6
All Articles
Guide · SQL Server Performance TuningETL Process Optimization: A Practical Guide for SQL Server TeamsExact SQL Server ETL settings that cut runtime 80-95%: CDC config, SSIS parallelism, columnstore batch sizing, and the DMV queries to prove it.
Client Result · SQL Server Performance TuningHow We Cut SQL Server Costs in Half and Added HA for FreeA client had 8 cores on an Azure VM and wanted more. We tuned queries and indexes instead: CPU fell 30%, and we then downsized and added HA at no extra spend.
Client Result · SQL Server Migrations & UpgradesHow We Cut SQL Server Licensing Costs by 75% With Azure Migration for a Client75% lower SQL Server licensing costs: 32 cores to 8 vCores in Azure, 3TB moved with 15 minutes of downtime, $48K annual savings.
Client Result · SQL Server Performance TuningHow We Made a Warehouse Management System 6.5x Faster by Fixing One SQL Server ConstraintYour vendor says buy more hardware. We fixed slow batch processing with 4 lines of SQL instead. 6.5x faster performance, $50K+ saved. Here's the blueprint.
Client Result · SQL Server Migrations & UpgradesHow We Saved a Professional Services Firm $117,654 Annually by Right-Sizing Their SQL Server InfrastructureLearn how we saved a firm $117,654 annually by optimizing Azure SQL Server licensing and infrastructure. Real case study with detailed costs and tech insights.
Guide · SQL Server Performance TuningWhat to Do When Your SQL Server Critical Report Starts Timing Out on Friday EveningReal SQL Server emergency case study: How we fixed a manufacturing client's critical report timeout in 90 minutes and broke their crisis-fix-repeat cycle.
Client Result · SQL Server Performance TuningCase Study: How Red9 Transformed SQL Server Performance and Saved 66+ Minutes of Daily Processing in 6 WeeksSee how Red9 fixed config, tuned queries, and right-sized Azure to slash CPU and runtime in 6 weeks, processing 120M+ transactions at 6.42% usage.
Guide · SQL Server Migrations & UpgradesSQL Server 2025 Released: AI Integration, Developer Features, and Performance GainsSQL Server 2025 ships AI vector search, native JSON, RegEx, and 40+ engine changes. A full feature overview for teams weighing the upgrade.
Guide · SQL Server SecurityEnterprise SQL Server Security: Beyond Basic ProtectionImplement enterprise-grade SQL Server security beyond default settings. Covers HIPAA, SOX compliance, and advanced threat protection strategies.
Guide · SQL Server Performance TuningSQL Query Optimization: A Practical Guide for Database Admins and Developers34 practical ways to make SQL queries faster, from indexing and SARGable predicates to reading execution plans, each with a copy-paste example.
Guide · SQL Server Health Check[Quick Guide] Autogrowth in SQL Server: Best PracticesBad autogrowth settings fragment your files and stall writes. Set fixed-size increments, pre-size the files, and keep SQL Server fast under heavy load.
Guide · SQL Server Migrations & Upgrades[Step-by-Step] Migrating SQL Server to Azure SQL DatabaseStep-by-step guide to migrate SQL Server to Azure SQL Database. Covers tools, offline vs. online options, Managed Instance, BACPAC, DMS & performance tips.
Client Result · SQL Server Performance TuningHow a Simple VMware Misconfiguration Cost Our Client Months of Performance IssuesA simple VMware misconfiguration caused months of performance issues for our client. Here's how to check if you have the same problem.
Client Result · SQL Server Migrations & Upgrades4 Hidden Ways Sales Reps Overcharge You for SQL Server Licensing (Real Restaurant Chain Example)Learn how a 3,000+ restaurant chain nearly wasted $22K on SQL Server licensing - and discover 4 secrets to cut your own costs by up to 50%.
Guide · SQL Server TipsComparison of SQL on Virtual Machine (VM) vs Azure Managed Instance (MI) vs Azure SQL Database (DB)Choosing SQL Server on a VM, Managed Instance, or Azure SQL Database? Compare control, cost, and migration effort so you can pick the right one fast.
Guide · SQL Server Health CheckHow to Identify Deprecated Features in Use on a SQL Server Instance?Deprecated features can break after a SQL Server upgrade. Run THIS TSQL & see where you still use deprecated calls, and what's next.
Guide · SQL Server Health CheckTempDB Best Practices for Optimal PerformanceLearn what TempDB is and why its performance matters. Discover TempDB best practices from experts to enhance SQL Server efficiency.
Guide · SQL Server Migrations & UpgradesDifferent Ways to Sync SQL Server Data From Azure to On-Premise SQL ServerExplore ways to sync SQL Server data between Azure and on-premises with Azure Data Sync and Transactional Replication for hybrid cloud setup.
Research & StatisticsCloud Computing Statistics (2026)20 cloud computing statistics for 2026: an estimated $122B wasted in 2025 and spending forecast to top $1T in 2026. All dated and sourced.
Guide · SQL Server Performance TuningMethods for Performance Tuning on Azure SQL DatabaseSince Azure SQL Database is database-scoped, there are some significant differences when it comes to performance tuning.
Guide · SQL Server Performance TuningWhen Was the Last Time Your SQL Server Wait Stats Were Cleared?Wait statistics tell you exactly what SQL Server is waiting on. The top wait types, what each one means, and the query to find your worst offenders.
Guide · SQL Server SecurityLittle Bobby Tables and SQL Injection?The xkcd Bobby Tables comic in plain English: what the SQL injection joke means, why it actually works, and the one line of code that stops it.
Guide · SQL Server Health CheckIs Your SQL Server Generating Dump Files?Learn what a dump file is and why it matters. Get precise steps to find and fix SQL Server dump files quickly.
Client Result · SQL Server Performance TuningHow SQL Tuning Saved Six Figures and Cut Cores by 75%A client was about to buy more cores. We tuned queries and indexes instead, cut CPU 75%, and saved six figures in licensing. Here is what we changed.
Guide · SQL Server Performance TuningYou Scaled Your VM to 32 Cores. Your TempDB Configuration Didn’tYou scaled the VM but SQL Server did not get faster. TempDB contention is often why, and adding cores can make it worse. How to configure TempDB right.
Guide · SQL Server Performance TuningSQL Server Parameter Sniffing: What It Is and How to Fix ItWhen a query that was fast turns slow for no reason, parameter sniffing is often why. What causes it and five fixes, from RECOMPILE to Query Store.
Research & StatisticsData Analytics Statistics (2026)88% of organizations now use AI, but only 12% say their data is AI-ready. See 40+ data analytics statistics for 2026, each dated and primary-sourced.
Research & Statistics40+ Big Data Statistics (2026): Market Size, Volume & TrendsEvery number dated and traced to a primary source: market size, data volume, cloud spend, jobs and privacy. 40+ big data statistics for 2026.
Guide · SQL Server Performance TuningWhy Your App Got Slow After Migrating SQL Server to AzureWe tuned compute, IOPS, and tempdb. Users still complained. Here's what actually caused the slowdown, and how to test for it before you cut over.
Guide · SQL Server TipsHow to Spend $10k on SQL Monitoring and Still Fix NothingSome companies spend more on monitoring dashboards than on the DBAs who read them. Why the tool-to-expertise ratio matters more than the tool you buy.
Client Result · SQL Server Health CheckVM Snapshots Are Not SQL Server Backups: A Disaster Recovery StoryA SQL Server cluster died with no native backups - only VM snapshots. Here's what went wrong, how we recovered it, and what a proper backup strategy looks like.
Guide · SQL Server TipsStop Running Other Applications on Your SQL ServerBefore you add cores or upgrade licenses, check one common mistake that quietly wrecks SQL Server performance.