Multiple Ways to Delete Duplicates from SQL Tables
Overview This article discusses two different approaches available to remove duplicate rows from...
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 predict that 82% of enterprises expect...
Navigating SQL Server Error Logs
Introduction One of the key skills you need as a database administrator or an IT person is...
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 historical changes made to the database...
How to create Snapshot Replication
The concept of snapshot replication is simple. It generates and distributes the snapshot of schema...
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, we’ll discuss SQL Server transaction...
Creating Database Maintenance Plans
Using database maintenance plans, we can automate basic database administration activities....