Article Library, Page 7
Every Red9 article in one place, most recently updated first. Written by the senior DBAs who do the work.
- articles
- 208
- categories
- 6
All Articles
Guide · SQL Server Performance Tuning[Full Guide] What Are SQL Server Heap Tables and How to Find ThemDiscover what heap tables are and why they matter in SQL Server. Follow our guide to find and optimize heap tables for better performance.
Guide · SQL Server Health CheckFail-Safe Operator for SQL Server AgentA fail-safe operator is a backup user who receives the alert if the designated operator cannot be reached.
Guide · SQL Server Health CheckEnabling Lock Pages in Memory for SQL ServerIt is a security setting that allows accounts to keep data in physical memory, instead of paging it to disk.
Guide · SQL Server Health CheckDisabling Windows Automatic UpdatesControl Windows automatic updates on SQL Server hosts. This older guide covers manual update settings and patching during maintenance windows.
Guide · SQL Server Health CheckTop Tips for Optimal Performance After SQL Server InstallationReview SQL Server post-installation settings for TempDB, memory, MAXDOP, autogrowth, database paths, patching, and TCP/IP connectivity.
Guide · SQL Server Security[Security Best Practices] SQL Server on Amazon RDSSecure your SQL Server on Amazon RDS with IAM, VPC subnet control, auditing, and encryption (KMS, TDE, SSL). Follow these proven best practices.
Guide · SQL Server TipsChoosing the Right Azure SQL Service Database: A Complete GuideIn the recent past, Microsoft introduced Azure SQL, bringing all the SQL Server products in one suite.
Guide · SQL Server Performance TuningHow Triggers Affect Your SQL Server PerformanceTriggers can slow your SQL performance down or they can be a savior in some admin tool. See when to use them, when not and more.
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 Tuning7 T-SQL Development Tips for Faster QueriesToday I will let know some essential techniques that never change to make your queries run faster in the Microsoft SQL Server!
Guide · SQL Server Performance TuningPerformance Tuning Techniques for SQL Server ReplicationFollow these 17 replication performance tuning steps to get SQL transactional replication to go faster than you could imagine
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 Health Check“Optimize for Ad Hoc Workloads” Option and SQL PerformanceThe Optimize for Ad Hoc Workloads setting stops one-off queries from bloating your plan cache. When to enable it, and the memory it frees up.
Guide · SQL Server TipsMicrosoft SQL Server License Guide: Complete BreakdownConfused by SQL Server licensing? This 2025 guide breaks down core vs. CAL models, cloud rules, editions, and pricing to help you license SQL right.
Guide · SQL Server Performance TuningSQL Server Performance Tuning Using IndexesSQL Server indexes can speed reads and slow writes. See how clustered, nonclustered and covering indexes affect filters, joins and query performance.
Guide · SQL Server TipsResources to Microsoft SQL ServerDiscover a comprehensive list of free resources for Microsoft SQL Server. Download now and enhance your database management skills.