June 18, 2020 – Introduction to SQL Server Temporal Tables by Tim Mitchell

Denver SQL Server User Group

June 18, 2020
6:00 pm to 7:30 pm Mountain Time

Meeting Agenda

5:30 – 6:00 Networking – we’ll open the video call 30 minutes prior to the meeting start
6:00 – 6:15 User Group Business
6:15 – 7:30 Main presentation

Main Presentation:

Introduction to SQL Server Temporal Tables

SQL Server temporal tables are a relatively new introduction to the SQL Server stack, representing a unique way to store temporal (time-based) data. These system-versioned temporal tables can be used to create versions of your data over time, allowing for point-in-time historical analysis of changed data.

In this presentation, we will introduce and review the essentials of system-versioned temporal tables in SQL Server. We will cover the concept of temporal storage, and demonstrate how these are implemented in SQL Server. Finally, we will demonstrate the use of temporal tables through several realistic examples.

By 

Tim Mitchell

Tim Mitchell is a business intelligence architect, author, and trainer.  He has been building data solutions for over 15 years, specializing in data warehousing, ETL/SSIS, and reporting.  He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and has been recognized as a Microsoft Data Platform MVP each year since 2010.  Tim is the founder and principal data architect at Tyleris Data Solutions, a consulting firm focused on delivering on-premises and cloud-based solutions on the Microsoft data platform.

As an active member of the community, Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts.  Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2.  He is a member of the Boulder BI Brain Trust, and is active in the North Texas SQL Server User Group in the Dallas area.

You can visit his website and blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.

Join Zoom Meeting
https://zoom.us/j/3037207595?pwd=dkNzejFvZmRKeVcyemMwTmxZeHlEZz09

Meeting ID: 303 720 7595
Password: 725691
One tap mobile
+13462487799,,3037207595#,,1#,725691# US (Houston)
+16699009128,,3037207595#,,1#,725691# US (San Jose)

Find your local number: https://zoom.us/u/abvh3FIjTF          

Questions? Send an email to board@denversql.org.
Connect with us online:
Website: Denversql.org
Twitter: @denversql
Meetup
LinkedIn