News

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 ...
In Azure SQL Database you can also set a HISTORY_RETENTION_PERIOD (and should be able to do it in SQL Server 2017) to control how far back in time your history will extend. Converting Existing Table ...