MSSQL

  If there is a variable in the script we run and we have not declared this variable, we will get this error. For example, …

  Sometimes, we can receive the below error. SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the …

  DPM (Data Protection Manager) is Microsoft’s software for backup. Before reading this article, I recommend you to read other articles related to DPM on …

  With UNION and UNION ALL Opertors, we can merge multiple sql statement’s result in a single result set. When we merge two SQL statements …

  Sometimes the application owners can come to you because the application cannot connect to the database. In this case, a DBA must first test …

It is a very critical step to correctly determine SQL Server Data Types when designing tables to prevent unnecessary growth of the database. The space …

  In this article I will describe how to declare variables in TSQL. We can declare variables in a few different ways. • Declare a …

We perform maintenance operations on SQL Server using Maintenance Plan. This article describes how to delete files with a specified extension in a folder. I …

We can perform the following operations with ALTER TABLE Statement. Add a column to a table Delete a column from a table Change the data …

  Last night, a customer started to receive error messages about one of the Replica in an AlwaysOn Availability Group configuration. Error messages were related …