Blog

Understanding Peer-to-Peer Transaction Replication in SQL Server

Peer-to-Peer Transaction replication is a kind of bidirectional replication. It operates in a way that transaction repli...
Blog

Understanding Snapshot Replication in SQL Server

In this article, I explain how Snapshot Replication works. It is easy to understand how snapshot replication works. It p...
Blog

Understanding Merge Replication in SQL Server

In this article, I will explain how merge replication works.PrerequisitesIn merge replication, the following two jobs ar...
Blog

Understanding Transaction Replication in SQL Server

Replication can be a challenging feature to understand at first. In this article, I will explain how transaction replica...
Tutorials

05. Uninstall SQL Server

This article explains how to uninstall SQL Server.Uninstall SQL Server1. Right click on"Microsoft SQL Server 20xx (64-bi...
Tutorials

04. Connection string for SQL Server

This article explains about connectint string for SQL Server instance.What is a connection stringWe have to specify a co...
Blog

How to establish a connection to SQL Server?

In SQL Server, data communication is conducted in the diagram below.                                                    ...
Tutorials

03. Connect to SQL Server instance

This article explains how to connect to SQL Server instance.Connection ToolsSQL Server Management Studio(SSMS) or sqlcmd...
Tutorials

02. Apply update

This article explains how to apply update to SQL Server.What is updateAn update include bug fixes, security updates, and...
Tutorials

01. Install SQL Server

This article explains how to install SQL Server.SQL Server editionsSQL Server has several editions. In this blog, we wil...