SQL Server CRUD Operations
In database programming, there are four fundamental operations: create, read, update, and delete...
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...
Introduction to SQL Server Identity
In this article, we will explore the basics and details of the SQL Server IDENTITY property and the IDENTITY column features. Also, we will...
Basics of Running T-SQL Statements from Command Line using SQLCMD
This article is about developing a basic understanding of sqlcmd utility to run T-SQL commands...
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...
Query Store: Showing the Impact of Indexes on Inserts
Introduction It is common knowledge in database circles that indexes improve query performance either by satisfying the required result set...
How to Write T-SQL Queries Like a Pro
The skills of writing different types of SQL Server queries require you to have good knowledge in...
Auto-Email System to Send Database Summary Report
Database monitoring is the most essential job of any database administrator. Big organizations and companies have multiple database servers...
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...
