Picking the right team

Picking The Right Team

Years ago, back before I became a consultant, a job search led me to an interview with a technical company. The company was large enough to offer a variety of challenges with room for advancement, but wasn’t so big that one would get lost in a sea of employees. The company’s line of business was one that I was already…

Read More

SQL Server temporal tables

SQL Server Temporal Tables

Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in which relational databases maintain row-level versioned copies of data. When using temporal data, the database does automatically what many DBAs and application developers have had to do manually for years to track point-in-time versioning for individual tables. Starting in 2016, Microsoft added SQL Server temporal…