Shel Burkow has experience with user interface, middleware and backend design and development. He started with C, then progressed into object-oriented programming with C++ and C#. Along the way, his interests and practice expanded to include relational databases, especially SQL Server. More recently he has worked with NoSQL, particularly Cassandra.
His other passions include functional programming and Scala with API development and even a little Spark.
You can reach him at email@example.com.
Complex integrity constraints are more challenging to enforce in Cassandra than they are in a relational database. In this article, Shel Burkow walks through four modelling examples in Cassandra involving constraints.… Read more
As many companies consider moving data to NoSQL, Cassandra may be the choice. In this series, Shel Burkow discusses design considerations for porting a SQL Server schema to Cassandra. The first article explains the Cassandra primary key.… Read more
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