Fox Valley Microsoft Data Platform

Next Meeting

Wednesday,

May

01

Tracking Data Transformations Using Temporal Tables

Please join us for the presentation on May 1st at the Secura Insurance (East Building) where we will have special guest Thomas M. Lane, PhD from Talavant Discussing "Tracking Data Transformations Using Temporal Tables".

Thomas has been living and breathing Microsoft databases for over twenty years and is now relishing his position as a DW Consultant at Talavant (www.Talavant.com). After receiving his Ph.D. in Chemistry and following three years as a post-doc at Marquette University, Thomas left the world of science for a career in IT. He has worked as a programming and database instructor, a VB and C# developer, and for the past fourteen years worked with SQL server as a DBA, ETL specialist, and Data Architect at various Midwestern companies.

A little bit about Thomas's discussion:
"Along with change tracking and change data capture, Microsoft has introduced a new method for tracking data changes within its databases called Temporal tables. Microsoft introduced temporal, or system-versioned, tables in SQL Server 2016 as a new database feature. A temporal table truly introduces two tables into the mix: one for current data and another for historical data. This talk will show how the feature is implemented and used along with a discussion on the common usage for temporal tables. Scripts will be explored for the automation of the creation of temporal tables along with its use in data warehousing."

If you missed our previous meetups you can always catch them on our Fox Pass Youtube channel!

Link: https://www.youtube.com/channel/UCIMxqUC98A69Cm8t4GFwuSw

Featured Presentation:

Tracking Data Transformations Using Temporal Tables

Thomas Lane, DW/BI Consultant Talavant

Along with change tracking and change data capture Microsoft has introduced a new method for tracking data changes within its databases called Temporal tables. Microsoft introduced temporal, or system-versioned, tables in SQL Server 2016 as a new database feature. A temporal table truly introduces two tables into the mix: one for current data and another for historical data. This talk will show how the feature is implemented and used along with a discussion on the common usage for temporal tables. Scripts will be explored for the automation of the creation of temporal tables along with its use in data warehousing.

About Thomas:
Thomas has been living and breathing Microsoft databases for over twenty years and is now relishing his position as a DW Consultant at Talavant (www.Talavant.com). After receiving his Ph.D. in Chemistry and following three years as a post-doc at Marquette University, Thomas left the world of science for a career in IT. He has worked as a programming and database instructor, a VB and C# developer, and for the past fourteen years worked with SQL server as a DBA, ETL specialist, and Data Architect at various Midwestern companies. Thomas recently received his MSCE in Data Management and Analytics.

Supplementary Materials

The following event attachments are available to you:

Bronze Sponsors

 

Hosts

 

Other Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 

 

Brent Ozar Unlimited

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids