Today, I am going to explain you Clustered Columnstore Index and some related concepts. As a Database enthusiastic, you should know it.
[More]
Last week, I was discussing with one of my junior colleagues. He needed to add thousands phone numbers from a web form to database. He was looking for an efficient way.
[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]
I shared my 17 years experience with the audience what they should know about MSSQL Server.
[More]
Now I am a
Microsoft Certified: Azure Database Administrator Associate
check out my badge.
[More]
Did you check my MSSQL Server course on ghoorilearning.com?
https://ghoorilearning.com/course
[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]