How to Add Data File to Availability Database?
Sometimes, we need to add data file to availability database in Always on Availability Group. Adding database file is a…
7 years ago
Manvendra Deo Singh
SQL Server Native Client Error 50000: A network error occurred while attempting to read from the file
Yesterday i have received SQL Server Native Client Error 5000 while installing SQL Server Management Studio on one of the…
7 years ago
What is Enhanced Database Failover and How to Enable it for Availability Group?
As we know Always on Availability Group is the set of user databases that are combined to failover if primary…
7 years ago
SQL Server Replication Interview Questions & Answers
Today i am going to write about SQL Server Replication Interview questions and answers. Read another set of interview questions…
7 years ago
Upgrade or Patch SQL Server Failover Cluster Instance Running with Availability Group
I have explained step by step process to upgrade or patch SQL Server instance that hosts an Always on Availability…
7 years ago
SQL Server Error 5009: One or more files listed in the statement could not be found or could not be initialized
I had to add a log file to a database and then extend the size of this log file to…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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.…
7 years ago
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…
7 years ago
Fix Error 15190: There are still remote logins for the server ‘DBSERVER’.
I got this error 15190 while renaming SQL Server Instance name. I was not able to drop the existing SQL…
7 years ago