That day one of my junior colleague rushed to me and sought my assistance. He failed to drop an user. It showed - "The database principal owns a schema in the database, and cannot be dropped." I took him to our office kitchen, had tea, and explained the issue.
[More]
At early stage of my career, SQL Server Database was like a black box to me. I submitted data a
[More]
That day, I was purchasing some items from my neighbouring grocery shop. I noticed, the shop owner was maintaining his debtors list in his ledger book. I found his ledger book started with a table of his customer list along with page numbers. Pages had transactions of individual customer. In case of a page became full, it had reference of another pages with bunch of transactions. There are some blank pages and also blank spaces in some pages. Suddenly, I realized how SQL Server manage the INDEX functionality.
[More]
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]