How to Change Authentication Mode in SQL Server?
Authentication is a process to establish a successful connection. SQL Server provides two types of authentication modes to connect to…
4 years ago
SQL Server
Fix SQL Server Error 802: There is insufficient memory available in the buffer pool.
We receive SQL Server error 802 when buffer pool of SQL Server instance is full and cannot grow further. Here,…
4 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
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
Fix Error 15123: The configuration option does not exist.
Yesterday, one of my teammate was facing an issue while enabling a server level parameter using T-SQL command sp_configure. He was trying…
7 years ago
How to Find When SQL Server was Installed?
Have you ever thought when SQL Server instance was installed on your machine? If you don't have idea about finding…
7 years ago
Fix Error 18452: Login failed. The login is from an untrusted domain
Recently a user has reported error 18452 while connecting to database server. Full description of this error is given below:…
7 years ago
How to Enable, Disable or Check SQL Server Trace Flags?
Trace flags are used to gather in-depth information about certain logs during some transactions. We use DBCC commands to enable…
7 years ago
Fix Error 1418: The server network address cannot be reached or does not exist.
We got error 1418 while configuring Database Mirroring on one of the SQL Server database instance. The error details are…
7 years ago
Understanding Database Shrink Operation and Why Should We Avoid It?
Database Shrink is a process to remove unused space allocated to the database or database files to the disk. When…
7 years ago
SQL Server Evaluation Period has Expired and How to Upgrade it?
Generally, we download SQL Server evaluation edition to learn or do some testing before deployments. Evaluation edition of SQL Server…
7 years ago
Fix SQL Server Error 233: No process is on the other end of the pipe
Today, I got SQL Server error 233 no process is on the other end of the pipe while connecting to…
7 years ago