Database Optimization & Structure

Move System Databases in the SQL Server Failover Cluster

Database administration, Database Optimization & Structure

Recently, I was assigned to a project – our customer purchased a new SAN, and they wanted us...
Read More

SQL Server High availability: Add new disk to an existing failover cluster instance

Database administration, Database Optimization & Structure

In my previous article, I have explained the step-by-step process of installing a node in existing SQL Server Failover Cluster Instance....
Read More

Installing SQL Server Failover Cluster Instance – Part 1

Database administration, Database Optimization & Structure • One Comment

In this article, I am going to explain the process of installing SQL Server on failover cluster instance (FCI) on the primary node. First,...
Read More

Everything you Need to Know about Database Normalization

Database administration, Database Optimization & Structure

The Relational Model of data management was first developed by Dr. Edgar F. Codd in 1969. Modern...
Read More

Update SQL Server statistics using a database maintenance plan

Database administration, Database Optimization & Structure

Database backups, integrity checks, and performance optimizations are core regular tasks of DBAs. The client data is very important for a...
Read More

Tutorial on SQL (DDL, DML) on the example of MS SQL Server dialect

Database administration, Database Optimization & Structure

Introduction This tutorial includes information about SQL (DDL, DML) that I have gathered during my professional life. This is the minimum...
Read More

Column-level and row-level tracking in merge replication

Database administration, Database Optimization & Structure

In this article, let us review row-level and column-level tracking options in merge replication and...
Read More

Creating and Deploying Multiple Versions of Database through Schema Snapshots

Database administration, Database Optimization & Structure

Overview This article talks about using database schema snapshots to maintain different versions of a database to be deployed to different...
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

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
Close