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…
7 years ago
Manvendra Deo Singh
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…
7 years ago
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…
7 years ago
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…
7 years ago
4 Different Usages of DBCC SQLPERF in SQL Server
DBCC SQLPERF is very useful command that we use to get multiple statistics related information in SQL Server. This command…
7 years ago
How to Use Resumable Online Index Rebuild Operation in SQL Server?
Resumable Online Index Rebuild is a new feature introduced in SQL Server 2017. Index Rebuild operation is very expensive task…
7 years ago
Disk and Performance Impact of Online Index Rebuild Operation
Here, we are going to talk about disk and performance Impact of online Index rebuild operation. As we know index…
7 years ago
Should We Clear Wait Statistics Data from DMV sys.dm_os_wait_stats in SQL Server?
Should we clear or reset Performance Wait Statistics Data present in DMV sys.dm_os_wait_stats in SQL Server? The answer to this question is depends…
7 years ago
How to Change Putty Cursor Color or Mouse Pointer Color?
Sometimes, cursor or mouse pointer does not visible on your putty terminal console. The reason behind that is cursor color…
7 years ago
How to Change Putty Background Color?
If you want to change putty background color from black to white or any color as per your choice then…
7 years ago
How to Change Putty Text Color?
If you want to change PuTTY text color that are more visible to your eyes and make you understand what…
7 years ago
Fix SQL Server Error 18456: Login failed for user ‘User_Name’.
Yesterday, a developer has reported an SQL Server error 18456 Login failed for user ‘username’. (Microsoft SQL Server, Error: 18456)…
7 years ago
How to Reset or Change User Password on RedHat Linux
Password change is a routine task to keep your login secure. We use passwd tool on most of the Linux…
7 years ago
Fix: SQL Network Interfaces Error 28 – Server doesn’t support requested protocol
Today I am going to discuss about Microsoft SQL Server Error 28 that most of the SQL Server users might…
7 years ago
How to Change Hostname of RedHat Linux Server
Last week we had received some requests to rename or change hostname of RedHat Linux systems. We got these requests…
7 years ago