Multiple Ways to Delete Duplicates from SQL Tables
Overview This article discusses two different approaches available to remove duplicate rows from...
Using DATEADD, DATEDIFF and DATEPART T-SQL Functions in Simple Terms
This article focuses on developing a basic understanding of how to use one of the most common Transact-SQL date functions: DATEADD,...
MERGE: Updating Source and Target Tables Located on Separate Servers
What is the MERGE statement? Using the MERGE statement, we can change data in a target table based on data in a source table. Using it, we...
Overview of Data Compression in SQL Server
The database is a critical and vital part of any business or organization. The growing trends...
Navigating SQL Server Error Logs
Introduction One of the key skills you need as a database administrator or an IT person is generally the ability to monitor systems very...
Monitoring Backups Across Instances
Introduction In the last two or three months, I have been asked twice for a solution native to SQL Server that consolidates a backup report...
Tracking Database Changes Using Working Folder Source Control
This article talks about a new method to version control a database using a working folder so that...
How to create Snapshot Replication
The concept of snapshot replication is simple. It generates and distributes the snapshot of schema and data of articles, appeared at a...
How to create Transactional Replication
In this article, I am going to demonstrate how to create transactional replication. Transactional replication generated a snapshot of...
Importance of transaction log in SQL Server
Transaction logs are a vital and important component of database architecture. In this article,...
