Tutorials 06. Create database and table
This article explains about creating databases and tables in SQL Server.There are multiple objects within a SQL Server i...
Tutorials Blog How does “sync with backup” work in transaction replication?
Transaction replication has an option called "sync with backup". This option can be configured for both the publication ...
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...