Research

Papers and notes from our own work.

Fixing deadlocks on hot SQL Server tables with an index redesign

A production incident, a deadlock graph, and the composite and covering indexes that made it stop.

Nidhi Shah · Sep 22, 2026

Secure Smart Lock System Utilizing the MQTT Protocol

IEEE conference paper on a smart-lock system built on MQTT, covering the protocol choice, the security design and the measured request-response cycle.

Nidhi Shah · Jul 1, 2022

Want to talk about any of this? Get in touch.

Research

All entries

Fixing deadlocks on hot SQL Server tables with an index redesign

Secure Smart Lock System Utilizing the MQTT Protocol