Mehedi's Earth

Today, I am going to explain you Clustered Columnstore Index and some related concepts. As a Database enthusiastic, you should know it. [More]

Today I am going to show you how to import data from a CSV file using Transact-SQL BULK INSERT and the OPENROWSET(BULK...) statement. [More]

Let's examine the error handling step-by-step. [More]

This article explain how to store crucial data in SQL server securely. [More]

A temporal table is an user designed system-versioned table which keeps the full history of data changes of a table. [More]

Explaining the PIVOT table. [More]

Generating random value for DATETIME field within a range [More]

Filling up missing dates in query output using CTE [More]

Recently, I was in need to generate a report to find out how many customer calls daily within 10 AM [More]

Now SQL Server extends built-in support to the popular data exchanging format JSON. It exposes couple of functions for verifying, retrieving and updating JSON string. Let's carefully check them. [More]