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
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 on Performance Counters for 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
How to troubleshoot a slow running query using wait stats in the MS SQL server?
SQL Server Performance tuning is a vast topic that can be a complicated and struggling task. Fix a slow query and solve performance problems can
MS SQL Server Migration: AWS RDS vs. Azure SQL Database
Amazon AWS and Microsoft Azure are excellent options for deploying MS SQL Server databases. Many companies use both to enjoy each Cloud’s unique feature set.
7 TSQL Development Tips for Faster Queries
Today I will let know some essential techniques that never change to make your queries run faster in the Microsoft SQL server! It is excellent
Top 10 SQL Server Performance Tuning Mistakes
It’s not enough that your code is readable: it must perform well too. In this post, I will show a list of common antipatterns in