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
SQL Server
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 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
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
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
Understanding Different Types of SQL JOINs with Examples
SQL JOINs are used to retrieve set of information from two or more different tables based upon certain common values…
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