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] Azure Managed Instance Distributed Replay test
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 and 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
Two most important decisions in disaster recovery – RPO and RTO
If you ever asked yourself (or management) question – what is the acceptable level of data loss, and how long it may take in case
Ways of Performance Tuning on Azure SQL Database
Since Azure SQL Database is database-scoped, there are some significant differences when it comes to performance tuning. Microsoft provides some ways to leverage and find
How to configure transactional replication between Azure SQL Managed Instance and an on-premise SQL Server
What is Azure SQL Managed instance? SQL Managed Instance is a cloud database service that preserves all PaaS capabilities (automatic patching and version updates, automated backups, high
Best practices after SQL Server installation
SQL Server installation does not repeat often, especially if you are using on premises servers. You just set it up, change configuration to optimal, and
The definitive guide for Microsoft SQL Server licensing
The Microsoft SQL Server Licensing Guide is really not long and contains just over fifty pages. However, the challenge here is that it refers to
Best Practices for Performance Counters in Microsoft SQL Server
Why is this needed? When users notice that web pages or other systems are running slow, they start complaining to System or database administrators. How
Different ways to sync SQL Server data from Azure to on-premise SQL Server
As Cloud computing is getting more popular, many companies choose to deploy a hybrid environment using a mix of on-premises data centers and public clouds.
SQL Server performance tuning using Indexes
Few technologies in SQL Server cause as much confusion to a developer than indexes. Indexes operate “behind the scenes”: adding and removing indexes rarely result