SQL Server

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

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…

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…

SQL Server Alwayson Interview Questions & Answers

I have published SQL Server Interview Questions and Answers on many topics. Visit attached link to get All SQL Server…

New T-SQL Functions Introduced in SQL Server 2017

SQL Server 2017 is feature rich product that has been launched with multiple new features. You can read attached article…

Overview on SQL Server Performance Tuning

SQL Server Performance Tuning is an important subject and it is essential to implement various measures at regular intervals of…