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
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
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
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 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
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
Case Study … and a new tuning record! We do a lot of performance tuning of slow SQL Server code. In this example, I will
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:
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
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
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.
(and the end result we want out of DReplay testing) In Part1, I talked about: Why would you 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