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,012 reads

Blogs

A New Word: Proluctance

By

proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward...

10 reasons why IT certifications are still important

By

As someone who has spent over 20 years in the Software/Data Engineering area and...

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Read the latest Blogs

Forums

Troubleshooting sql issue where multiple sessions are involved

By vsamantha35

Hi All, We have an application that spawns multiple spid's, runs multiple multiple batches...

Best Practice for full backup and transaction log truncation

By anbu678@gmail.com

I am new to SQL Server DB. Could someone please let me know what...

when peers maintain a job rdp'd in they corrupt the job

By stan

Hi, one of my peers prefers to maintain one specific sql agent job after...

Visit the forum

Question of the Day

Filestream on Linux

I want to implement a Filestream table on SQL Server 2022 running on Linux. Can I do this?

See possible answers