Mohsin Khan

Mohsin is a database expert with a decade of professional experience as a database administrator and architect. He has a master’s degree in Information Quality. He has accomplished many demanding targets and led and executed many multi-million-dollar projects for some big Fortune 50 companies. He has actively pursued mentoring and coaching others through various writing activities, speaking engagements, blog posts, and discussion platforms dedicated to data professionals. He likes messing around with databases and enjoys sharing his knowledge and experiences.
  • Interests: SQL Server, Data Science, Machine Learning
  • Skills: SQL Server, Data Science, Machine Learning

Understanding CRUD Operations on Tables with B-tree Indexes, Page-splits, and Fragmentation

Introduction Every DML transaction reads the data before it makes any changes. Not only during a SELECT query, but when you run any DML statement, insert, update, or delete, SQL Server first fetches a bunch of pages into the buffer pool locating the desired rows and changes them while synchronously writing to the transaction log […]

5 (6)

2021-05-10

2,324 reads

Blogs

WIT Mental Health and Wellness Videos Posted

By

I was honored to speak at the WIT Mental Health and Wellness day last...

Daily Coping 13 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

#PowershellBasics: Comments and comment based help

By

I’ve talked about SQL Server comments before and how important they are. In PowerShell...

Read the latest Blogs

Forums

Azure SQL Database and SQL Managed Instance Security Best Practices

By MillionQueries

Hello, I have 7 different SQL Managed Instances which were newly migrated over from...

SSRS - exporting to csv issue

By Jeffs1977

I have an SSRS report and have a field called "Ticket". "Ticket" is a...

Failed Because Truncation Occurred

By AMCiti

Dear Group: I am getting the following error on my SSIS import process. "Workbook.Outputs[Excel...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers