The Red9 Blog
Get our new tips before anyone else. Enter your email below to join our private list!
Most Popular Red9 Posts
Latest From Red9
How to use SQL Server FILESTREAM feature for large databases
Do’s and don’ts What is SQL Server FileStream feature? This feature allows adding unstructured documents into the database. You can store images, PDFs, videos, or
[2020] Amazon AWS Storage Selection Guide for SQL Server – When to use S3, EBS or EFS
Which AWS storage options work best for SQL Servers? If you are looking for AWS storage options for SQL Servers for your EC2 instance, your
How to eliminate SQL Server migrations performance degradation risks with Distributed Replay (DReplay)
Using THE least used SQL feature Distributed Replay (DReplay) There are a lot of things that can go wrong during SQL Server migration. One of
How to re-initialize SQL Server Merge Replication publication
Step-by-step – SQL Server merge replication re-initialization 1. Connect to publisher instance: CIXSQL01\TOUCHSTORE. 2. Click right on Replication folder and click on “Launch Replication Monitor”
[case study] SQL Performance Tuning and making TSQL run 7,675 (not a typo) times faster! How did we do it?
SQL Server Tuning Case Study This is the case when tuning sometimes can not be done perfectly. We are trying to change DB code, so
Why disk operations matter the MOST when tuning T-SQL calls for performance
“Disk” Explained “Disk” – has different names. I think that confuses anyone outside of DBA little world. Alternate names some DBAs call Disk (including myself)
SQL performance tuning report and making CPU faster by 340%. How did we do it?
SQL Server Performance Tuning Report This tuning requires a bit of a different explanation. In some cases, client server is pressure on different resources. The
[case study] SQL Performance Tuning Report and 1,600% speed gain. How did we do it?
Another TSQL tuning. Another significant gain. More details: Here is the Excel version. See more performance tuning examples here. We tune slow SQL Servers every
How to configure Antivirus running on SQL Server
There is a lot of AV products from different vendors like Avast, McAfee, Sophos, BitDefender, Kaspersky… First, I’d question having Antivirus on SQL Server if
12 SQL Server Monitoring Jobs
The best SQL monitoring practices (even if Santa brought you all third party software licenses you asked for) I don’t care how many third party
SQL Server AlwaysOn Cluster Patching Window OS: Step by Step Guide
How to apply Windows or SQL Server patches to failover MS SQL Server cluster with AlwaysOn – Step by Step High level SQL cluster patching:
[Case Study] We Tuned SQL Server Performance and now TSQL runs 932,058% or 9,320 times faster(not a typo)! How did we do it?
Total improvement: 932,058% Not bad, huh? These type of database speed improvements makes me smile! 🙂 Here is another SQL Server performance tuning report. Before