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 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