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
[Case Study] We Tuned SQL Server Performance and now TSQL runs 7,039% faster(not a typo)! How did we do it?
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
How to migrate SQL Server to Azure SQL database
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 resilient
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
[Case Study] We did SQL Server Performance Tuning by tuning indexes and now its 41,925% faster(not a typo)! How did we do it?
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
SQL Server Data Encryption and your options for encryption
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
[New Record] We did SQL Server Performance Tuning and now its 75,336% faster(not a typo)! How did we do it?
Case Study … and a new tuning record! We do a lot of performance tuning of slow SQL Server code. In this example, I will
[Case Study] Tuning SQL Performance to run 1,152 (not a typo) times faster! How did we do it?
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:
[Case Study] We did SQL Server Performance Tuning and now its 877% faster(not a typo)! How did we do it?
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
[Case Study] Performance Tuning increase by 67,871%. How did we do it?
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
[Case Study] Tuning SQL Performance and making TSQL run by 16 times faster! How did we do it?
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.