In SQL Server 2014, Microsoft is introducing the In-Memory OLTP database engine which essentially performs the entire I/O operation set against selected tables straight from memory.

From Python to adaptive query optimization to the many cloud-focused changes (not to mention Linux!), Joey D'Antoni takes you through the major changes coming to SQL Server 2017.

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