Move System Databases in the SQL Server Failover Cluster
Recently, I was assigned to a project – our customer purchased a new SAN, and they wanted us...
SQL Server High availability: Add new disk to an existing failover cluster instance
In my previous article, I have explained the step-by-step process of installing a node in existing SQL Server Failover Cluster Instance....
Installing SQL Server Failover Cluster Instance – Part 1
In this article, I am going to explain the process of installing SQL Server on failover cluster instance (FCI) on the primary node. First,...
Everything you Need to Know about Database Normalization
The Relational Model of data management was first developed by Dr. Edgar F. Codd in 1969. Modern...
Update SQL Server statistics using a database maintenance plan
Database backups, integrity checks, and performance optimizations are core regular tasks of DBAs. The client data is very important for a...
Tutorial on SQL (DDL, DML) on the example of MS SQL Server dialect
Introduction This tutorial includes information about SQL (DDL, DML) that I have gathered during my professional life. This is the minimum...
Column-level and row-level tracking in merge replication
In this article, let us review row-level and column-level tracking options in merge replication and...
Creating and Deploying Multiple Versions of Database through Schema Snapshots
Overview This article talks about using database schema snapshots to maintain different versions of a database to be deployed to different...
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...
How to create Snapshot Replication
The concept of snapshot replication is simple. It generates and distributes the snapshot of schema...