Tag: sql server

Multiple Ways to Delete Duplicates from SQL Tables

Database development, Tables

Overview This article discusses two different approaches available to remove duplicate rows from...
Read More

MERGE: Updating Source and Target Tables Located on Separate Servers

Database development, Statements, Tables

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...
Read More

Overview of Data Compression in SQL Server

Database administration, Work with data

The database is a critical and vital part of any business or organization.  The growing trends predict that 82% of enterprises expect...
Read More

Navigating SQL Server Error Logs

Database administration, Troubleshooting Issues

Introduction One of the key skills you need as a database administrator or an IT person is...
Read More

Monitoring Backups Across Instances

Database administration, Database Optimization & Structure

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...
Read More

Tracking Database Changes Using Working Folder Source Control

Database development, 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...
Read More

How to create Snapshot Replication

Database administration, Database Optimization & Structure

The concept of snapshot replication is simple. It generates and distributes the snapshot of schema...
Read More

How to create Transactional Replication

Database administration, Database Optimization & Structure

In this article, I am going to demonstrate how to create transactional replication. Transactional replication generated a snapshot of...
Read More

Importance of transaction log in SQL Server

Database administration, Transaction Log

Transaction logs are a vital and important component of database architecture. In this article, we’ll discuss SQL Server transaction...
Read More

Creating Database Maintenance Plans

Database administration, Database Optimization & Structure

Using database maintenance plans, we can automate basic database administration activities....
Read More
Close