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]
In my previous article, I showed you how to generate a random datetime value for column. In this article, I will discuss you how to generate random Datetime for all rows in a query.
[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]
8. March 2024
Mehedi
C# , Technology
In recent month, I was engaged in a project with a leading telecom operator of Bangladesh. In mid of the project the requirements were changed and we were asked to do Diameter Protocol based charging.
[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]