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

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

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