MSSQL

  BREAK Statement: You may want to terminate while loop by using the BREAK statement. You can use it as follows. [crayon-6745cf367f0cc298368638/] Continue Statement: Usually …

If the condition in the IF block is provided, operations between the BEGIN and END blocks are performed. If the condition in the IF block …

  If the condition in the “IF” block is provided, we perform operations between the “BEGIN” and “END” blocks. You can use it as follows. …

  When we want to add data to a table, we get this error if the size of the column in the table is smaller …

If you are using a consolidated SQL Server environment, there is more than one database and login on an instance. When the logins connect to …

  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 …