How to Install PostgreSQL 10.1 in Debian 9 Stretch

I will show you how to install PostgreSQL latest version on debian operating system in this article. PostgreSQL is one…

Fix SQL Server Msg 5144 and 5145 for long or failed autogrow of data and log files

Whenever you extend the size of your data or log file with a larger value or your database perform autogrow…

How to Add a New Database to Always On Availability Group?

Adding or Removing databases from availability group is not day to day task but we need to perform such activities…

How to Remove Database from Always On Availability Group?

This article describes how to remove availability database(s) from an Always on Availability Group by using SQL Server Management Studio…

Fix SQL Server Error 53: Could not open a connection on SQL Server

Today, I will explain how to fix SQL Server error 53 (The network path was not found). The details about…

How to Reduce PREEMPTIVE_OS_WRITEFILEGATHER Wait Type in SQL Server?

I was getting wait type PREEMPTIVE_OS_WRITEFILEGATHER during database size allocation. Yesterday, I was configuring database size to the value that…

Manage Transaction Log File during Data Load

Have you even face that your transaction log file is growing exceptionally and you have to manage log file to…

vRealize Automation Interview Questions and Answers – Part 2

Find the second part of vra interview questions and answers in this article. You can read first part of vra…

Fix SQL Server Installation Error: Attributes do not match

Last week I was working on SQL Server installation where i got this error Attributes do not match. Error details…

SQL Server Error 40: A network-related or instance-specific error occurred while establishing a connection to SQL Server.

Today, a user has raised a request to fix an error (Microsoft SQL Server Error 40 - Could not open a connection…