Skip to content
Episode 106 Temporal Tables episode artwork

Jul 26, 2017 53 min

Episode 106 Temporal Tables

from SQL Data Partners Podcast

User: What was that record before it was updated? Me: I don't know. Maybe I could restore a backup? User: Really? You have to do all that? It is just one record. Me: (under my breath) Yes, a record YOU updated. If you have ever had a conversation like this you know how difficult it can be to implement auditing of records as they change. With temporal tables, a new feature, we have the ability to track point in time information about a record without the huge expense of setting up auditing and tracking. While you won't want to use this on every table, when there are tables with sensitive data you want to audit from time to time, this feature will come in handy. We are happy to have Randolph back on the program with us to talk about this new feature. The shownotes for today's episode is found at http://sqldatapartners.com/2017/07/25/episode-106-temporal-tables/ and have fun on the SQL trail.

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Episode 106 Temporal Tables

0:00 53:16

No transcript yet.

Requests help us decide what to transcribe next.

Share this episode

Similar podcasts

The Course Mentors Podcast The Course Mentors Hey there, future course creator! Ever feel like turning your know-how into an online course is like trying to solve a Rubik's cube blindfolded? Well, grab your headphones because "The Course Mentors Podcast" is here to be your secret weapon! Meet Aimee and Odette (that's us!), your new best friends in the course creation world. We've been in the trenches for over a decade, and for the last five years, we've been rocking the online course space. Now we're here to spill all our secrets in bite-sized, 15-20 minute episodes that'll fit perfectly in your coffee breaks. No fluff, no filler - just real, actionable advice that'll take you from "um, what's a landing page?" to "holy moly, I just hit six figures!". We're talking everything from crafting your course to marketing it like a pro and building a business that'll have you pinching yourself. Whether you're dreaming of ditching the 9-to-5 grind, adding a sweet extra income str

Frequently asked questions

How long is this episode of SQL Data Partners Podcast?

This episode is 53 minutes long.

When was this SQL Data Partners Podcast episode published?

This episode was published on July 26, 2017.

Can I download this SQL Data Partners Podcast episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.