With the native JSON features in SQL Server 2016, the landscape changes and using SQL Server in an Event Sourcing scenario becomes realistic. However, how would you query JSON from a database table?

A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used as a virtual table to simplify queries and add a layer of security to your base ...

In an earlier column, I showed how to create a temporal table in SQL Server 2016 or Azure SQL Database. Once you've defined a temporal table, SQL Server automatically keeps a history of all the ...