Recently a user has reported error 18452 while connecting to database server. Full description of this error is given below: Error: 18452, Severity: 14, State: 1. Login failed. The login is from an untrusted domain and cannot be used with...
Trace flags are used to gather in-depth information about certain logs during some transactions. We use DBCC commands to enable trace flags, disable trace flags or check the status of trace flags. Here i am going to discuss about SQL...
Zabbix is a great open source tool for monitoring servers mainly under the GNU/LINUX environment, specialized in networks with an important user base and an active community that is always contributing both in its development and in its support for...
We got error 1418 while configuring Database Mirroring on one of the SQL Server database instance. The error details are given below: The server network address “TCP://ServerName.abc.local:5022″ cannot be reached or does not exist. Check the network address name and...
We get error 1101 because of space issues. Database engine doesn’t able to allocate new pages to the database because of insufficient disk space. The error details are given below: Error: 1101, Severity: 17, State: 2 Could not allocate a...
These days Presales has been providing very fascinating and promising career prospects in IT/ITeS. Maximum beginners are not aware of this career option. Here i am going to write most asked Presales interview questions and answers. Answers of few questions might...
Normally, the work of system administrators consists of an almost permanent use of the terminal; this is because servers with GNU/LINUX-based systems, for security reasons, do not have a graphical desktop environment. And this means that we have to use...
Database Shrink is a process to remove unused space allocated to the database or database files to the disk. When we shrink database log file or data files, it recovers space by moving pages of data from the end of...
My previous articles were based on how can we improve self-confidence and differentiate between confidence and arrogance. Learning from those topics are very important and can be implemented during interview sessions as we have to be confident rather than being...
Generally, we download SQL Server evaluation edition to learn or do some testing before deployments. Evaluation edition of SQL Server is free for 180 days and it is equivalent to SQL Server Enterprise Version. If the validity of Evaluation period...
In IT’s World, it is common to hear about system users, especially if you work in the administration of systems under that environment. GNU/LINUX is a multiuser and reliable operating system in terms of security, but it is always good...
When we talk about GNU/LINUX distributions we find a big collection of them, which can cover practically all the needs in almost all areas. Some of them range from simple home use to commercial production. The GNU/LINUX distribution that we...
Last article, i wrote about 4 Areas you can focus to boost your Self Confidence. Here i will explain the difference between confidence and arrogance and how to deal with arrogant people at your workplace. I have also explained about...
Generally, we run lot of commands to get informations for Linux processes. We can use a tool name Htop to avoid running multiple commands and get lot of valuable information in one screen. Htop is an interactive process viewer tool...
Today, I got SQL Server error 233 no process is on the other end of the pipe while connecting to one of the SQL Server instance using SSMS client. SQL Error 233 was saying No process is on the other...
