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 – Tuning a slow report
Problem summary A report was taking a long time to complete. It was also causing deadlocks during the execution. What was done We started monitoring
Case study – Dealing with deadlocks
Problem Summary Two procedures were involved in 80% of deadlocks related to a third-party app. Deadlocks are a common problem handled by SQL Server automatically.
Best practices for SQL Server Installation
SQL Server installation does not often repeat, especially if you are using on-premises servers. In this article, you will see a few settings that are
Microsoft SQL Server Management Studio (SSMS)
What is SSMS? SQL Server Management Studio (SSMS) is an integrated environment for managing any MS SQL Server infrastructure, from on-promise to an Azure SQL
Database engine tuning advisor for MS SQL Server
What is a database tuning advisor? Changing database design to a proper one makes it to perform better. One of the performance-critical areas of databases
Choosing the right encryption feature for SQL Server
Encryption is the process of encoding information to protect data from unauthorized access in different scenarios. There are many different encryption technologies offered by SQL Server and
Performance Tuning Report – 600% gain on disk reads!
SQL Server Index Tuning Example Speed improved by 600% Some SQL Server Consulting clients chose to tune databases periodically. Once we tune, I noticed sometimes
Performance tuning report – Disk reads 35x faster!
Some customers care about SQL Performance Tuning so much that they use our database administrators for continuous Microsoft SQL Server performance tuning. This one of
Case study – Disk performance 10x slower than expected!
Several different methods can be used to track I/O performance to determine if there is an I/O bottleneck. Tools are available at both the storage level
Case study – 1,266% faster!
Real sample The procedure below was extracted from a stored procedure that was found during a database Assessment. It was causing CPU pressure on the client’s
Automate your SQL server tasks using dbatools (Powershell)
What is dbatools? Dbatools is an open-source module of PowerShell developed by big names from the SQL server community, MVPs, and other SQL server and
How to test SQL migrations using log shipping
What is the t key to SQL Upgrades project success? Preparation. Prep work is going to take 80-90% of the time. SQL Server install and