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
If you ever asked yourself (or management) question – what is the acceptable level of data loss, and how long it may take in case
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
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 Microsoft SQL Server Licensing Guide is really not long and contains just over fifty pages. However, the challenge here is that it refers to
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
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.
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
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
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.
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
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