Mastering NULL value in SQL Server
This article explain key concepts and best practices related to NULL value in SQL which help in mastering the NULL value in SQL Server.
SQL Advance Concepts
Securing data in SQL Server
This article explained about measures for securing data in SQL Server at various levels to protect data from unauthorized access and breaches.
Share this:
Understanding CDC in SQL Server
In SQL Server, Change Data Capture (CDC) is a powerful feature that tracks changes (inserts, updates, and deletes) made to tables, providing detailed information about the modifications. Introduced in SQL Server 2008, CDC is particularly useful in data warehousing, auditing, replication, and ETL (Extract, Transform, Load) scenarios, where it is crucial to maintain a historical … Read more
Share this:
SQL Triggers – An Introduction
SQL Triggers – An Introduction Contents Introduction Magic Tables Difference between Stored Procedure and Trigger DML Triggers After Triggers Syntax of the After trigger Example of After Trigger for Insert Example of After Trigger for Delete Example of After Trigger for Update Instead of Triggers DDL Triggers DDL Trigger for Create Table DDL Trigger for … Read more
Share this:
Replication in SQL Server
Replication in SQL Server Introduction Replication in SQL Server is a way of distribution of database and their objects from one master database to one or more recipient databases which can be on the same server or on the remote server. It is a set of technologies for copying and distributing data and database objects from one … Read more
Share this:
Log Shipping in SQL Server
Log Shipping in SQL Server Log Shipping Log Shipping in SQL Server is a process of keeping the latest copy of the database of the primary database server on the secondary database server with the help of transaction logs backup. It is done on a regular basis to minimize the loss of the database in … Read more
Share this:
Rebuild And Reorganization of Indexes
Rebuild and Reorganization of Indexes SQL Server has the ability of maintaining the indexes whenever we makes changes (update, Insert, Delete) in the tables. Over a period of time, the may causes the fragmentation on the table in which the logical ordering based on the key value pairs does not match with the physical ordering inside the data … Read more
Share this:
Fragmentation in SQL Server
Fragmentation:- Fragmentation can be defined as condition where data is stored in a non continuous manner. This article help in understanding the fragmentation in SQL Server. It can be defined into two types1. Internal Fragmentation 2. External Fragmentation Internal Fragmentation:- In this fragmentation, there exists a space between the different records within a page. This … Read more
Share this:
Isolation levels in SQL Server
Isolation levels :- Isolation level is required to isolate a resource and protect it from other transactions. This is achieved with the help of locks but what locks are needed and how they can be established is decided on the isolation level set on the database level. If low level of Isolation is set, it … Read more
Share this:
Merge Command In Sql Server
Merge Command:- Merge command is a new feature introduced in the SQL Server 2008. It can perform Update, Insert and delete operations at a single statement which means all the data is processed and read only once instead of three times(In case of Insertion, deletion and update statements.) It has a target table and Source … Read more
