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

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2021-05-10

6,560 reads

Blogs

Updating dbatools–Fixing the Certificate Failure

By

I was trying to update my dbatools install to test something and go this...

Classifications and sensitivity labels in Microsoft Purview

By

I see a lot of confusion on how classifications and sensitivity labels work in...

PASS Data Community Summit: A Personal Journey

By

As someone attending the event since 2011, I would like to share my personal...

Read the latest Blogs

Forums

How to get a distinct value from my data set

By skaggs.andrew

Hi, I need help with writing a script that will allow me to pull...

How To Approach Adding A primary Key To An Existing Table

By YSLGuru

In our vendor created/managed DB we have a table that is like an audit...

Dont want to restart Tempdb not able to shrink datafiles in ag primary

By naga.rohitkumar

HI All, Dont want to restart Tempdb not able to shrink datafiles in always...

Visit the forum

Question of the Day

SQL Server on Linux Restrictions

Which of these features are not available on SQL Server on Linux? (choose 2)

See possible answers