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
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
SQL Server Merge Steps 1. Connect to publisher instance: CIXSQL01\TOUCHSTORE. 2. Click right on Replication folder and click on “Launch Replication Monitor” option. 3. Click
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)
Server Tuning Report This tuning requires a bit of a different explanation. In some cases, client server is pressure on different resources. The three resources/parameters
Another tuning. Another significant gain. More details: Here is the Excel version.
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
How to apply Windows or SQL Server patches to failover MS SQL Server cluster with AlwaysOn – Step by step SQL cluster patching best practices
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
Speed improved by: 4,780% + 565% + 1,763% or 7,108% total improvement. Not bad for the results that we got before I ate my cereal
Azure SQL Database is a fully managed service. With this platform as a service (PaSS) option, organizations can reduce management overhead and quickly deliver highly