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
Microsoft SQL Server builds
SQL Server is Microsoft’s main data platform. It is one of the best operational database management system (ODBMS). This article lists all the official builds
How to encrypt drives on live SQL Server with AlwaysOn
To encrypt drives for AlwaysOn, I would suggest these steps: – Do encryption during low usage hours. – encrypt drives on SECONDARY first. Without taking
Case study – Detecting and Resolving SQL Deadlocks
Problem Summary Deadlocks are a common problem handled by SQL Server automatically. Nevertheless, you have to make sure that you minimize deadlocks as much as
SQL Performance Tuning – 915x faster!
Real sample The query plan below was extracted from a stored procedure that was found during database Assessments. It was causing a high number of
SQL Performance Tuning Report – 24,000x faster!
Real sample Here what can be done during a session of SQL performance tuning. This query was running for a long time, causing a blocking
Case study – Slow storage affecting SQL Server performance
Problem Summary: Queries take a longer time than usual in processing. Suddenly, the queries that were fast before became slower. There are many reasons why
Case study – High CPU Usage (Emergency call)
Problem Summary: The client was experiencing severe SQL Server performance issues; Multiple queries were taking 1, 5, 10 minutes or longer or timing out; The
Case study – High Availability and Disaster Recovery
Problem Summary: Finding the right high availability option can be difficult. Which choice is right for you can depend on the following: Budget – first and
Case Study – A distributed replay test on Azure managed instance
Problem Summary: One of the biggest challenges in creating an Azure Managed Instance is determining the resource limits. In this case study, we use the
How to configure Ola Hallengren SQL Server maintenance solution
If you are a DBA, you understand the importance of having a robust Database Maintenance Solution. Ola Hallengren has developed an excellent maintenance implementation using
Azure SQL – Security best practices
Microsoft is grouping all the options for SQL running in the Azure platform into one portfolio. A family of managed products, making it easier to
The risks of SQL Server differential Backups
Backing up your SQL Server database is essential for protecting your data. When databases come bigger, you’re going to run out of time to do a full