SQL Server 2016 takes this one level further and lets you transform JSON data in table rows. This ability might save a lot of work and CPU cycles off your code as now you can push the raw JSON text to ...

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