Temporal Tables and Their Roles in ETL and Data Warehouse


It is my pleasure to speak in PASS 24 Hours session for Evolution of Data Platform on the topic above. I look forward to meet you all in this webinar. registration is free, but limited. So reserve your seat now. Here are some information about my session and 24HOP.


24 Hours of PASS is the virtual PASS conference that happens in 24 consecutive hours, 1 session each hour; that makes 24 sessions in 24 hours! Amazing, isn’t it? If you haven’t been in such conference I have to tell that this is a marathon for you. Many great sessions from great speakers around the world on particular topic. Once you join you want to be involved in all. You will be surprised by the amount of high level content presented in this 24 hours.

Next 24HOP is dedicated to Evolution of Data Platform, means SQL Server 2016, Cortana Intelligence, Azure ML, R, Azure HD Insight, Hadoop and more. It is my pleasure to speak in this 24HOP on a data warehouse/ETL topic, and I invite all of you to join if you are interested to learn new features of SQL Server 2016 for Temporal Tables and its role in ETL and DW.

My Session: Temporal Tables and Their Roles in ETL and Data Warehouse



Temporal tables are new type of database tables introduced in SQL Server 2016, these tables are system-versioned and keep history of changes (insert, delete, update) of everything happened on data rows. Retrieving change log from these tables are easy. These tables can simply tell you what was the data at specific point of the time in the table. These tables works with datetime2 columns to keep FROM DATE and TO DATE information of each change. This means these tables can be used for implementing changes in dimensions, yes you know what it called; Slowly Changing Dimension!

In this session you will learn how Temporal Tables works, and you will also learn through live demos how to use it in your Data Warehouse for Slowly Changing Dimension. You also learn some tips and tricks when you work with Temporal Tables for SCD implementation.

Date and Time

26 May 2016 00:00 GMT

Link to Join


List of all Sessions

Search sessions by track:
Application & Database Development
BI Information Delivery
BI Platform Architecture, Development & Administration
Cloud Application Development & Deployment
Enterprise Database Administration & Deployment

There are heaps of great sessions by great speakers, and here is the agenda:


Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for 12 continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand, Power BI Summit, and Data Insight Summit.
Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.

Leave a Reply