Introduction to Row-Level Security in SQL Server
Why Row Level Security Matters? Prior to SQL Server 2016, table-level security was the default...
Dealing with NULLs in SQL Server
What is NULL? NULL or the NULL marker is the way we represent an unknown value in SQL, by SQL I am referring to the standard Structured...
Essentials and usage of NOLOCK hint in SQL Server
The main idea of the SQL Server locking mechanism is that it controls the consistency of transactions. According to this principle, if a...
Auto-Email System to Send Database Summary Report
Database monitoring is the most essential job of any database administrator. Big organizations 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...
SQL Server Database Replication
Database replication is the technology to distribute data from the primary server to secondary servers. Replication works on Master-slave...
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...
How to create Snapshot Replication
The concept of snapshot replication is simple. It generates and distributes the snapshot of schema...
