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
Microsoft SQL Server migration strategies to AWS
Let’s assume that you have a SQL Server workload on Premises and want to take those to the cloud. You have two options for MS
Migrating Microsoft SQL Server to Amazon AWS RDS
RDS is a managed database service that will do all the heavy lifting that you normally must-do. It automates everyday database administration tasks like: Backup
SQL Server Replication Performance Tuning
Performance Tuning SQL Server Replication – Step by step Guide More often than not SQL Server replication users don’t realize it has many customizations. A
SQL Server Index Tuning – 41,925% improvement
SQL Server MASSIVE Index Tuning Example Speed improved by 41,925% We often do massive SQL index tuning change. It usually happens, when server hasn’t had
Encrypt data stored inside SQL Server
6 ways to encrypt data inside SQL Server [in 2019] We recently got a question from someone about how to encrypt large SQL Server database
The New Record in our Performance Tuning – Report – 75,336% improvement!
Case Study … and a new tuning record! We do a lot of performance tuning of slow SQL Server code. In this example, I will
Before vs. After Performance Tuning Report – 1152x faster!
Disk Operation Tuning In this tuning, the only thing that was tuned was disk operations. And here is what was done to get this improvement:
SQL Server Performance Tuning Report – 877% improvement
Real example #3 Some SQL Server Consulting clients chose to tune databases periodically. This is one of those clients. Here is a recent example of
Performance Tuning Report – 67,871% gain
Real example Today I am sharing another MS SQL Performance tuning report from recent tuning. After making a couple of small tweaks to the SQL
Before vs. After Performance Tuning Report – Up 16x faster!
Real Example #1 Some customers care about SQL Performance Tuning so much, that they use our database administrators for continuous Microsoft SQL Server performance tuning.
Guide on how to compare performance of two SQL Servers – Part2
(and the end result we want out of DReplay testing) In Part1, I talked about: Why would you compare performance of two SQL Servers.
Guide on how to compare performance of two SQL Servers
(using the least known SQL Server feature – SQL Distributed Replay) How does NEW SQL Server compare to an OLD? Why? Why would you want