Article Library, Page 6
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 SecurityWhy Should You Care About Users With Elevated Permissions in SQL Server?Learn how to identify and manage elevated permissions in SQL Server to enhance security and follow best practices for least privilege access.
Guide · SQL Server TipsWhy the Database Compatibility Level Matters in SQL Server?The compatibility level is a setting for each database that adjusts specific behaviors to align with a particular SQL Server version.
Guide · SQL Server Migrations & Upgrades[Step-by-Step Guide] Configure Azure Managed Instance Replication to On-Premises SQL ServerLearn how to configure Azure SQL Managed Instance replication to on-premises SQL Server with this complete guide. Ensure optimal data synchronization.
Guide · SQL Server Health CheckTrace Flags in SQL ServerSQL Server trace flags are configuration handles that can enable or disable a specific SQL Server characteristic or change a particular SQL Server behavior.
Guide · SQL Server Performance TuningBest Practices for SQL Server StatisticsDiscover essential SQL Server statistics best practices to boost query speed, and optimize performance with Red9’s expert tips.
Guide · SQL Server TipsSQL Server Shrink: Best PracticesLearn why SQL database shrink is a bad idea and when it's necessary. Follow expert guidelines for safe and effective shrink operations.
Guide · SQL Server Health CheckSQL Server Remote Dedicated Admin Connection (DAC)It’s a diagnostic connection for a database administrator to access SQL. The DAC can make remote troubleshooting easier when SQL Server is unresponsive.
Guide · SQL Server Migrations & UpgradesBest Practices for SQL Server Availability on Amazon RDSAmazon RDS is a fully-managed database service that allows you to provision and run relational databases in the cloud
Guide · SQL Server Migrations & UpgradesSQL Server on Amazon RDSAmazon RDS is a managed database service that makes it easy to provision and run relational databases in the cloud. It supports several relational engines
Guide · SQL Server TipsManaging SQL Server Objects with SET OptionsSQL Server backward compatibility SET options allow legacy T-SQL code to run on newer SQL Server versions without changes while supporting ISO SQL standards
Guide · SQL Server Migrations & UpgradesSQL Server Migration to Amazon RDS StrategiesWe talked about availability and security best practices on Amazon RDS. Completing the series of posts, today we will learn about Migration on Amazon RDS
Guide · SQL Server TipsSQL Server Log File Too BigSQL Server log (LDF file) is too big - what causes log file too large, how to detect it, how to fix it and how to shrink it
Guide · SQL Server Migrations & UpgradesSQL Server High Availability (HA)If you need to introduce a high availability solution for one of your SQL Server databases, then there's lots of confusion as to what is the right option
Guide · SQL Server Performance TuningSQL Server Index Tuning for PerformanceSQL Server Index Tuning has a major impact on performance. Proper indexing is one of the quickest and most effective ways to boost SQL speed.
Guide · SQL Server Performance TuningWhy Picking the Right Data Types in SQL Server Matters6x more space: one wide key took 2,193MB vs 381MB. SQL Server data type choices decide speed, data integrity and storage.
Guide · SQL Server TipsSQL Server Change Tracking: Benefits, Limitations, and When to UseSQL Server Change Tracking records which rows changed. Check whether you need it, see where the overhead comes from and find databases using it.
Guide · SQL Server Migrations & UpgradesShould I Migrate My SQL Server to Linux?With SQL Server 2017, and now SQL Server 2019, SQL Server is available on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu.
Guide · SQL Server SecuritySQL Server Data Encryption and Your OptionsI recently got a question about how to encrypt a large SQL Server database for compliance reasons with minimal impact on software applications.
Guide · SQL Server Health CheckReview Your Windows Task Scheduler: It Can Impact Your SQL Server PerformanceIt is a Windows component that can schedule programs to run at pre-defined times or after specified time intervals.
Guide · SQL Server TipsSimple Recovery Model in SQL ServerSQL Server simple recovery model means no transaction log backups. See what you can restore and whether the possible data loss fits your needs.
Guide · SQL Server TipsNew Microsoft Software Assurance Benefits for SQL Server High Availability and Disaster RecoveryMicrosoft Software Assurance now grants SQL Server new HA and DR rights, including free passive and DR replicas. See what changed and who benefits.
Guide · SQL Server Health CheckBest Windows Power Plan for Optimizing SQL Server PerformanceUsually, the balanced power plan is set by default, which is what Microsoft recommends for general use.
Guide · SQL Server Migrations & UpgradesMigrating Microsoft SQL Server to Amazon AWS RDSUnderstand how AWS RDS handles SQL Server workloads - from licensing and storage to HA, compliance, and where the real platform limits show up.
Guide · SQL Server Health CheckSQL Server – Priority Boost OptionThe Priority Boost option looks like free speed, but it can starve the OS and crash your instance. Why Microsoft says leave it off, and the rare exception.
Guide · SQL Server TipsNever Use the Full Recovery Model Without a BackupIf you are using a database in Full Recovery Model or Bulk Logged Recovery Model, SQL Server does not free up the log file when your transactions finish.
Guide · SQL Server Performance Tuning[7 Tips] How to Improve T-SQL Query Performance7 quick tips that show you how to improve TSQL query performance. The BEST part: You don't need to be a PRO to use these! Anyone can!
Guide · SQL Server Migrations & UpgradesHow to Test SQL Server Migrations Using Log ShippingWhat is the key to SQL Upgrades project success? Preparation. Prep work is going to take 80-90% of the time.
Guide · SQL Server TipsHow to Re-Initialize SQL Server Merge Replication PublicationReinitialize SQL Server merge replication in SSMS. Follow the snapshot and subscription steps, then check synchronization in Replication Monitor.
Guide · SQL Server TipsMicrosoft Dynamics 365Microsoft Dynamics 365 is a cloud ERP and CRM enterprise platform for organizations announced by Microsoft in July 2016.
Guide · SQL Server SecurityEncrypting Drives on Live SQL Server with AlwaysOnEncrypting drives on SQL Server AlwaysOn? Review the guide's replica sequence, failover options and latency checks before planning the change.
Guide · SQL Server Health CheckKeep Your Jobs Safe Using SQL Agent NotificationsMissing SQL Server Agent job notifications? Find jobs that won't email on failure, then set the operator and notification option in SSMS.
Guide · SQL Server Performance TuningIncreasing Cost Threshold for Parallelism May Improve Your SQL Server PerformanceSQL Server's default cost threshold of 5 forces tiny queries to go parallel and waste CPU. What to raise it to, and how to find the right value.