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…

IT Presales Interview Questions & Answers – Part 2

I have already published Presales Interview Questions & Answers Part 1 in attached link . I would recommend you to visit…

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…

How to Install Zabbix on Ubuntu Server 16.04?

Zabbix is a great open source tool for monitoring servers mainly under the GNU/LINUX environment, specialized in networks with an…

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…

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…