THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Database Design » Temporal Data   (RSS)
  • Temporal Tables - Part 4 - Synchronizing changes across tables

    So way back in June of last year, when I started this series on Temporal Tables: Part 1 - Simple Single Table Example, Part 2 – Changing history; and even in Part 3 - Synchronizing Multiple Modifications; I only referenced one table. In this entry, I want to get down to what will actually be a common concern. I want my objects to be consistent, ...
    Posted to Louis Davidson (Weblog) by drsql on May 9, 2016
  • Temporal Tables – Part 2 – Changing history

    After my post yesterday, I had planned to take a break for Independence Day holiday, but a commenter asked a question that piqued my interest. How might you edit history? Well, the answer is simple, but the process isn’t exactly simple. Basically, you have to turn off system versioning, update history, and reapply system versioning. Not difficult, ...
    Posted to Louis Davidson (Weblog) by drsql on June 30, 2015
  • Temporal Tables – Part 1 - Simple Single Table Example

    In my first entry in my series of posts on DB Design Book Topics, I want to start with a pretty interesting topic, Temporal Tables. It is a very cool new feature that takes something that used to be very painful (capturing history of changes to a table, allowing the user to see the data at a point in time), and makes it very easy. So if you have ...
    Posted to Louis Davidson (Weblog) by drsql on June 29, 2015
Privacy Statement