A data transformation problem in SQL and Scala: Dovetailing declarative solutions Part II

In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.…

A data transformation problem in SQL and Scala: Dovetailing declarative solutions

This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a...

Translating a SQL Server Schema into a Cassandra Table: Part III Many-to-Many, Attribute Closure and Solution Space

In the third and final article of the series, Shel Burkow demonstrates several designs that cover many-to-many relationships, attribute closure,...

Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints

Complex integrity constraints are more challenging to enforce in Cassandra than they are in a relational database. In this article,...

Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key

As many companies consider moving data to NoSQL, Cassandra may be the choice. In this series, Shel Burkow discusses design...

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...