SQL Server

High-Availability and Disaster Recovery in SQL Server: Transactional Replication Vs Log Shipping

Transactional Replication Transactional replication is a more flexible data replication technology that operates at the individual transaction level. It involves publishing and replicating specific transactions

Manage Change History Using System-Versioned Temporal Table

Here we have an application that shares district and date wise updated current temperature, when temperature of any district with current date changes, we update

Advanced Search Using SQL Server Full-Text Search: Part-2

In part one, it is shown how to enable basic Full-Text search options on a table in SQL Server. But often our required data is

Advanced Search Using SQL Server Full-Text Search: Part-1

Full-text search refers to the advanced functionality in SQL Server that supports full-text queries against character-based data. These types of queries can include words and

SQL Server Database Source Control using Visual Studio: Git

In this brief article, we will see how to setup SQL Server Database Source Control using Visual Studio step by step — 1. Create a new