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
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
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
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
“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 Server Performance Tuning Report This tuning requires a bit of a different explanation. In some cases, client server is pressure on different resources. The
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
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
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
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