MSSQL

We use the operators to identify the contact list to send mail to. Right click on Operator under SQL Server Agents and call New Operator. …

  Under Management on SSMS, right click on Database Mail and select Configure Database Mail. Click “Skip this page in the future” and next. On …

There are a few important things to check for SQL Server Always On Availability Group. Did the failover occur on any AG? Does the transfer …

  In SQL Server, tsql code developers may occasionally want to temporarily keep records on a table. This can be done by creating a table …

  Check Constraint limits the values ​​that can be entered into a column. Check Constraint works on Row basis. Allow Null Values ​​to be inserted. …

As a Database Administrator, we need to follow Failed Logons. And we need to warn users for unauthorized access attempts. Or if there is a …

Trigger is used to trigger another event when an event occurs in the database server. There are 3 types of trigger. 1) DML(Data Manipulation Language) …

WHAT IS CURSOR? In SQL Server, the Cursor walks through the recordset, which is returned as a select result, to perform a transaction on each …

  I wrote some articles about Temp Table and Table Variable. In general, people who are new to tsql code development are wondering which one …

  Table Variable is a special data type. In the query we can create and insert a result set into the table variables and use …