Article Library, Page 4
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
Client Result · SQL Server TipsA Client Lost 1.5 Months of Data and It Wasn’t a CyberattackA client panicked after a server move, forced emergency mode, overwrote the MDF, and lost 6 weeks of data. The backup chain was already broken.
Guide · SQL Server Performance TuningYour SQL Server Is Logging Deadlocks – Are You Reading Them?A DBA flew blind for 2 years while SQL Server recorded every deadlock. The fix was already built in. They just never queried it.
Client Result · SQL Server TipsSQL Server Emergency Recovery: How We Saved a Corrupted Database Without BackupsWe recovered a corrupted SQL Server database without backups after a hard drive crash. Here's the emergency recovery process and what it actually cost.
Guide · SQL Server TipsWhat Is MySQL? How It Works and When to Use ItWhat is MySQL? A practical guide for dev teams covering how it works, what it’s best at, and when to choose it over other databases.
Guide · SQL Server TipsUsing PowerShell to Monitor Disk UsagePart of the database and system administrator's daily routine consists of monitoring disk usage. It can be achieved manually; however, it is much more logical
Guide · SQL Server TipsSelecting the Right Database for Your ApplicationTrying to pick the right database for your app? This guide breaks down 8 types, from key-value to graph and ledger, to help you choose the best fit.
Guide · SQL Server SecurityUnlock the Secrets: How to Choose the Best Encryption Feature for SQL ServerExplore SQL Server and Azure encryption technologies. Learn how to choose and combine them for layered security. Find the best option for you!
Guide · SQL Server SecuritySQL Server Migration to Amazon RDSWe talked about availability and security best practices on Amazon RDS. Completing the series of posts, today we will know about Migration on Amazon RDS using
Guide · SQL Server Migrations & UpgradesSQL Server Installation Configuration GuideGet SQL Server installation right before the first query runs. Check storage, features, instance settings and service-account permissions.
Guide · SQL Server Performance TuningComparing Performance of Two SQL Servers: Part 2Compare SQL Server performance with a replay of the same workload. This legacy guide walks through capture, replay and per-query results.
Guide · SQL Server Performance TuningComparing Performance of Two SQL Servers: Part 1SQL Server performance testing should use your real workload. This legacy Distributed Replay guide compares old and new servers before you migrate.
Guide · SQL Server SecuritySQL Server Security Best Practices: The 12-Step HierarchyLearn the 12-step SQL Server security hierarchy that 87% of companies get backwards. Start with 5-minute implementations that provide 80% protection.
Client Result · SQL Server Performance TuningHow We Slashed SQL Query Disk Read Operations by 1,152 TimesDiscover a simple optimization trick that reduced the number of disk reads from over 800k to less than 1k. Click to read the step-by-step guide!
Guide · SQL Server TipsThe Risks of SQL Server Differential BackupsSQL Server differential backups depend on the right full backup. See what changes the backup base and what you need for a successful restore.
Guide · SQL Server Health CheckSQL Server Startup ParametersWhen you install SQL Server, setup writes a set of default startup options in the Microsoft Windows registry that influences how it is started.
Guide · SQL Server Health CheckSQL Server Page Verification CHECKSUMPAGE_VERIFY CHECKSUM lets SQL Server catch disk corruption before it spreads. See why the default matters, how to check it, and how to switch it on.
Guide · SQL Server TipsMicrosoft SQL Server Management Studio (SSMS): Download & InstallDownload the latest SQL Server Management Studio (SSMS), online or offline installer, with a step-by-step Windows setup and system requirements.
Guide · SQL Server TipsKeep SQL Server Backups Safe: Best PracticesSQL Server backup best practices start with a restore plan. Check schedules, storage, backup verification and test restores before you need them.
Guide · SQL Server Migrations & Upgrades[Complete Guide] Amazon RDS Managed InstanceMove SQL Server to a managed database? Start with these Amazon RDS for SQL Server guides on migration, storage, licensing, security and availability.
Guide · SQL Server SecurityAzure SQL and Security Best PracticesIn Azure SQL Security - where do you begin? While Azure helps secure your assets, a great deal of responsibility is on the customer to do their part.
Client Result · SQL Server SecurityWhy SQL Server Backups Fail When You Need Them Most: A 3-Month Bank Outage Case StudyYour SQL Server Backups Are Probably Worthless: The Banking Horror Story That Proves Why (3 Months, No Money, Complete Chaos).
Guide · SQL Server Health CheckSQL Server Max Memory ParameterSet SQL Server max server memory with room left for Windows. Find the SSMS setting, check your workload and spot the signs of memory pressure.
Guide · SQL Server Migrations & UpgradesMicrosoft SQL Server Migration Strategies to AWSMigrate SQL Server to AWS. Compare EC2 with Amazon RDS on licensing, backups, compatibility and availability before choosing your migration path.
Guide · SQL Server Tips[3-Step Process] How to Check for Updates in SQL Server Management Studio (SSMS)Check your SSMS version and update to the latest release in a few clicks. Where to find the version number, and the offline installer option.
Client Result · SQL Server Performance TuningHow We Cut a Query's Disk Reads by 896 TimesA stored procedure behind peak-hour deadlocks had an Eager Index Spool in its plan. One index removed it and cut reads from 16.65 million to 18,589.
Guide · SQL Server Health CheckRemoving Offline Databases and Orphaned Data Files From Your SQL ServerIdentify and remove offline databases and orphaned data files in SQL Server to free up storage. Includes scripts and tips for safe removal.
Guide · SQL Server SecurityHow to Prevent SQL InjectionsWe provide important tips on prevention and detection of SQL injection vulnerabilities, as well as tools for scanning and testing your code.
Guide · SQL Server Health CheckSQL Server Agent Job History RetentionSQL Server keeps only 1,000 Agent job history rows by default, too low for production. Calculate the right limits and apply them via SSMS or T-SQL.
Client Result · SQL Server Performance TuningHow a Windows Power Plan Made SQL Server Storage 10 Times SlowerQueries slowed down with no code change. Latency was high under almost no load. The cause was the Balanced power plan. The fix made random I/O 10x faster.
Client Result · SQL Server Migrations & UpgradesHow Real Workload Testing Cut Azure SQL Hyperscale Costs by 46% and Saved $86,000 a YearUsing DEA and production replays, we benchmarked six Azure SQL configs, avoided a serverless misstep, and delivered 46% cost savings with better performance.
Guide · SQL Server Performance TuningPage Life Expectancy & Why Should You Care?Page Life Expectancy shows how long data stays in memory. What counts as a healthy PLE, why the old 300 rule is wrong, and what a low number really means.
Guide · SQL Server Health CheckThe Proper Way to Set Up SQL Server AlertsSet up SQL Server monitoring alerts for serious errors and I/O warnings. Create an operator, choose the events and notify the right person.