SQL Server Administration

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…

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…

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…

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.…

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…

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…

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…

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…

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…

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:…

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…

Fix Error 1101: Could not allocate a new page for database

We get error 1101 because of space issues. Database engine doesn’t able to allocate new pages to the database because…

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…

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…

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…