Shel Burkow

Shel is a consultant based in the San Francisco bay area. He started with object-oriented programming and has developed GUI, middleware and backend. Over time his appreciation for the elegance of the relational model has led him to specialize as a data engineer. He enjoys working with stakeholders to fine tune requirements, modeling and writing the SQL.

05 September 2016
05 September 2016

In-Memory OLTP: Row Visibility in SQL Server’s MVCC

SQL Server's In-memory OLTP is fast, due to its multi-valued concurrency control (MVCC). MVCC avoids the need for locks by arranging for each user connected to the database to see a snapshot of the rows of the tables at a point in time, No changes made by the user will be seen by other users of the database until the changes have been completed and committed. It is conceptually simple but does the user always see the correct version of a row under all circumstances? Shel Burkow explains.… Read more