SQL Server 2019 webinar by Bob Ward

The recording of Bob Ward webinar on “SQL Server 2019” is now on YouTube. 

Here is the blog: https://www.dataplatformgeeks.com/sql-server-2019-bob-ward-recorded-webinar-resources/

SQL Server Temporal Tables Overview

For many applications, it's a common requirement to get details about data modifications that have occurred in a SQL Server table. Tables can have multiple updates and deletes for different reasons, and there may be a need to keep the different versions of records. Prior to SQL Server 2016 you would have to use triggers to keep track of data changes in tables, but now we can use the built-in temporal table feature that was first released in SQL Server 2016.

Read more at https://www.mssqltips.com/sqlservertip/5781/sql-server-temporal-tables-overview/

DevOps and Databases

A robust DevOps environment requires having continuous integration for every component of the system. But far too often, the database is omitted from the equation, leading to problems from fragile production releases and inefficient development practices to simply making it harder to on board new programmers.

In this article, it is discussed the unique aspects of databases, both relational and NoSQL, in a successful continuous integration environment.

Read more https://www.infoq.com/articles/DevOps-Databases