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
SQL Server Administration
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
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 1105: Could not allocate space for object in database because the filegroup is full.
Today, I got error 1105 on one of the database server. We were processing some bulk transactions on a database…
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