How to Change Failover Mode of Availability Replica in Always On Availability Group?

Today, i will describe about the overview of failover modes in AOAG and how to Change failover mode of an…

How to Enable Lock Pages in Memory for SQL Server?

Lock Pages in Memory is a Windows policy that assures the SQL Server or any other application to keep data in…

How to Install SSMA for Oracle to Migrate Oracle Database to SQL Server

Today, I am going to discuss about Oracle to SQL Server Database Migration. This article will give you step by…

How to Change Database Default Locations in SQL Server?

Sometimes, we need to change default database File locations to some other path in SQL Server. If you have configured…

Top Perfmon Counters to Identify SQL Server CPU Bottleneck

We should always monitor system resource utilization of our database servers and make sure that these utilizations should not exceed…

Top 10 Performance Counters to Identify SQL Server Memory Pressure

Memory is one of the important system resource that SQL Server uses to process their transactions. Sometimes, your server might…

SQL Server Error 701: There is Insufficient System Memory to Run this Query

Today I am going to discuss SQL Server memory issues that your database Instance might face during bulk data load…

How to Use CAT Command on Linux System?

This time we continue with the explanation of simple Linux command to learn basics. The command chosen today is the…

How to Change SQL Server Instance Name?

Changing SQL Server Instance name is not a routine task. Although, sometimes we get requirements to change SQL Instance name.…

How to Configure Reporting Services after Renaming SQL Server Instance

Sometimes we need to change the name of the server or computer on which SQL Server instance is running. Once…