Article Library, Page 2
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 TuningWasting CPU for Implicit Conversions in SQL ServerImplicit conversions waste SQL performance. What they are, why should you care, how to detect and how to fix implicit conversion problem in SQL Server.
Guide · SQL Server TipsAzure Stack On-Premises & How It’ll Blow Your MindNotes from an Azure Stack presentation: running Azure services on premises, disconnected deployments and use cases where data must stay local.
Guide · SQL Server TipsHow to Use SQL Server FILESTREAM Feature for Large DatabasesThis feature allows adding unstructured documents into the database. You can store images, PDFs, videos, or other files into the SQL Server.
Guide · SQL Server Performance Tuning54-Step SQL Server Setup ChecklistDiscover our SQL Server setup checklist, based on proven expertise. Secret tuning tips to boost your server's performance above 90% of others.
Guide · SQL Server SecuritySQL Server xp_cmdshell: Executive Guide to Risk, Governance, and Safer Alternativesxp_cmdshell runs OS commands under the SQL Server service account, a real attack path. When to disable it, when it is safe, and how to lock it down.
Guide · SQL Server Health CheckOla Hallengren Maintenance for SQL Server [Full Guide]Set up the Ola Hallengren maintenance solution on SQL Server: backups, integrity checks, and index jobs, with the exact steps and settings to use.
Guide · SQL Server TipsHow to Install DBATools Powershell Module for SQL Server [Full Guide]Install the dbatools PowerShell module and put 500+ SQL Server commands to work on backups, migrations, and checks. Step-by-step setup for Windows.
Guide · SQL Server Performance TuningHow to Check SQL Server Disk Formatting: The 4KB Mistake Costing You PerformanceFormatting SQL Server data disks at the 4KB default can cost you real throughput. Why 64KB allocation units matter, how to check yours, and how to fix it.
Guide · SQL Server Migrations & Upgrades[Pros & Cons] Azure SQL Managed InstancesAzure SQL Managed Instance or Azure SQL Database? Compare SQL Agent support, cross-database queries, backups and migration limits before you choose.
Guide · SQL Server TipsHow to Fix SQL Server Recovery Pending ModeSQL Server Recovery Pending? Read the error log, check file access and confirm backups. Follow a safe recovery order; data-loss repair is the last resort.
Guide · SQL Server Migrations & UpgradesAmazon SQL RDS vs Azure SQL – [Ultimate Showdown]Compare SQL Server on AWS RDS vs Azure across scalability, pricing, version support, and architecture to choose the right cloud fit for your SQL workloads.
Guide · SQL Server Performance TuningSQL Server NOLOCK: Faster Reads, Wrong Answers, and What to Use InsteadSQL NOLOCK is READ UNCOMMITTED: dirty reads, missed or doubled rows, error 601. When it's safe, and how RCSI, SNAPSHOT and SQL Server 2025 reduce blocking.
Guide · SQL Server Migrations & UpgradesSQL Server High Availability – All You Need to KnowYou probably heard Service Level Agreement (SLA), Recovery Time Objective (RTO) and Recovery Point Objective (RPO) terminology.
Guide · SQL Server Performance TuningMonitoring Deadlocks in the SQL ServerA deadlock occurs when there is a cyclic dependency between two or more threads, or processes, for some set of resources within SQL Server.
Guide · SQL Server Performance TuningHow to Enable SQL Server Query Store [Best Practices]Enable Query Store in SQL Server in three steps. Check permissions and existing settings first, choose capture options, and verify that data is collected.
Guide · SQL Server Migrations & UpgradesSQL Server Always On Availability Groups: What They Protect, What They Cost, Where They BreakAlways On availability groups for SQL Server 2016-2025: replica limits, sync vs async, Standard vs Enterprise, licensing rules, and a health-check query.
Guide · SQL Server Performance TuningThe SQL Server Memory Setting That Might Be Killing Your PerformanceReview SQL Server's max server memory setting, leave room for Windows and other workloads, and learn how to change the limit without restarting SQL Server.
Guide · SQL Server Migrations & UpgradesSQL Server 2016 End of Life: The Breaking Changes Nobody’s AuditingExtended support ended July 14, 2026. Paid ESUs run to July 2029, even on Azure VMs. Weigh them against an upgrade to 2022 or 2025, and see what breaks.
Guide · SQL Server Migrations & UpgradesSQL Server End of Life: Avoid Costly Downtime & Security DisastersSQL Server 2016 support ended July 14, 2026 and 2017 ends October 12, 2027. Official Microsoft dates for 2012 to 2025, ESU status and what to do next.
Guide · SQL Server Performance TuningSQL JOINs Venn Diagram: A Visual GuideConfused by INNER vs LEFT JOIN? See every SQL join as a simple Venn diagram, with copy-paste examples that make the difference click in seconds.
Client Result · SQL Server Performance TuningHow We Cut a Trigger's Disk Reads by 8,909 TimesA SELECT inside a trigger scanned an index on every insert and update. One new index cut reads from 245,011 pages to about 27 and made it 9.4x faster.
Client Result · SQL Server Performance TuningHow We Made a Stored Procedure Almost 5 Times FasterA stored procedure found through Query Store was putting pressure on CPU. Temp tables and an indexed view cut the average run from 18.8 seconds to 4 seconds.
Guide · SQL Server Performance TuningHow to Troubleshoot a Slow-Running Query Using Wait Stats in SQL Server?Learn how to use wait stats in SQL Server to find and fix slow queries. Our guide provides expert tips & hacks to optimize your query performance.
Guide · SQL Server Performance TuningForcing Index, Order, and Join Hints and Being CarefulSQL Server index hints can break queries when an index is removed. Find forced index, join and order hints, then review whether they still belong.
Guide · SQL Server TipsDangerous SQL Server BuildsSome SQL Server builds ship known data-corruption or crash bugs. How to check whether yours is one of them, and the safe cumulative update to move to.
Guide · SQL Server TipsEasy Guide: Download and Install SQL Server Data Tools 2019 (SSDT 2019)Complete Guide: Step-by-Step Installation and Configuration of SQL Server Data Tools in Visual Studio 2019
Guide · SQL Server Migrations & UpgradesSQL Server AlwaysOn Cluster Patching Windows OS: Step-by-Step GuidePatch a SQL Server Always On availability group without downtime: the exact rolling order for secondaries, failover, and primary, step by step.
Guide · SQL Server Health CheckHow High Virtual Log File (VLF) Count Kills SQL PerformanceToo many virtual log files slow startup, backups, and recovery. Count your VLFs, shrink and regrow the log correctly, and keep the number under control.
Guide · SQL Server Performance TuningBest Practices for Performance Counters in Microsoft SQL ServerMaster SQL Server optimization with our Windows Performance Counters guide. Discover top tips to boost performance and efficiency.
Client Result · SQL Server Performance TuningHow We Found the VM Cap Costing Our Client $30K in Wasted SQL Server SpendOur client's Azure SQL environment cost $30K/month. One VM instance change at $500/month outperformed the original servers. Here's the setting most teams miss.
Guide · SQL Server TipsSQL Server DBA Cost 2026: The 8 Budget Lines Most IT Teams MissA full-time SQL Server DBA covers just 40 of 168 hours a week, and salary is only about 70% of the real cost. In-house vs. managed, fully broken down.
Guide · SQL Server Migrations & UpgradesSQL Server 2025 Has No SSRS Release. Here’s What That Means for Your MigrationSQL Server 2025 ships without Reporting Services. What happens to your existing reports and the migration paths (Power BI Report Server) that replace it.