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

3,357 reads

Blogs

Architect a disaster recovery for SQL Server on AWS: Part 1

By

  New blog post - Architect a disaster recovery for SQL Server on AWS: Part...

Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.

By

New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS...

Daily Coping 3 Aug 2021

By

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

Read the latest Blogs

Forums

FOR JSON command adding carriage return to output

By fxferguson

I'm pretty new a creating JSON output form SQL server. I'm having trouble with...

Create a delta from downloaded info

By Bruin

I'm looking for some suggestions on how to create a delta file that will...

Last Time Stored Procedure Ran ?

By homebrew01

Hi, I've found several examples using dm_exec_procedure_stats but the results are only useful  as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers