In the table below, you’ll find the technical articles I’ve written for some of the tech journals in the industry. I’m excited to share these with you and will update this list with new articles as they get published. The articles are arranged with the latest ones first. Happy reading!

Article Journal Award
Understanding CRUD Operations on Tables with B-tree Indexes, Page-splits, and Fragmentation SQLServerCentral N/A
Understanding CRUD Operations Against Heaps and Forwarding Pointers SQLServerCentral N/A
Understanding the Internals of a Data Page SQLServerCentral N/A
SQL Server: Understanding and Fixing Boot Page Corruption TechNet Wiki  Gold
SQL Server: Understanding and Dealing with Page Restores TechNet Wiki  Silver
SQL Server: Understanding, Implementing and Managing Policy-Based Management TechNet Wiki Gold
SQL Server In-Memory OLTP: Transaction Isolation Levels TechNet Wiki  Gold (Featured in TechNet Wiki Article Spotlight)
SQL Server: How To Perform Piecemeal Restore and Partial Backup of a Database TechNet Wiki Gold
SQL Server In-Memory OLTP: Understanding and Dealing with Range Indexes on Memory-Optimized Tables TechNet Wiki Gold
SQL Server In-Memory OLTP: A Closer Look at Hash Indexes on Memory-Optimized Tables, Bucket Count and SARGAbility TechNet Wiki Gold
SQL Server: All about detach and attach operations and common scenarios where they may or may not work  TechNet Wiki Gold (Featured in TechNet Wiki Article Spotlight)
SQL Server: Concurrency Control Models, ACID Properties and Transaction Isolation Levels TechNet Wiki Gold
SQL Server Transaction Log Internal Architecture- Facts Every SQL Server Database Professional Should Know TechNet Wiki Gold
Options For Monitoring Transactional Replication in SQL Server TechNet Wiki Bronze
SQL Server: Understanding Minimal Logging Under Bulk-Logged Recovery Model vs. Logging in Truncate Operation TechNet Wiki Gold